Microsoft Access 2003 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
- Understand When And How To Implement Full Or Partial Referential Integrity
- Create Single And Multiple Field Indexes And Tables
- Check The Integrity Of A Database
- Use The Toolbox To Design Forms From Scratch
- Use Calculated Fields
- Understand The Expression Syntax Related To Calculated Fields In Sub-Forms
- Use Report Grouping And Create Mailing Labels
Prerequisites
- Microsoft Access 2003 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
- Section 2 - Advanced Form Creation Part 1
- The Toolbox
- Creating an Invoice
- The Drop Down Combo Box
- Creating Subforms - A Review
- Section 3 - Advanced Queries Part 1
- Building Expressions With Queries
- Operators, Literals, Identifiers, and Functions in Expressions
- Section 4 - Advanced Form Creation Part 2
- Using a Query-Based Sub-form
- Calculated Fields With Forms
- Creating a Switchboard
- Section 5 - Creating Orders
- Using the Invoice To Create Orders
- Section 6 - Macros
- Creating a Macro
- Section 7 - Advanced Queries Part 2
- Calculating Totals
- Parameter Queries
- Section 8 - Advanced Reports
- Report Design
- Mailing Labels