Microsoft Access Introduction

Course Duration is 1 Day

£255.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

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.

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

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

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. 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.

 

Measuring The Success

 

The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!

To evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. The cost of the session is £595+VAT delivered virtually and 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.