Course Length
Full day
Prerequisites
Access 2010 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 reports, working with macros, and performing database maintenance.
Course Topics
Structure Existing Data
- Restructure the data in a table
- Create a junction table
- Improve the table structure
Write Advanced Queries
- 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
Simplify Tasks with Macros
- Create a macro
- Attach a macro
- Restrict records using a condition
- Validate data using a macro
- Automate data entry using a macro
Create Effective Reports
- Include a chart in a report
- Print data in columns
- Cancel printing of a blank report
- Publish reports as PDF
Maintain an Access Database
- 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.
