

Microsoft Access
Working with data
This course is for new and existing users of Access who wish to acquire the skills required to enter and extract data using forms, queries and reports.
Objectives
What is a database?
Database terminology
Working with the Ribbon, Tabs and Groups
Modifying the Quick Access Toolbar
Using the Status Bar, zoom & views
Help
Opening & closing an existing database
Navigating between database objects
Â
Working with datasheets
Insert, editing & deleting records
Undo
Field & record navigation
Finding & replacing text
Searching for records
Creating & clearing filters
Criteria expressions in filters
Saving a filter as a query
Â
Formatting & printing datasheets
Font formatting
Changing column width row height
Hiding & unhiding columns
Freezing & unfreezing columns
Previewing & printing datasheets
Â
Queries
Using the query wizard for a simple query
Creating & saving queries
Editing & deleting queries
Running a query
Criteria expressions
Sorting a query
Hiding a query field
Joining tables
Adding calculations to queries
Â
Forms
Using form wizards
Creating a form without a wizard
Saving a form
Form sections
Adding form controls
Editing control & form properties
Using the toolbox
Building calculations in forms
Multi-table forms
Â
Reports
Using AutoReport & report wizards
Creating a report without a wizard
Saving a report
Report sections
Adding & modifying report controls
Sorting & grouping report data
Adding statistical & calculations fields
Previewing & printing a report
Â
No previous knowledge of Access is required however delegates should be able to use a computer.
Prerequisities
Content
© PrimeraTraining 2020


Professionally insured through PolicyBee
We are GDPR compliant. For information on how we handle personal data, and your associated rights, please view our Privacy & Data Protection Notice.