Onsite training solutions for Access

  • Access 2003
  • Access 2007 & 2010

Course Level

Introductory
Intermediate
Advanced
  • Tab 1
  • Tab 2
  • Tab 3

Access 2003

INTRODUCTION TO DATABASES

  • What is a Access?
  • The Access Database Window
  • Terminology
  • Closing Access

ACCESS OBJECTS

  • Tables
  • Queries
  • Forms
  • Reports
  • Copying, renaming and deleting database objects

CREATING A NEW DATABASE

  • Designing a Database
  • Preparing your data
  • Creating a New Database
  • Creating a New Table
  • Table Design Window
  • Entering Field Names
  • Specifying Data Types
  • Specifying Field Properties
  • Entering records in Datasheet view
  • Importing Spreadsheet Data into an Access Table

CHANGING FIELD NAMES

 

PRIMARY KEYS

  • Changing the Primary Key
  • Saving the design

USING DATASHEET VIEW

  • Editing Data
  • Moving Round the Datasheet

FINDING DATA

  • Adding records
  • Amending records
  • Deleting records

FILTERING RECORDS

  • Sorting Records
  • Filtering Records
  • Multi-level Sorting

CREATING FORMS

  • Creating a Form
  • Navigation Using Form View
  • Naming your Form
  • Design View
  • Adding a Field
  • Deleting a Field
  • Modifying the Form Design
  • Entering records in Form View
  • Switching between views

QUERIES

  • Creating Simple Queries
  • Saving Queries

REPORTS

  • Creating Simple Reports using Wizard
  • Creating Grouped Reports using Wizard
  • Simple Modifications to a Report
  • Saving Reports

 

Access 2003

FIELD FEATURES

  • Adding a Lookup to a Table
  • Defining an Input Mask for a Field
  • Using the Database Wizard

USING PARAMETER QUERIES

  • Creating the Query

TABLE RELATIONSHIPS

  • One to One
  • One to Many
  • Many to Many relationships

JOINING TABLES

  • Enforcing Referential Integrity
  • Cascade Update
  • Cascade Delete
  • Establishing a join between tables
  • Inserting an additional table in the relationships window
  • Deleting a join
  • Modifying a join

INTERMEDIATE QUERY TECHNIQUES

  • Creeating Queries to Extract info from Multiple Tables
  • Summary Queries
  • Crosstab Queries

ADVANCED FORM DESIGN

  • Create Formswith Sub-forms
  • Multi-File Screen Forms
  • Checkboxes/Option Buttons/Toggle Buttons

CHANGING FORM PROPERTIES

  • Setting Form Properties
  • Adding Special Features To Forms
  • List Boxes and Combo Boxes
  • Restricting Input to a Combo Box
  • Option Groups
  • Command Buttons
  • Adding Unbound Controls to a Form
  • Adding text to a form
  • Adding a Calculated Control to a Form

ADVANCED REPORTING

  • Creating Reports from Multiple Tables
  • Totalling groups of records
  • Group Header
  • Grouping dates in the group header
  • Group footer
  • Summarising values in the footer
  • Using Unbound Controls on reports

USEFUL FUNCTIONS

  • IIF (Immediate IF)
  • Using a Nested IIf Function
  • Assigning a Macro to the Toolbar
  • Modifying the button image

CUSTOMISING ACCESS

  • Customising Access at Start-up

Access 2003

GROUPING AND SUMMARISING DATA

  • What to summarise
  • Summary Calculations
  • To Calculate Totals
  • To Select Fields for Grouping

ACTION QUERIES

Update Query
  • Update Expressions
Make-Table Queries
  • Making real tables from queries
  • Uses for Make-Table Queries
  • To Perform a Make Table Query
Delete Queries
Append Queries
  • To Perform an Append Query
  • Appending Primary Keys

FORMS

  • Creating a Master/Subforms
  • Ading Pictures to Forms
  • Adding Graphs
  • Tabs in Subforms
  • Displaying Today’s date on forms
  • Auto completion of forms

SWITCHBOARDS

  • Creating a Switchboard
  • Setting the Switchboard to run at Startup
  • Properties of Switchboards

DATA TYPES AND FIELD PROPERTIES

  • Validating Field Entry
  • Creating a Custom Input Mask
  • Database Security
  • Encrypting Databases

MACROS

  • Creating and Saving
  • Running
  • Grouping Macros
  • Condition Macros
  • Using with Forms
  • Responding to a Button
  • Responding to an Event

USING MAILMERGE WITH MICROSOFT WORD

 

CREATING MAILING LABELS

 

MACROS

  • What is a Macro?
  • Creating a Macro
  • Running a Macro
  • Creating a Command Button
  • Writing an Event Procedures

CREATING A CUSTOMISED TOOLBAR

  • Setting Startup Options
  • Setting a Password
  • Replicating a Database

 

