Microsoft Access 2016: (A) Fundamentals - EOD

Back to List

Course: 2112838 - Microsoft Access 2016: (A) Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Discover the fundamentals of creating and working with Access databases. Learn what a relational database is and what it can do for you. Find out how to create and edit tables, set field properties, create table relationships and use simple queries, as well as how to create basic forms and basic reports.

Prerequisites

Course Outline

  • Opening Databases
  • Creating Simple Access Databases
  • Using Database Templates and Web App Templates
  • Modifying Table Data
  • Using Quick Search and Find and Replace
  • Adding Datasheet Totals and New Records
  • Updating Records with a Query
  • Appending Queries
  • Navigating Through and Printing Records
  • Sorting and Filtering Records
  • Creating Lookups
  • Exploring Relational Databases and the Design Process
  • Creating Guidelines for Determining Fields
  • Using Guidelines for Grouping Fields into Tables
  • Working with Primary Keys, Foreign Keys, and Composite Keys
  • Working with Table Relationships
  • Creating Tables
  • Importing Tables from Other Databases
  • Inserting and Deleting Fields
  • Configuring Fields to Auto-Increment
  • Setting the Default Value for a Fields
  • Creating Table Relationships
  • Understanding Referential Integrity
  • Editing Relationships
  • Joining Data from Different Tables in a Query
  • Understanding Types of Queries
  • Using the Run Command
  • Designing, Saving, Deleting, and Renaming Queries
  • Sorting and Filtering Data in a Query
  • Using Comparison and Logical Operators
  • Sorting, Grouping, and Formatting Query Fields
  • Performing Calculations in a Query
  • Creating New and Modifying Existing Forms
  • Saving and Deleting Forms
  • Creating New and Modifying an Existing Report
  • Saving and Deleting Reports
  • Adding Controls to Reports
  • Modifying Control Properties
  • Managing Labels and Inserting Images
  • Enhancing the Appearance of Reports with Galleries and Themes
  • Adding Headers or Footers to Reports
  • Inserting Page Numbers to Reports
  • Printing Reports
Course Type: In Classroom
CEU: 0.60
Sections:
Section#: 4613
Section Meeting Dates and Times:
11/1/2017: 1:30 PM - 4:30 PM
11/2/2017: 1:30 PM - 4:30 PM

Location:
Suite 2201 - Lab 2203
General Services Complex (GSC)
750 Agronomy Rd.
Description:

Category: Technology Training - Database

Register and View Schedule

Add to Course Waitlist