Databases

Access 2016/2013/2010 Part 1 (2007 Upon Request)

This course is designed to help individuals new to Access learn the essential skills of navigating within a database, creating a simple database, creating simple queries, using forms, generating reports, and customizing the Access environment.

Dates & Times

CourseDate & TimeLocationCost
Access 2016/2013/2010 Part 1 (2007 Upon Request)February 2 - 8:30 - 4:30LathamRegister
Access 2016/2013/2010 Part 1 (2007 Upon Request)March 12 - 8:30 - 4:30LathamRegister
Access 2016/2013/2010 Part 1 (2007 Upon Request)April 20 - 8:30 - 4:30LathamRegister

Course Outline

This is a good introductory course for those new to Access or for self-taught users looking to start from square one.

Includes:
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Getting Started with Access

  • Orientation to Microsoft Access
  • Create a simple Access database
  • Get help and configure options in Microsoft Access

Lesson 2: Working with Table Data

  • Modify table data
  • Sort and filter records

Lesson 3: Querying a Database

  • Create basic queries
  • Sort and filter data in a query
  • Perform calculations in a query

Lesson 4: Using Forms

  • Create basic Access forms
  • Work with data on Access forms

Lesson 5: Generating Reports

  • Create a report
  • Add controls to a report
  • Enhance the appearance of a report
  • Prepare a report for print
  • Organize report information
  • Format reports