Microsoft Access 2002, 2003 or 2007
Prior Knowledge: This one-day course is intended for delegates with experience of Access who need to develop more advanced skills. The course will demonstrate how the many new features in Access can be used effectively.
Aims and Objectives:
By the end of the course participants will be able to:
- Modify tables
- Insert Lookup columns
- Set field properties
- Set Yes/No formats
- Set default values
- Propagate field properties
- Use Operators in Queries
- Use And/Or/Between conditions
- Design Advanced Queries
- Create calculated fields
- Create Action Queries example
- Create an Update Query
- Use the Advanced Query to Find Duplicates
- Use advanced database features
- Importing Data
- Use advanced form design example
- Create Combo Boxes
- Use advanced report design
- Group Data in a Report
- Create and use subforms and subreports
