Overview:
This course is designed for those users who wish to step their current knowledge of Access to take advantage of the more complex features. On completion, delegates will understand relational databases and be able to work with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports before tackling PivotCharts and PivotTables.
Audience:
Our Microsoft Access Intermediate course is suitable for those with a basic working knowledge of Microsoft Access.
Pre-requisites:
Working knowledge of Access is required, or our Access Introduction course.
Course Curriculum
What's new in Access | |||
Creating relational databases Details | 00:00:00 | ||
Database normalising Details | 00:00:00 | ||
Introducing relating tables Details | 00:00:00 | ||
Adding referential integrity Details | 00:00:00 | ||
Working with related tables | |||
The lookup wizard Details | 00:00:00 | ||
Changing lookup fields Details | 00:00:00 | ||
Inputting data to related tables Details | 00:00:00 | ||
Defining data entry rules | |||
Using input masks Details | 00:00:00 | ||
Setting a property Details | 00:00:00 | ||
Setting a validation rule Details | 00:00:00 | ||
Using advanced query features | |||
How to join a table in queries Details | 00:00:00 | ||
Creating a calculated field Details | 00:00:00 | ||
Using an action query Details | 00:00:00 | ||
Creating advanced queries | |||
Summarise and group values Details | 00:00:00 | ||
Create a crosstab query Details | 00:00:00 | ||
Using a parameter query Details | 00:00:00 | ||
Creating advanced form design | |||
Working with graphics Details | 00:00:00 | ||
Working with calculations Details | 00:00:00 | ||
Working with combo boxes Details | 00:00:00 | ||
Working with unbound controls Details | 00:00:00 | ||
Using advanced report features | |||
Create customized headers and footers Details | 00:00:00 | ||
Add a calculated value Details | 00:00:00 | ||
Work with sub-reports Details | 00:00:00 |
Course Reviews
No Reviews found for this course.
0 STUDENTS ENROLLED