Main content

Microsoft Access: Accessing the Possibilities

Create and manage your own Access database! Join us as we build and edit queries, tables, forms and reports for data manipulation. Explore various database objects, relationships, and primary keys while learning how to properly and efficiently utilize various Access functionalities. Course is best suited for current Access or intermediate Excel users with knowledge in database and/or table sorting/filtering functions. Homework is assigned between the classes.

After completing this course, students will be able to:

  • Create an Access database with tables, forms, queries and reports
  • Understand Database Objects including tables, forms, queries and reports
  • Construct tables with text, date, numerical, and other fields
  • Use input masks to aid in entering and editing data for SSN, date, and other fields
  • Build queries for data manipulation and working with various types of criteria
  • Create forms for editing, deleting, viewing, and inputting data
  • Establish primary keys for our tables and appropriate relationships
  • Edit tables and fields, queries, forms, and reports to add functionality and customization

Course Content

  • Lesson 1: Introduction to the Access environment
  • Lesson 2: Tables
  • Lesson 3: Primary Keys and Relationship
  • Lesson 4: Datasheet View
  • Lesson 5: Forms
  • Lesson 6: Building a Complex table
  • Lesson 7: Forms and Sub-Forms
  • Lesson 8: Queries
  • Lesson 9: Reports
  • Lesson 10: Queries – Multiple Table, Parameter, and Calculation Queries
  • Lesson 11: Reports – Grouping, Subtotals, and Totals
  • Lesson 12: Tables and Relationship
  • Lesson 13: Queries for Troubleshooting the Databases
  • Lesson 14: Functional Queries
  • Lesson 15: Forms Enhancement
  • Lesson 16: Magic and Menus
  • Lesson 17: Put the Database All Together