Course description
Microsoft Access Training | In-House Access Courses
This course is designed for people who want to discover more about the features and operations in Microsoft Access so that they become more efficient when manipulating and analysing data. The course quickly takes you from beginner level to more advanced topics.
Upcoming start dates
Suitability - Who should attend?
No previous experience of Microsoft Access is necessary, however delegates should have a previous understanding of working with computers.
For more information on suitability, please send an enquiry here
Outcome / Qualification etc.
Upon successful completion of this Microsoft Access course, students will be able to:
- Navigate within the Microsoft Access application environment, create a simple database, and customise Access configuration options.
- Organise and manage data stored within Access tables.
- Use queries to join, sort, and filter data from different tables.
- Use forms to make it easier to view, access, and input data.
- Create and format custom reports.
All delegates will take their skills and knowledge to the next level. This will result in them not only feeling more confident when working in Access but also become more efficient when manipulating and analysing data.
Certificate of Attendance
Training Course Content
Getting started with Access
- Access Overview/Database Design Theory
- What is a Relational Database
- Screen Elements and Help Tools
Tables
- Using the Table Wizards
- Manual Creation of Tables
- Fields, Data Types and Properties
- Input Masks
- Data Validation
- Importing Data
- Primary Keys and Relationships
Inputting Data
- Adding data using the Table View
- Adjusting the column widths
Importing Data
- Primary Keys and Relationships
Finding Records
- Using the Find feature to find Records
- Using the Replace feature to replace text
Filters
- Using the filter button to find records
Queries
- Designing Queries
- Query Wizard Overview
- Sorting and Searching Queries
- Multi-Table Relationship Queries
- Update, Append & Delete Action Queries
Forms
- Introduction to Form Design
- Form Wizards
- Toolbox Controls
- Combo Boxes & Command Buttons
- Main/Sub Form Creation
- Creating a Menu Form
Reports
- Report Wizard
- Creating Reports
- Printing Reports
Course delivery details
Our in-house courses are normally scheduled to start at 9.30am and finish at about 4.30pm (however, these times can be amended if requested).
Why choose Keys Training
Over 25 years’ experience of delivering quality Microsoft & Business Skills training.
All Trainers are Microsoft Certified or equivalent.
Scheduled Public and Tailored In-house training throughout the UK.
Request info
Keys Training
Keys Training® provides a Business Skills Training Service throughout the UK. We specialise in delivering one-day instructor-led courses that cover Microsoft Office and Personal Development Skills. Our training courses can be delivered on your site, at one of our venues...