MU Software Training

Microsoft Access 2007

Microsoft Access is a database program designed to enter, store and retrieve data through the use of queries, forms & reports. In addition to training on the use of the program, our courses also cover basic concepts of effective database design.

We recommend that participants take the Microsoft Access 2007 courses in the following order: Access 2007 Fields & Tables first, Access 2007 Relationships & Queries second, and Access 2007 Forms & Reports third. After the Forms & Reports class, the remaining Access 2007 courses may be taken in any order.

Access 2007 Primer

Recommended Prerequisite: Experience with Access 2003 and familiarity with creating tables, forms, and reports in Access

Note: This course only covers the Ribbon and new features in the program, not basic use of Access.

Upon completion of this course, the student will be able to:

• Work with the Ribbon
• Examine New Features

Access 2007 Fields & Tables

Recommended Prerequisite: General knowledge of the Windows operating environment and experience with one or more Microsoft applications such as Outlook, Word, PowerPoint or Excel

Upon completion of this course, the student will be able to:

• Recognize Database Objects
• Create Tables
• Add Fields
• Assign Data Types
• Navigate Fields
• Navigate Records
• Set Field Properties
• Format the View of a Table

0.3 CEU's available for this course for an additional $25.

Access 2007 Relationships & Queries

Recommended Prerequisite: Access 2007 Fields & Tables

Upon completion of this course, the student will be able to:

• Find Records
• Apply Filters
• Create Relationships
• Use the Simple Query Wizard
• Create a Query in Design View
• Modify Queries
• Use Operators in Queries
• Apply Advanced Select Queries

0.3 CEU's available for this course for an additional $25.

Access 2007 Forms & Reports

Recommended Prerequisite: Access 2007 Relationships & Queries

Upon completion of this course, the student will be able to:

• Create a Form using the Wizard
• Create a Report using the Wizard
• Manipulate Controls in Design View

0.3 CEU's available for this course for an additional $25.

Access 2007 Advanced Forms, Reports & Queries

Recommended Prerequisite: Access 2007 Forms & Reports

Upon completion of this course, the student will be able to:

• Add Form Command Buttons
• Build Controls
• Set Form Tab Order
• Add Report Sections
• Create Calculated Controls
• Create a Running Sum
• Activate Action Queries
• Apply Advanced Query Wizards

Access 2007 Macros & Data

Recommended Prerequisite: Access 2007 Forms & Reports

Upon completion of this course, the student will be able to:

• Use SubForms and SubReports
• Add Macros
• Build Switchboards
• Use ActiveX Controls
• Import and Export Data

Access 2007 Customization, Indexing & Replication

Recommended Prerequisite: Access 2007 Forms & Reports

Upon completion of this course, the student will be able to:

• Create Custom Toolbars
• Work with Indexes
• Use Access & the Internet
• Replicate a Database
• Use Advanced Database Features
• Use Charts