What are you looking for

Microsoft Access

Pitman Training

Go to the course page (opens in new tab)

Where
No venue, study anywhere
Starts
Flexible start
Duration
22 Hours
Cost
See cost details
How it's taught
Online

About this course

Lesson One – Including: terminology, working with existing databases, opening a table, query, form and report, entering new records. Lesson Two – Including: planning and design, relationships, defining fields, data types and properties, creating tables, entering data, resizing columns. Lesson Three – Including: defining relationships, creating tables, formatting, modifying, using the input mask wizard, using templates. Lesson Four – Including: editing data, adding records, printing preview, changing page orientation, enforcing referential integrity in a relationship, creating a relationship report, creating a form, working with controls in form design. Lesson Five – Including: Using advanced sort, using filters, importing a table from an external database using a junction table to resolve a many to many relationship, defining a composite (primary) key, using a calculated control on a form, creating a multi-value field. Lesson Six – Including: using query wizard, setting sort criteria, using expressions to set criteria, creating different types of queries. Lesson Seven – Including: adding a field with data validation in a table, creating a form with subform, entering data using a form/ subform combination, creating a split form, creating and modifying the design of a report, using the concatenate expression, adding a subreport to an existing report. Lesson Eight – Including: exporting an html document, understanding object dependencies, importing and exporting a spreadsheet, importing a text file, using the analyze table function, using the analyze performance function. Lesson Nine – Including: adding and modifying a chart, changing the tab order in a form, displaying the current date and time in a form. Lesson Ten – Including: creating a macro, adding a control button to a form, backing up a database, viewing database properties, compacting and repairing a database, encrypting a database using a password, saving the database as a previous version.

What you need before you start

Basic computer skills and an interest in learning about the Access program.

Fees and funding

Please contact your local centre

The qualification you get

Qualification
Database (Beginners)
Awarded by
National Inter-Action Trust
Subject area
Digital technology (users)

Where you study

No venue, study anywhere. This course has no fixed venue.

Course data from the National Careers Service course directory and the Learning Aim Reference Service. Apprenticeship vacancies from the GOV.UK Apprenticeships API. Contains public sector information licensed under the Open Government Licence v3.0. Postcodes are resolved from the ONS Postcode Directory. Contains OS data © Crown copyright and database right 2026. Contains Royal Mail data © Royal Mail copyright and database right 2026. Source: Office for National Statistics licensed under the Open Government Licence v3.0.

Your favourites