Microsoft Access Introduction

Course Duration is 1 Day

£199.00 Plus VAT

Delivery Method

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

Business Benefit

Businesses rely on data being easily accessible and quick to find. By using Access to create well designed databases. 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

Anyone who needs to create databases and needs to gain an understanding of the basics of database design, and existing users who wish to improve their knowledge and understanding of Access databases by creating areas in the database to input data and learning how to search for specific information, organise data and grouping information together.

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

Design and create a database
Understand table design and structure
Import and link to external data sources
Create and modify Forms
Create simple Filters
Create Queries
Create powerful Reports

Course Content

Introduction to Databases
Database Terminology
Introduction to the Access Environment
Table Design
Indexing Fields
Adding & Editing Data
Changing the Table Layout
Importing & Linking Data
Find & Replace
Forms
Types of Forms
The Form Wizard
Designing Forms
Calculations on Forms
Filters
Queries
Designing new queries
Formula and Criteria Creation
Calculations in Queries
Reports
Using the Report Wizard
Calculated and statistical fields

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.