Description

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

Objective

Students are trained at MS Access Beginner and Proficient (i.e. Intermediate) Level. Advanced level available as a supplement.

Course Format

Beginner and Proficient modules in Access. 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 six months, but you can complete it faster with intensive study.

Course Requirements

Course can start from Beginner level, so no entry requirements are needed.

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
  • Access to the programme for one year.

Outcome

CPD Accredited Microsoft Access Certification on successful completion.

Executive Assistant Courses in Netherlands