Microsoft Access Intermediate
£255.00 Plus VAT
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.
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
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
Creating Append queries
Creating update queries
Creating delete queries
How to Book
If you are interested in booking this course, then please select your desired date and then select book now to complete the booking.
We will then contact you to confirm availability and any additional required details.