Duration: 1 day
Trainer: WC315P
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...
Course Aims:
This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access in order to increase their knowledge and productivity.
Who Should Attend?
Users with a good understanding of Microsoft Office Access who want to expand on their capabilities in a short space of time. TSome of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Course Outline:
Advanced Data Management
- Referential Integrity
- Table Relationships
- An Introduction to SQL
- Modal Dialog Boxes
Advanced Form Tasks
- Using Subforms
- Creating a Navigation Form
- Advanced Form Controls
- Exporting a Form
- Other Form Tasks
Pivoting Data
- Creating a PivotTable
- Using PivotTables
- Advanced PivotTable Tasks
- Creating a PivotChart
- More on PivotCharts
SQL and Microsoft Access
- Understanding SQL
- Using the SELECT Statement
- Using Subqueries
- Using SQL Joins