(9:30 a.m. - 12:30 p.m. and 2:00 p.m. - 5:00 p.m.)

• Introduction to MS Access
  1. What is a Database?
• Overview of Access Interface
  1. Use the Ribbon
  2. Contextual Tab
  3. Backstage View
  4. Quick Access Toolbar
  5. Configure the Navigation Pane
  6. Use Action Bar
• View and Organize Information
  1. Move Among Records
  2. Enter, Edit and Delete Records
  3. Format Datasheets
  4. Add/ Delete a Column in a Datasheet
  5. Filter and Sort Records
  1. Blending options
  2. Adjustment layer
  3. Clipping mask
• Create and Use Databases
  1. Create Access Databases
  2. Open Database Objects in Multiple Views
• Create and Modify Tables
  1. Create Tables
  2. Modify Field Properties
• Create and Modify Queries
  1. Create and Modify Select Queries
  2. Manage Source Tables and Relationships
  3. Perform Calculations in Queries
  4. Create and Modify Action Queries
• Create and Modify Reports
  1. Create Reports
  2. Apply Report Options
  3. Print a Report