Access 2010/13/16 Database User
Prerequisite: Has attended the Windows introduction course or has confidence in the use of keyboard and mouse. To get maximum benefit from the course it is also recommend that they be familiar with Excel.
Duration: One day
| Course Topics |
Course Topics |
Access Fundamentals
* Introduction to databases
* Help
* Understanding database components
Working with Tables
* Fields and records
* Moving around the table
* Add, delete and modify records,
* Format table appearance
* Customizing table structure
* Sort data and filter records
Single Table Queries
* Creating Queries
* Sorting
* Criteria
* AND and OR Queries
* Tips and tricks
Relational Database concepts
* Connecting Tables
* Primary keys
* Relationships |
Multi table Queries
* Adding and removing tables
* Common errors
Using Forms
* Navigating through data
* Adding, modifyingand deleting records,
* Sort and filtering records
Creating and Modifying Form’s
* Auto Forms
* Using a wizard to create forms
* Design view
* Formatting and customising Forms
* Simple Formand control properties
Using Reports
* Print Preview and printing
* Preview Toolbar
Creatingand Modifying Reports
* Auto Reports
* Create Reports using wizards
* Formatting and customising Reports
* Design view |
|
