Microsoft Access Essentials training course

Overview

In this two-day course, you will learn the fundamental skills required to design and build databases in Microsoft Access. From the basics such as database terminology, the course will take you through the process of designing and building a database, constructing tables and table relationships, creating queries to search and interrogate your data, and also provide you with the skills to create forms to ease data entry, and reports to output your information.

Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, like research scientists and accountants, data management may be a strong component of the job. For others, data management may consist of an incidental job responsibility, such as time reporting or recording a sale.

A relational database application such as Microsoft Access can help you and your organisation collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool, or you can use it as a construction set to develop applications for an entire department or organisation.

This course is suitable for users of Access 2010, 2013, 2016, and 2019/365.

This Microsoft Access Essentials training course is taught via virtual classrooms and on a face to face basis and can be run just for your company. Contact us for dates and official quote via info@optimuslearningservices.com or call 0845 519 7408 and prices.

Prerequisites

Use a mouse
Type and use a keyboard
Navigate through Windows files and folders
Work with Windows – minimise, maximise, open and close
Familiarity with the list-related tools in Microsoft Excel such as sorting and filtering would be beneficial, though not essential

Dual monitor setup is required for when attending this course via the remote delivery method.

Learning Outcomes

Identify the common objects of an Access database
Design and build the structure of a database
Input and maintain data
Design user-friendly data entry forms
Search the database using queries
Generate reports from your data

Course Outline

Introducing Microsoft Access

The Access environment

Database terminology

Access database objects
Fields and records
Properties

Designing a database

Planning and designing a table
Creating fields
Setting common field properties
Defining key fields

Working with table data

Entering and editing data
Sorting and filtering table records
Deleting records

Relationships

Why use table relationships?
Relationship types
Working with table subdatasheets

Querying a database

Creating simple Select Queries
Specifying query criteria
Sorting query results
Adding calculated fields

Designing Forms

Creating simple forms for data entry
Designing custom forms
Working with form sections

Designing Reports

Creating basic list reports
Working with grouping and sorting in a report
Adding totals to a report

Related Course

Microsoft Access Advanced

Who trusts us

"The Optimus service forms a vital part of the overall L&D solution. They give us confidence that they add value, are open and honest, provide the best training and secure the best training for us; they are an extension of our own L&D team"
Learning and Development Manager
VocaLink
"Working with Optimus means we now have a trusted resource for both our L&D team and employees which allows us to drive more targeted needs. Their services make it easy to get started, and their recommendations are very clear and self-explanatory. "
Head of Learning and Development
Arthur J. Gallagher
"Optimus are our ‘go to’ training broker for securing the best deals on training courses, be that in the UK or in one of our European locations.Their service supports our in-house L&D team and saves us time researching training. Their customer service is prompt and reliable."
Global Head of L&D
Elavon Inc
“They are quick, professional and great at what they do. We use Optimus to help source external training, when we lack any internal offering and want to bring in expertise. They always recommend great options.."
L&D Executive
Thomas Miller
“Optimus have been outstanding and supported us with sourcing high quality and affordable training for our staff. They are a very professional organisation with excellent response times to our training queries."
Learning & Development Manager
Shelter
"We used Optimus to help us deliver in-house training programmes when we lacked the internal resource. They really understood our requirements and provided training which improved performance."
Learning and Talent Development Manager
Catalyst Housing
"The Optimus team provides value to a busy HR department by seeking the best fit training solutions and then moving onto controlling the very time consuming training administration."
UK HR Manager
Welbilt
"Our partner Optimus facilitates and helps us deliver an outstanding quality of training within our company. They have taken away the pain of follow-ups with different vendors, managing the logistics end to end and helping us provide learning without wasting efforts and time. I would always recommend them to organisations who wish to have a partner help with their L&D."
Head of Technology Academy
Global shipping company