Microsoft Access Basics
The topics listed under this level of training are a snapshot only of the skills which fall under the Access Introduction category. If you are interested in this level of training, please contact us to register your interest using the form below. As we provide customised training for groups the next step after you contact us involves assessing the current skill levels of the students. This helps us to determine exactly which topics you require training in and tells how we can group the students with similar skill levels. After you have completed this level of training, you may want to up-skill to the next level: Microsoft Access Intermediate.
This level includes:
Navigating around the Access environment
- Customising & moving the Quick Access toolbar
- Customising the ribbon
- Viewing layouts
- Saving files
- Finding your saved files
- The Access Lock file
Object Definitions
- Records
- Fields
- Data
- Database?
- Tables Objects
- Form Objects
- Report Objects
- Query Objects
Databases
- Create a database using the wizard
- Manually Create a database in Design View
- Copy/Paste data to Create a database
- Create a database via template
- Save a database
- Open an existing database
- Exit Access correctly
Tables
- Create a Table using Wizard
- Use Design View to Create a Table
- Create a Table by entering Data
- Design View
- Datasheet View
- Import a Table from Excel (2 ways)
- Save a Table
- Adding additional Fields to an existing Table
- Deleting Fields
- Renaming Fields
- Field Properties
- Primary Keys
- Foreign Keys
Forms
- Creating Forms using Wizard
- Basing Forms on Queries
- Basing Forms on Tables
- Forms with linked Sub-Forms
- Adjusting Form’s Design
- Bound vs Unbound Fields
- Headers & Footers
- Graphics & Formatting
Queries
- Create Query using Design View
- Create Query using Wizard
- Basing Queries on Tables
- Basing Queries on Queries
- Sorting a Query
- Show/hide Fields
- Adding criteria
- Select Queries
- Using dates in Queries
- Formatting Fields in Queries
Reports
- Create a Report using the Wizard
- Create a Report based on Query
- Report Header & Footer
- Design / Layout / Report / Print Preview views
- Formatting Fields
- Aligning Fields
- Duplicating Fields
- Naming Fields
- Stacking Fields
- Sorting & grouping
- Add a Field to an existing Report
Finding Access Help
- Searching the Help Index
- Online Help
- Tutorial Help
- Customised Help using F1
Printing
- Selecting your printer
- Setting a default printer
- Specifying the amount of copies
- Setting the print area
- Printing a Table
- Printing a Query
- Scaling pages to fit
- Orientation
- Adjusting margins/headers/footers
Database Tools
- Relationships explained
- Object Dependencies
- Compact and Repair