Microsoft Access
Pitman Training
- 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.