MS Access Introduction Training
Our Introduction to Microsoft Access training course will teach you the fundamentals of this popular database programme. The course focuses on the basic principles of creating and using tables, queries, forms and reports.
Course Summary
This course focuses on the following aspects of Microsoft Access:
- Navigating the Microsoft Access interface
- Creating and saving an Access database
- Creating tables and effectively storing data in tables
- Creating select queries to interrogate your data
- Creating forms to improve the user interface of an Access database
- Creating professional looking reports from the data held in your database
- Exporting and importing data
Course Prerequisites
No previous experience of Microsoft Access is required to attend this course.
What’s Included with the Training?
- Delegates will receive a comprehensive pdf reference guide that covers the content of the course.
- Delegates will have created a working database at the end of the course which they can refer to alongside the reference guide.
- Course certificate, if required
Course Outline
Our training courses can be delivered onsite at your offices or remotely online. Please note the outline can be tailored – nothing is set in stone! Please download the course outline in pdf format here.
Navigation
- Navigate Using the Navigation Pane
- Document Window Options
- Overlapping Windows
- Tabbed Documents
Tables
- Create and Save a New Table
- Enter Field names
- Specify Data Types
- Use the Lookup Wizard
- Enter Records in a Table
- Sort Data in a Table
- Filter Data in a Table
- Freeze Fields
- Hide Fields
Select Queries
- Create and Save Select Queries
- Add Fields to a Query
- Add Criteria to a Query
- And Criteria
- Or Criteria
- Between And Criteria
Forms
- Create and Save a Basic Form
- Add Fields to a Form
- Create a Split Form
- Create a Navigation Form
- Use the Form Wizard
- Understanding Form Views
- Apply Formatting to a Form
Reports
- Create and Save a Basic Report
- Use the Report Wizard to Create a Report
- Apply Grouping
- Sort Data in a Report
- Understanding Report Views
- Adjust Column Widths
- Rearrange Columns
- Page Setup Settings – margins, orientation and page size
- Padding and Margins
- Add a Logo to Your Report
- Add Page Numbers to Your Report
Importing & Exporting
- Import Text and Excel Files into Your Database
- Export from Access to Excel and Word.