Course Length
Full day
Prerequisites
Access 2007 Intermediate or equivalent experience
Course Description
This course is for the individual whose job responsibilities include the need to create complex Access databases by structuring existing data, writing advanced queries, enhancing forms and reports, working with macros, and performing database maintenance.
Course Topics
- Analyze tables
- Create a junction table
- Improve the table structure
- Create subqueries
- Create unmatched and duplicate queries
- Group and summarize records using criteria
- Summarize data using a crosstab query
- Create a PivotTable and a PivotChart
- Create a macro
- Attach a macro
- Restrict records using a condition
- Validate data using a macro
- Automate data entry using a macro
- Display a calendar on a form
- Organize information with tab pages
- Display a summary of data in a form
- Include a chart in a report
- Print data in columns
- Cancel printing of a blank report
- Create a report snapshot
- Link tables to external data sources
- Manage a database
- Determine object dependency
- Document a database
- Analyze the performance of a database
What Participants Receive
Each participant receives a guide containing step-by-step instructions and practice exercises.
