Description

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

Microsoft Access Course

Students are trained in Microsoft Access at the beginner and intermediate levels. Advanced level available as a supplement for €50.

Course Format

Beginner and Intermediate 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 the Access ribbon
  • Opening a database: Database objects

Maintaining Database records

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

Print Preview data

  • Margins and orientation for printing any object
  • Running a query in your database

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, deleting a query, making a table query, and updating a query
  • Setting a selection criterion in a query
  • Setting criteria on multiple fields
  • Building Queries and increasing the efficiency of data extraction for End Users
  • Setting multiple criteria on the same field

Dates and Duration

The course can take up to 12 months, but you can complete it faster with intensive study.

Course Requirements

The course can start from the 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.