Description
Microsoft Access databases have been used by several organisations to create HR systems and other corporate systems. Our Microsoft Access Diploma includes Beginner to Advanced training. The Diploma is CPD Accredited and online. It means that you can work flexibly online and gain both career skills and a professional qualification.
Microsoft Access Diploma
Course Format
This is an online course that can be started at any time. It is completely flexible and available at any time. The training is provided in partnership with Microsoft Learning Partners. Their training systems contains a virtual tutor function that instructs you, provides worked examples, gives you exercises and marks your exercises.
Course Content
Beginner Module
- Getting started with the Database Management System
- Opening a database
- Database objects
- Overview of Access ribbon
- Maintaining Database records
- Entering, Replacing, Editing, Finding, Delete and Sorting records
- Moving around in a datasheet/form
- How to use of the data
- Print Preview data
- Margins and orientation for printing any object
- Running a query in your database
Intermediate and Advanced Module
- Managing objects
- Formatting/reorganising a datasheet
- Filtering records by the value in a field
- Filtering by a range of field values
- Inserting a Total row into a datasheet
- Creating a database
- Converting a database
- Protecting a database
- Creating a table
- Primary key
- Importing data from another application
- Exporting data
- Creating a form
- Object dependencies
- Selecting the records to print in a report
- Creating a Select query
- Using the query design grid
- Setting a selection criterion in a query
- Setting criteria on multiple fields
- Setting multiple criteria on the same field
- Sorting the records in a query
- Delete query
- Make Table query
- Update query
Dates and Duration
Average learning hours are 25 hours. This average is based on past student study times. Your aptitude and background can cause learning times to vary. You have up to one year to complete the training, but you can complete in a far shorter time.
Course Requirements
The Course can start from beginner level, so there are no special entry requirements.
Benefits
- Training written by senior Microsoft Partners
- User friendly
- We can offer CPD Certification which is internationally recognised, because we are a Microsoft Certified Academy.
- Build your CV with the Certification
- flexible study that is still interactive
Additional information
date-of-course | 2nd – 4th March 2020, London, 4th – 6th May 2020, London |
---|---|
number-of-attendees | 1, 2, 3, 4, 5 |