Microsoft Access Intermediate
This course is suitable for those who have completed the Access Beginners 2 half day courses or have some previous knowledge of Access.
We have broken the course down into 2 half day sessions as we feel that this gives the delegate an opportunity to practice the initial skills and gain confidence before moving on to the second section.
Course duration:
2 x half day sessions
Course Content: Session 1
- Ensure a good understanding of the nature of a database
- Set a primary key
- Use of validation rules
- Use of indexing
- Create a relationship between tables
- Create a query using data from related tables
- Create a label report
Course Content: Session 2
- Use of dropdown/combo boxes
- create a calculated field in a query
- Create a report using data from more than one table
- Create a grouped report
- Use functions in a grouped report
- Make changes to a report in design view
- Consolidation exercise
Description:
This course, broken down into 2 bite size sessions, will build on your existing skills in Access. You will be able to create relationships between tables and then query these related tables to create queries. You will also be able to create queries using operators and grouped reports.
Call us now on 01403 734431 to book on this course.