Course Level

Introductory
Intermediate
Advanced
  • Tab 1
  • Tab 2
  • Tab 3

Access 2007 & 2010

INTRODUCTION TO DATABASES

  • What is a Access?
  • The Access Database Window
  • Terminology
  • Closing Access

ACCESS OBJECTS

  • Tables
  • Queries
  • Forms
  • Reports
  • Copying, renaming and deleting database objects

CREATING A NEW DATABASE

  • Designing a Database
  • Preparing your data
  • Creating a New Database
  • Creating a New Table
  • Table Design Window
  • Entering Field Names
  • Specifying Data Types
  • Specifying Field Properties
  • Entering records in Datasheet view
  • Importing Spreadsheet Data into an Access Table

CHANGING FIELD NAMES

 

PRIMARY KEYS

  • Changing the Primary Key
  • Saving the design

USING DATASHEET VIEW

  • Editing Data
  • Moving Round the Datasheet

FINDING DATA

  • Adding records
  • Amending records
  • Deleting records

FILTERING RECORDS

  • Sorting Records
  • Filtering Records
  • Multi-level Sorting

CREATING FORMS

  • Creating a Form
  • Navigation Using Form View
  • Naming your Form
  • Design View
  • Adding a Field
  • Deleting a Field
  • Modifying the Form Design
  • Entering records in Form View
  • Switching between views

QUERIES

  • Creating Simple Queries
  • Saving Queries

REPORTS

  • Creating Simple Reports using Wizard
  • Creating Grouped Reports using Wizard
  • Simple Modifications to a Report
  • Saving Reports

Access 2007 & 2010

FIELD FEATURES

  • Adding a Lookup to a Table
  • Defining an Input Mask for a Field
  • Using the Database Wizard

USING PARAMETER QUERIES

  • Creating the Query

TABLE RELATIONSHIPS

  • One to One
  • One to Many
  • Many to Many relationships

JOINING TABLES

  • Enforcing Referential Integrity
  • Cascade Update
  • Cascade Delete
  • Establishing a join between tables
  • Inserting an additional table in the relationships window
  • Deleting a join
  • Modifying a join

INTERMEDIATE QUERY TECHNIQUES

  • Creeating Queries to Extract info from Multiple Tables
  • Summary Queries
  • Crosstab Queries

ADVANCED FORM DESIGN

  • Create Formswith Sub-forms
  • Multi-File Screen Forms
  • Checkboxes/Option Buttons/Toggle Buttons

CHANGING FORM PROPERTIES

  • Setting Form Properties
  • Adding Special Features To Forms
  • List Boxes and Combo Boxes
  • Restricting Input to a Combo Box
  • Option Groups
  • Command Buttons
  • Adding Unbound Controls to a Form
  • Adding text to a form
  • Adding a Calculated Control to a Form

ADVANCED REPORTING

  • Creating Reports from Multiple Tables
  • Totalling groups of records
  • Group Header
  • Grouping dates in the group header
  • Group footer
  • Summarising values in the footer
  • Using Unbound Controls on reports

USEFUL FUNCTIONS

  • IIF (Immediate IF)
  • Using a Nested IIf Function
  • Assigning a Macro to the Toolbar
  • Modifying the button image

CUSTOMISING ACCESS

  • Customising Access at Start-up

Access 2007 & 2010

GROUPING AND SUMMARISING DATA

  • What to summarise
  • Summary Calculations
  • To Calculate Totals
  • To Select Fields for Grouping

ACTION QUERIES

Update Query
  • Update Expressions
Make-Table Queries
  • Making real tables from queries
  • Uses for Make-Table Queries
  • To Perform a Make Table Query
Delete Queries
Append Queries
  • To Perform an Append Query
  • Appending Primary Keys

FORMS

  • Creating a Master/Subforms
  • Ading Pictures to Forms
  • Adding Graphs
  • Tabs in Subforms
  • Displaying Today’s date on forms
  • Auto completion of forms

SWITCHBOARDS

  • Creating a Switchboard
  • Setting the Switchboard to run at Startup
  • Properties of Switchboards

DATA TYPES AND FIELD PROPERTIES

  • Validating Field Entry
  • Creating a Custom Input Mask
  • Database Security
  • Encrypting Databases

MACROS

  • Creating and Saving
  • Running
  • Grouping Macros
  • Condition Macros
  • Using with Forms
  • Responding to a Button
  • Responding to an Event

USING MAILMERGE WITH MICROSOFT WORD

 

CREATING MAILING LABELS

 

MACROS

  • What is a Macro?
  • Creating a Macro
  • Running a Macro
  • Creating a Command Button
  • Writing an Event Procedures

CREATING A CUSTOMISED TOOLBAR

  • Setting Startup Options
  • Setting a Password
  • Replicating a Database