Microsoft Access 2007 Level 2
Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
|
Prerequisites
- Microsoft Access 2007 Level 1 or equivalent experience
Outline
Section 1 - Building the Database
Setting Up The Tables
Relationships Review
Establishing Relationships and Referential Integrity
Single Field Indexes
Multiple Field Indexes
Checking Database Integrity and Entering Sample Data
Summary of Section 1
Section 2 - Advanced Form Creation Part 1
The Toolbox
Creating an Invoice
The ‘Drop Down’ Combo Box
Creating Subforms – A Review
Summary of Section 2
Section 3 - Advanced Queries part 1
Building Expressions With Queries
Operators, Literals, Identifiers, and Functions in Expressions
Summary of Section 3
Section 4 - Advanced Form Creation Part 2
Using a Query-Based Sub-form
Calculated Fields With Forms
Creating a Switchboard
Summary of Section 4
Section 5 - Creating Orders
Using the Invoice To Create Orders
Summary of Section 5
Section 6 - Advanced Queries Part 2
Calculating Totals
Parameter Queries
Summary of Section 6
Section 7 - Advanced Reports
Report Design
Mailing Labels
Summary of Section 7