Microsoft Access Training Northern Ireland

Introductory 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.

• Introduction to Access
  • What Is Access?
  • Creating Files
  • Opening And Closing A Database File

• Access Interface
  • Access 2003/2007 Workspace

• The Database Toolbar
  • Using The Database Toolbar

• The Task Pane
  • Using The Open Area Of The Getting Started Task Pane
  • Using The New Area Of The New File Task Pane
  • Using The Template Area Of The New File Task Pane
  • Using The Clipboard Task Pane
  • Using The File Search Task Pane

• The Database Window
  • The Database Menu Bar
  • The Database Window Toolbar

• Tables
  • Create A Table
  • Working With Tables

• Queries
  • Create A Query

• Forms
  • Using And Creating Forms
  • Displaying And Linking Images

• Reports
  • Creating And Using Reports
  • Saving, Maintaining, And Printing Reports
  

• 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