Course Objectives
At the end of this course you will be able to:
Do advance Table design
Do advance Query design and Action Querys
Do advance Form design with the use of macros and buttons
Export and import data to and from different sources.
1 year email support service
Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk
With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.
Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.
Tailored in company training courses:
You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.
Advanced Table Design
Advanced Field Properties
Table Properties
Advanced Query Design
Advanced Naming Conventions
Join Tables in Queries
Manage Query Joins
Use Self-Joins in Queries
Summarise Data in Queries
Parameter Queries
Action Queries
Crosstab Queries
Advanced Form Design
Create Subforms and Linked Forms
Form Controls
Command Buttons
Form Properties
Interface, Start-Up and Navigations Forms
Working with Macros
Create Single Macros
Run Macros
Work with Sub Macros
Use Conditional Macros
Run Macros from Buttons
Assign Macros to Events
Extending Data Reach
Import Data
Export Data
Work with Linked Tables
Managing Databases
Object Dependencies
Database Documenter
Performance Analyzers
Regular Management of a Database
Access Database Security
Who is this course for? Who is this course for?
The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros.
Career path Career path
Microsoft Office know-how can instantly increase your job prospects as well as your salary.
80 percent of job openings require spreadsheet and word-processing software skills