The ability to input and manage database systems is key to most office jobs. Microsoft Access is the most common database system so this course will provide valuable skills which many employers will need of their employees. Souters is a Microsoft Certified Academy, so we are able to offer Microsoft Certification and our training uses the very latest technology in interactive training. All of our Microsoft Courses are certified by the CPD Standards Institute.

Objective

To give students beginner and Proficient (i.e. Intermediate) Access Skills- Advanced level available as a supplement

Course Format

Beginner and Proficient modules in Access 2010. The units will take you to Proficient level. Advanced training is available by request.

Course Content

Beginner Level

Database Basics and Database Management

  • Getting started with the Database Management System
  • Overview of Access ribbon
  • Opening a database Database objects

Maintaining Database records

  • Entering, Replacing, Editing, Delete and Sorting records
  • How to use of the data
  • Moving around in a datasheet/form

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 and by a range of field values
  • Inserting a Total row into a datasheet

Creating a database

  • Converting a database
  • Database creation and protection
  • Protecting a database
  • More Advanced Database Management

Creating a table

  • Primary key
  • Importing and exporting data
  • Creating a form
  • Object dependencies
  • Selecting the records to print in a report

Creating a Select query

  • Using the query design grid, sorting the records in a query, delete query, make a table query, update a query
  • Setting a selection criterion in a query
  • Setting criteria on multiple fields
  • Building Queries and increase efficiency of data extraction for End Users
  • Setting multiple criteria on the same field

Dates and Duration

The course last for three months, but you can complete it faster with intensive study.

Course Requirements

Course can start from beginner level, so no entry requirements.

Benefits

  • Training written by senior Microsoft Partners
  • User friendly and interactive system
  • CPD Accredited and CPD Standards Institute Certification is issued upon completion
  • Flexibility, as intensely or otherwise as you need

Outcome

CPD Accredited Microsoft Access Certification on successful completion.

Executive Assistant Course Netherlands

All rights reserved to Souters Training 2019
Copyrights © Souters Training.