MS Access 2002 Intermediate Training Course in London
Our MS Access 2002 Intermediate course will provide users that have existing introduction level skills in Access to build on their knowledge. The intermediate course will focus on building more complex queries, better forms and reports. You will also cover more on table relationships and query joins for your relational database.
To maximize the gain you receive from our MS Access 97 Intermediate training course, it is recommended that you have attended our MS Access Introduction course or that you are at a similar level
Unlike training companies offering scheduled courses, we offer the alternative of your Microsoft Access Training Course delivered in central London on a date of your choice, either onsite or at our offices near Moorgate, Bank or Liverpool Street either 1 to 1 or as part of a group.
Access 2002 Intermediate Training Course
Audience: This course is designed for existing Access users with sound basic skills. The course will focus more on Queries, Forms and reports. We also cover more advanced relationships.
Access 2002 Intermediate Course Objectives: After the course, you will be able to:
- Create Action Queries
- Create Advanced Forms
- Create Advanced Reports
- Understand and Create a Switchboard
Requirements: You must have sound Access skills and understand key concepts of a database, equivalent to our intermediate course contents
Course Duration
This is a 1 day Access 2002 training course. The course starts at 09:30 and runs until 16:30
Course Locations / Schedule
This Access 2002 Intermediate course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.
Access 2002 Intermediate Training Course Contents
Relationships
- Why create relationships between tables?
- Different types of relationships
- Conditions for setting up a relationship
- Referential Integrity
- Cascade Update
- Cascade Delete
Advanced Queries
- Calculated fields
- Parameter Queries
- Summary Queries
- Crosstab Query Wizard
- Editing a Crosstab Query manually
- Top Values Query
- Make Table Query
- Append Query
- Delete Query
- Update Query
Advanced Forms
- Composite Forms including Main Form and sub forms
- Displaying Yes/No values
- Option groups
- Command buttons
- Setting form properties
- Calculations within Forms
- Combining Text Values
- Changing the data source
- Keyboard Short Cuts for Fields
- Tab Order
- Adding and Removing Filters(Selection and Forms)
- Defining Validation Rules
- Template Forms
Advanced Reports
- Using Expressions
- Adding Sub Reports
- Parameter reports
- Report Templates
- The Keep Together property
- Group on and group interval properties
- Advanced Grouping techniques
- Page setup
Charts and Pivots
- Formatting a chart
- Changing the type of chart
- Parameter chart Charting based on individual record
- Creating Pivots


