Microsoft Access 2003 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
- Explain 3 steps to normalize a database
- Explain 3 types of database relationships
- Use the Table Analyzer Wizard
- Explain query join properties
- Create command buttons on a form and attach macros
- Create action queries
- Use the IIF function to determine if a condition exists
- Use the Sum and Avg functions in a report
- Link and Import external data into Access
- Explain 2 ways to implement startup security
Prerequisites
- Microsoft Access 2003 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 Importing
- Linking external files to your database
- Importing files
- Section 6 - Database Security
- Adding a Database password
- Startup Security