Course Description

Microsoft Office 2010
Intermediate Access
6 hours 9:00 am – 4:00 pm

• Access object overview: tables, queries, forms, and reports
• Review of tables and queries
• Table relationships
• Introduction to forms
• Creating a data entry form
• Forms with subforms
• Form properties
• Introduction to reports
• Report sections
• Aligning/sizing controls on reports
• Creating a switchboard
• Command button wizard
• Startup properties

In this course you will learn the basic four objects in Access and the purpose for each of these objects. You will review tables and queries and then learn to work with forms. You will create data entry forms and learn the benefit and use of subforms in Access. You will create reports which allow for printing of the data stored in the database and learn to use the various sections in an Access report to control the way your data prints. You will build a form that opens automatically when the database is opened and you will use the Control Wizard to create buttons on this form that take actions in the database. Finally, you will explore the startup properties in Access which are the settings that control how the database displays upon opening.