The ability to input and manage database systems is key to many jobs. Microsoft Access is the most common database system and knowledge of this program is required in a wide range of industry.

This course is a discounted package that includes the Beginner and Intermediate Access Course. This course will enable students to gain CPD Accreditation at Proficient Level (Intermediate) upon successful completion.

Microsoft Access Training Course

The course is available online or you can come into our Microsoft Certified Academy in London, to complete the training

Access Course Objective

To give students Beginner and Proficient (i.e. Intermediate) Access Skills.

Course Content

Beginner module

Database Basics and Database Management

• Getting started with the Database Management System
• Opening a databaseDatabase 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

Proficient (Intermediate) Level

Objects and their datasheets

• 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

Database creation and protection

• Creating a database
• Converting a database
• Protecting a database

More Advanced Database Management

• 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

Building Queries and increase efficiency of data extraction for End Users

• 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

Course Format

The course is delivered using a virtual tutor on a live server. This is a state of the art learning system. The virtual tutor will instruct you and correct your exercises. This standard of interactive learning will enable you to gain from interactive learning. This is available to you on a flexible basis, either online at home or you can take the training in our centre. You can also contact our live tutor at our centre in London for any doubts.

Entry Requirements

Course starts from beginner level, so no entry requirements.

Dates and Duration

Training can commence on any date. The course has up to 3 months to complete. The majority complete the course far before 3 months. You can complete the course on flexi-time, online or at our centre*. The assessment at the end can be done online or at our centre.

Benefits of the Course

• Training from a Microsoft Certified Academy, to ensure quality
• Virtual tutor on a live server enables interactive learning and guidance throughout the training program
• Possibility to continue to study Advanced Access and VBA
• CPD Certification in Microsoft Access to build your CV
• Qualification is certified and can build your career
• Flexibility to train as intensely or otherwise as you prefer
• Access to our live tutors, if required, at our centre
• Available at our Certified Training Centre with trainers to support you or at home

Outcome

CPD Certificate in Microsoft Access on successful completion at Proficient Level.

*There is up to one month access to the training centre to complete the course full-time