Microsoft Access Basic
Course overview
This course is aimed at the new user and aims to provide the knowledge and confidence to create and amend Access databases, input forms, produce basic reports and manipulate data. Throughout the workshop you are encouraged to explore the software to enhance common errors and how to diagnose them.
Topics covered
Fundamentals
- Getting started
- Database terminology
- Access screen tour
- Access objects
- Creating a blank database
- Create from a template
- Ribbon menu
- Working with a window
- Getting help
Queries
- Locate specific records
- Creating and running queries
- Finding information
- Create query joins
- Parameter queries
- Multi table queries Refining results
Tables
- Add/edit tables
- Data entry
- Design and working mode
- Filtering/sorting information
- Modifying
- Primary and foreign keys
- Input masks
- Indexed and data types
Forms and reports
- Create a form/report
- Modify and design
- View and edit
- Moving, deleting and resizing
- Formatting controls
- Prepare to print
- Enhance the appearance
Delivery methodology
(Face-to-face or virtual delivery available)
Small groups
Ideally 6-8 delegates to maximise engagement and interaction levels.
One-to-one
We also provide one-to-one 90 minute support workshops to provide targeted individual support (specific topics to be selected).
Tailored sessions
Talk to us about designing bespoke workshops for your team
Course guide
Download our training course guide and find out more.
Book this course
Call Us: +44 (0)1623 409 824
Email Us: info@futureproof-training.com
