Microsoft Access Intermediate
Contact us for dates, pricing and how we can customise courses to your requirements: contact us
Microsoft Access Intermediate
Duration: 1 days
Pre-requisites
Attendance or understanding of topics covered on our Microsoft Access Introduction training course.
Attendance or understanding of topics covered on our Microsoft Access Introduction training course.
Relational databases
- Database normalising
- Introducing relating tables
- Adding referential integrity
Related tables
- The lookup wizard
- Changing lookup fields
- Inputting data to related tables
Data entry rules
- Using input masks
- Setting a property
- Setting a validation rule
Advanced query features
- How to join a table in queries
- Creating a calculated field
- Using an action query
- Summarise and group values
- Create a crosstab query
- Using a parameter query
Advanced form design
- Working with graphics
- Working with calculations
- Working with combo boxes
- Working with unbound controls
Advanced report features
- Create customized headers and footers
- Add a calculated value
- Work with sub-reports