Microsoft Access Intermediate
£285.00 Plus VAT (per person)
Have more than 2 delegates? Talk to us about our closed group courses.
Delivery Method
Open Public Courses – Virtual Delivery Only Closed Group Courses – Face To Face and Virtual Delivery
Business Benefit
With the amount of data being stored in databases these days, solid database design is more important now than it ever has been. By learning about relational databases and the additional benefits they give you, your database will always work in the most efficient way. This course provides underpinning knowledge towards the Microsoft Office Specialist Qualification.
Who Should Attend
This course is valuable for anyone who plans to prototype, build and integrate relational database applications using Access.
Learning Outcomes
Understand Relational Database design
Create a relational database
Assign Primary keys and indexes
Create multi-table forms
Create multi-table select queries
Create advanced queries – Append, Update and Delete
Course Content
Designing multi table databases
Assigning Primary Keys
Assigning an Index
Linking tables through relationships view
Setting Referential integrity
Creating Main / Sub Forms
Creating linked forms
Creating multi-table queries
Creating inner and outer joins in queries
Calculations in queries
Group & Total queries
Parameter Queries
Creating Append queries
Creating update queries
Creating delete queries
How to Book
Dates below represent open public courses only. To book this course, please select an available date and click the book now button below to complete the booking by Credit Card or via Invoice. Have two or more people to train – you may consider a closed group course. Contact us on [email protected] to discuss specific date and delivery requirements.
The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!
Post-course, to evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. This additional session lasts for 2.5 hours.
During the Workplace Implementation session the individuals will either on a 1-2-1 basis or as a group discuss the challenges and successes they have experienced during their skills transfer period.
This will include what they are doing differently as a direct result of the training and how this has positively impacted the organisation.
This is an excellent way to encourage the learning, support the skills transfer into the workplace and act as a measure to evaluate the training.
We compile this information into a report so that you have evidence of your return on investment.