Microsoft Access Intermediate (Level 2) 2003 2007 2010 2013 2016 & 365
Training
In Newcastle Upon Tyne
Description
-
Type
Training
-
Level
Intermediate
-
Location
Newcastle upon tyne
-
Duration
1 Day
Become proficient with Microsoft Access by completing this one day course. Individuals will learn more techniques to use with Microsoft Access. These include linking tables, update queries and simple macros.
Important information
Documents
- Course content
Facilities
Location
Start date
Start date
About this course
Learn all the functions that Microsoft Access has to offer at intermediate level.
The course is intended for individuals who have some previous experience in Microsoft Access.
Some previous Microsoft Access experience is required.
Certificate of participation can be obtained if required.
On receiving your request we will contact you to explain course content, including course dates and payment options.
Reviews
Subjects
- Access
- Microsoft Access
- Datasheets
- Custom Reports
- Action Queries
- Macro Design
- Tables
- Macros
- Forms
- Custom Forms
- Sorting and Grouping
Teachers and trainers (1)
Chris Edmondson
IT Trainer
Course programme
Course review:
1 Revision
- Topics from the Introduction day
- Revision Exercise
2 More about Datasheets
- Finding Information in a Datasheet
- Replacing Information
- Sorting in a Datasheet
- Filtering for Ad-hoc enquiries
3 Relationships between Tables
- The Northwind Sample Database
- Understanding Links
- Multi-Table Queries
- Creating the Relationships
4 Custom Forms
- Starting from Scratch
- Control Properties
- Using List / Combo Boxes
- Check Boxes / Option Buttons
- Calculations on a Form
5 Custom Reports
- Starting from Scratch
- Sorting and Grouping
- The Control Types to be Used
6 Action Queries
- Make Table Queries
- Append Queries
- Delete Queries
- Update Queries
7 Macro Design
- Creating a Macro
- The Macro Design Window
- Saving and Running the Macro
Microsoft Access Intermediate (Level 2) 2003 2007 2010 2013 2016 & 365