Description

This is an Accredited Microsoft Access Diploma that is delivered online. When holding down so many jobs, Microsoft Access will need to be used.

We have the ideal diploma for you if you need to work on your Access skills.

Microsoft Access Diploma

Our training centre is a Certified Microsoft Office Academy, which enables students to gain all the skills needed for everyday tasks. The Access Diploma that we provide is a CPD Accredited course, meaning that this certification is issued to participants after the course has finished if completed successfully.

Diploma Format

The training is delivered online using a virtual tutor function. The virtual tutor instructs corrects, and provides examples to simulate having a personal IT trainer. This is a very effective and up-to-date method of delivering interactive online training.

Access Diploma Content

Beginner Module

  • Database basics
  • Database management system
  • The ribbon and the Quick Access toolbar Opening a database
  • Database objects
  • Entering records
  • Finding records
  • Replacing the value in a field Deleting records
  • Sorting records
  • Print Preview
  • Margins and orientation for printing any object
  • Running a query

Intermediate Module

  • 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
  • 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

Advanced Module

  • Datasheet view
  • Design view
  • Restricting what can be entered in a field
  • Input masks
  • Lookup lists Indexing a table
  • Relationships between tables
  • Forms for entering data
  • You have a well-designed table and a lot of data to put in it.
  • You will find it easier to enter the data via a form
  • Form properties
  • Preventing access to form fields
  • Changing the order of access to fields
  • Subforms
  • Using a form to inter-data in several tables at once
  • Collecting and sharing data
  • Controls: positioning, organising
  • Think of controls as containers for your data. If you are creating a form, position them to simplify typing.
  • Creating a text box to represent a field
  • Selecting and deleting controls
  • Creating a check box/button
  • Creating an option group
  • Creating a label
  • Creating a calculated control
  • Calculating statistics in forms and reports
  • Creating a setlist of values
  • Creating a list of values from an existing table/query
  • Controls: getting the presentation right
  • Some simple techniques for the presentation of controls, to ensure that your forms and reports are attractive
  • Moving and copying controls
  • Aligning and spacing controls
  • Changing the height of a section
  • Creating a rectangle/line control
  • Resizing controls
  • Formatting text in a control
  • Aligning text in a control
  • Formatting controls
  • Conditional formatting
  • Copying a format from one control to another
  • Grouping/ungrouping controls
  • Numbering pages in a report or form
  • Inserting a picture
  • Themes
  • Reports for communicating data
  • The better your reports look; the more impact your data will have.
  • Sorting information in a report
  • Grouping records in a report
  • Printing groups on separate pages of a report
  • Mailing labels
  • Find out more
  • Calculations, statistics, all sorts of queries… get to know some of Access’ less-known functions.
  • Calculated fields in a query
  • Statistics without grouping
  • Statistics on groups
  • Statistics on groups of pre-selected records
  • Parameter queries
  • Find unmatched query
  • Find duplicates query
  • Crosstab query
  • Creating a pivot table
  • Grouping records in a pivot table
  • Adding a totals
  • Pivot charts

Dates and Duration

There is a maximum duration of 6 months. It can be completed far before this time. The course can be started and taken at any time.

Course Requirements

There are no entry requirements for this course. It is aimed at beginners.

Benefits

  • Senior Microsoft Trainers write training in a Microsoft Certified Academy
  • Live help with the virtual tutor function
  • CPD Accredited Microsoft Access Diploma issued on completion
  • A practical course that includes several exercises
  • The outcome is after completion. A CPD Accredited Diploma will be issued by the Microsoft Academy, which will build your CV and career options.