Microsoft Access Intermediate

Course Duration is 1 Day

£255.00 Plus VAT

Delivery Method

Face To Face Delivery  Virtual Delivery One To One Coaching Closed Group Course Public Course

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.

How to Book

If you are interested in booking this course, then please select an available date and then click book now to complete the booking. Can’t see a suitable date contact us on [email protected] and we can discuss specific date requirements.

Who Should Attend

This course is valuable for anyone who plans to prototype, build and integrate relational database applications using Access.

Learning Outcomes – by the end of this course you will be able to…

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

Embedding

These follow up coaching sessions help support your colleagues to embed their learning during their skills transfer period.  Applying new skills and changing behaviour takes effort and practice.  After attending a training course many colleagues will find they need support through this transition.  EQV can provide that support with follow up coaching sessions to help embed the learning.

Embedding coaching sessions can be delivered in 90 minute and half day durations.  The facilitator will work with the group to capture feedback about challenges and how to overcome them ensuring success going forward.

Having a formal embedding coaching session will not only increase the success of the skills transfer period but helps create a platform of motivation, inclusivity and commitment within the group.