Creating Databases with Access Course

What will I learn?

Our Creating Databases with Access course is ideal for anyone new to databases as it teaches the design techniques involved in building a database as well as how to create tables, input forms and basic reports.

To attend this session you do not need any previous experience of Access but should have a basic understanding of PCs, including familiarity with a keyboard and mouse.

Book Creating Databased with Access Training

For companies who need to train groups of staff either remotely or in-person.

Two day course
Up to 8 delegates
Flexible in-house training dates

Face-to-face training
In-house or a venue of choice
Virtual training option

Enquire & Book

MEET THE TRAINER

Paul Watson

Paul brings a wealth of understanding and knowledge, specialising in technical training and development in Excel, Power BI and Access. His knowledge with IT systems has been gained both academically and through more than 20 years practical experience in the industry. His strengths are demonstrated as both an IT trainer and as a developer.

Full Course Content

Database Introduction

Database concepts and terminology
Ground rules for database design
Relational database concepts
Getting started in Access
Getting help

Table Design

Creating a table in design view
Data types
Indexes
Default values
Validation rules
Input masks
Setting a primary key

Working with Tables

Adding and editing data
Navigating, adding, editing and deleting records
Finding and replacing data
Sorting and filtering records
Filtering by selection

Table Relationships

Relational database design
Creating relationships
Database integrity and validation

Queries

Creating a select query
Refining the results of a query
Add a calculated field to a query
Create query joins
Multi table queries
Parameter queries

Form Design

Create a form
Modify the design of a form
Moving, resizing and deleting controls
View and edit data using an Access form

Reports

Create a report
Add a control to a report
Format the controls in a report
Enhance the appearance of a report
Prepare a report for print

Sharing Data across Applications

Publish Access Data in Word
Analyse Access Data in Excel
Create a Mail Merge

Enquire & Book

Access Training – Business Benefits

By investing in people, you can give your team all the necessary skills they need to help support your organisation’s goals.

Access Training - People Development

Completing our Access training course will give you additional skills you need to help support your career development.

Flexible Access Training Courses

Online or face-to-face in-house training
Individual delegates or group training
Flexible dates to fit schedules

BOOK YOUR ACCESS TRAINING

Why choose TrainingU?

Passionate

Established over a decade ago by a team of knowledgeable training experts, we are passionate about delivering excellent training that makes a real difference.

Experienced

All our trainers are qualified and experienced Access trainers that will deliver the highest level of training to you and your team.

Collaborative

Working together with our clients, understanding their needs and desired learning outcomes, to deliver a personalised learning solution.

Your complete training solution

Before Training

Our Skills Assessment will ensure staff attend the correct level of training. Based on results, we will organise the training sessions required, who will take them and the level to best match the skills needed.

During Training

We provide first class training with highly experienced trainers. Courses include lots of exercises, practise and interactivity throughout, maximising learning whether delivered online or at your offices.

After Training

We will grant you organisation free access to our suite of online Access resources. In addition, we provide free post training support to ensure your staff utilise their new skills effectively.