Microsoft Access 2007 Level 3
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 2 or equivalent experience
Outline
Section 1- Structure
Understanding The Sample Database
Relationships Review
Section 2 - Getting Database Information
Creating a Form Lookup
Query Join Properties
Form Letters using Reports
Macros and the Where Condition
Using Command Buttons
Creating Reports for MS Word
Trimming Fields
Merging Data and Reports to MS Word
Section 3 - Database Maintenance Using Action Queries
Update Queries
Delete Queries
Make table Queries
Append Queries
Crosstab Queries
Section 4- Calculated Fields with Functions
The Immediate If statement (IIF)
Reviewing Calculations in Sub-forms
The Average and Sum Functions
Section 5- Linking and ImportingLinking external files to your database
Importing files
Section 6 - Database Security
Adding a Database password
Startup Security