Course Outline

INTRODUCTION TO MICROSOFT ACCESS

• Flat-File Database
• Relational Database
• Fields and Records

INITIALISING A NEW DATABASE

• Create a New Blank Database

MICROSOFT ACCESS OBJECTS

• Tables
• Queries
• Forms
• Reports
• Macros
• Modules

FINALISING THE TABLES

• Salesperson Table
• Customer Table
• Sales Table
• Populating the [Salesperson] Table from Excel
• Populating the [Customers] Table from Excel
• Completing the [Salesdata] Table

ESTABLISHING RELATIONSHIPS

• The Relationship Window
• Creating a Join

CREATING A FORM TO CAPTURE SALES DATA

• Using the Form Wizard
• Changing the Form Design

POPULATING THE SALES DATA TABLE FROM EXISTING EXCEL DATA

• View of Access Sales Data Table
• View of Excel Data
• A Query with a Calculated Field
• Preparing The Excel Workbook To Receive Data

USING LINKED EXCEL TABLES

• Creating a Link
• Creating an Append Query

USING EXCEL PIVOT TABLES FROM ACCESS DATA

• Excel Pivot Table with Access Source Data

USING ACCESS PIVOT TABLES AND PIVOT CHARTS

• Pivot Table Forms
• Pivot Chart Forms

WORKING WITH QUERIES

• Filtering Data
• Working With Criteria
• Using Parameters
• Using a Form to Provide Criteria Input

CREATING FORMS WITH SUBFORMS

• Manually Creating the Customers/Sales Data Form and Subform

CROSSTAB QUERIES

• The Crosstab Row
• The Total Row
• Exploring Total Queries

REPORTS

• Using the report wizard
• Editing an existing report

EMBEDDING A MACRO IN A FORM

THE SWITCHBOARD MANAGER

• Create A Switchboard
• Add items to a switchboard
• Access your switchboard
• Edit items in a switchboard
• Delete a Switchboard or Switchboard Item
• Display the Main Switchboard on Startup