Microsoft Access Training

Microsoft Access Training

Microsoft Access is a relational database application used to manage, track and share information.

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

Enquire about Microsoft Access »
  • Introduction to Microsoft Access
    • What Is Access?
    • Creating Files
    • Opening And Closing A Database File
  • Access Interface
    • Access Workspace
  • The Database Toolbar & Ribbon
    • Using The Database Toolbar & Ribbon within the different versions of Access
  • 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
  • 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
  • Using The Northwind Database
    • Installing The Northwind Database
  • Structured Query Language
    • Writing SQL Commands
    • Writing SQL Queries
    • Writing SQL Subqueries
    • Writing SQL Joins
    • Inserting Data
    • Updating Data
    • Deleting Data
    • Writing SQL Queries In Access
  • Working with Macros
    • Automating Tasks
    • Introducing The Macro Design Toolbar
    • Creating Macros
    • Testing And Debugging Macros
    • Modifying Macros
    • Conditional Programming In Macros
    • Adding Macros To Forms
    • Adding Macros To Reports
    • Filtering Data
    • Documenting Macros
  • Using Visual Basic
    • Using Macros Versus Visual Basic
    • Understanding Visual Basic Concepts
    • Using The Visual Basic Editor Window
    • Getting Help With Visual Basic
  • Using Data Access Pages
    • Creating Data Access Pages
    • Modifying Data Access Pages
    • Sorting Data In Data Access Pages
    • Summarising Data In Data Access Pages
    • Editing Data In Data Access Pages
    • Protecting Data In Data Access Pages
  • Converting Access Databases
    • Converting Databases To Access 2003/2007
    • Converting Between different Access versions
  • Customising Access
    • Configuring Access 2003/2007/2010 Options
    • Configuring Autocorrect Options
    • Customising Menus And Toolbars
  • Managing & Maintaining Databases
    • Optimising Databases With Table Analyzer
    • Optimising Databases With Performance Analyzer
    • Documenting Databases With Documenter Analyzer
    • Avoiding Errors With The Object Dependencies Task Pane
  • 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

Office Essentials

Microsoft Solutions

Internet Training

Technical