Microsoft Access 2007

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

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

• 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

PREREQUISITES:
Access 2007 Fields & Tables

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

PREREQUISITES:
Access 2007 Relationships & Queries

• 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

PREREQUISITES:
Access 2007 Forms & Reports

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

PREREQUISITES:
Access 2007 Forms & Reports

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

PREREQUISITES:
Access 2007 Forms & Reports