Microsoft Access Training Northern Ireland

Intermediate Level

Our standard course outline for this course is shown below, however, we are able to adapt the contents to suit your specific needs as required. Please contact us for more details

This course is designed to help you to obtain the skills required to update records in a database and to use Access to create a simple database. You will learn to design tables and queries and to create forms and reports using built-in tools.

• The Northwind Database
  • Installing The Northwind Database

• Designing Tables in Access
  • Normalising Data
  • Establishing Relationships
  • Working With Indexes
  • Working With Data Types

• Designing Queries in Access
  • Creating Action Queries
  • Creating Parameter Queries
  • Creating Calculated Columns In Queries
  • Joining Tables

• Designing Forms in Access
  • Creating Data Entry Forms
  • Working With Subforms
  • Creating Pop-Up Forms
  • Working With Switchboards

• Designing Reports in Access
  • Working With Standard Reports
  • Working With Pop-Up Reports
  • Working With Subreports
  • Working With Report Snapshots
  • Developing Data Access Pages

• Working with Pivot Tables and Pivot Charts
  • Creating Pivottables And Pivotcharts
  • Creating Pivottable Forms
  • Creating Pivotchart Forms

• Importing and Exporting
  • Linking To External Data Sources
  • Importing Data Into Access
  • Exporting Data From Access

• Building Expressions
  • Using The Expression Builder
  • Using Common Built-In Functions

• Editing Spreadsheets
  • Cutting, Copying, And Pasting
  • Inserting And Deleting
  • Using Find And Replace
  • Using Undo And Redo

• Formulas and Functions
  • Entering Formulas
  • Entering Functions
  • Using Named Cells And Ranges In Formulas

• Printing
  • Using Page Setup
  • Margins
  • Headers And Footers
  • Printing A Spreadsheet

<- Back to Courses