Microsoft Access Introductory/Intermediate - Version 2007 or 2010 (2 day course)

The Microsoft Access course held in Perth introduces you to the fundamentals of databases and database design. Using practical business examples you will set up your own Customer Relationship Management database to store common details such as customer contact details, stock control and customer interaction. These skills can then be applied to create your own customised database for your office. Microsoft Access is a powerful database application designed to save you time and make creating relational databases easier. Databases don't have to be confusing when you've had the right training.

Why use Access?

  • Create your own custom database at a fraction of the cost of CRM and similar solutions.
  • Customise reports to your requirements

Course Outline

At the completion of Microsoft Access 2010 Introductory and Intermediate you should be able to:

  • understand how Access is used and how to navigate around it
  • design a database with lookup tables
  • create a database structure using Access 2010
  • modify the structure of an existing table
  • add records to a new table
  • add transactional records to a lookup database
  • work with the records in a database table
  • sort and filter records in a table
  • create simple and effective queries
  • create meaningful reports from tables
  • create and use a variety of forms
  • use various data validation features in Access to protect data
  • format the data in a table
  • perform more advanced queries using a variety of querying techniques
  • create and use parameter queries
  • create calculated queries
  • modify and adapt an existing form according to specific needs
  • create and use macros in Access
  • work with a number of macro techniques
  • create macros on forms  

       Day 1

       Day 2

      Download Student Files



    Prerequisites
    None

    Assessment
    On completion of this course, attendees will be provided with a Certificate of Participation.

    Duration
    2 Days     - 9:00am to 4:00pm.

    Cost
    $499.00 per person - Attend this course and     Microsoft Access Advanced for only $699.00!

    Dates
    Please visit our timetable   for current dates.

    Registration
    To register for this course please       click here .

    More Information
    If you require more information please don't hesitate to   contact us .

    Detailed Course contents from training manuals

Access 2010 Orientation

  • Understanding Microsoft Access 2010
  • Starting Access
  • Understanding The Backstage View
  • Opening An Existing Database File
  • Understanding The Access 2010 Screen
  • Working With The Navigation Pane
  • Working With A Table
  • Working With Other Database Objects
  • Closing A Database File
  • Exiting From Access 2010

Designing A Lookup Database

  • Understanding How Access Stores Data
  • Understanding Access 2010 Data Types
  • Scoping Your New Database
  • Identifying Table Problems
  • Refining Table Structures
  • Finalising The Design
  • Creating A Lookup Database
  • Creating A New Database File
  • Creating The Lookup Table
  • Defining The Primary Key
  • Saving And Closing A Table
  • Creating The Transaction Table
  • Understanding Lookup Table Relationships

Connecting To A Lookup Table

  • Viewing Table Relationships

Modifying Table Structures

  • Opening An Existing Table
  • Adding Fields To An Existing Table
  • Understanding Field Properties
  • Changing Field Size
  • Changing Field Names
  • Changing Decimal Places
  • Changing Date Formats
  • Indexing Fields
  • Deleting Fields From A Table
  • Copying A Table Within A Database
  • Deleting A Table From A Database File

Adding Records To A Table

  • Typing Records In A Table
  • Adding Records Using A Form
  • Saving A Form Layout For Reuse
  • Adding Records Using An Existing Form
  • Adding Records
  • Importing From Microsoft Excel
  • Adding Transactional Records
  • Typing Transactional Records
  • Adding Transactional Records Using A Form
  • Adding Transactional Records
  • Adding Records Using A Subdatasheet
  • Removing A Subdatasheet
  • Inserting A Subdatasheet

Working With Records

  • Table Navigation
  • Navigating To A Specific Record
  • Editing A Record
  • Deleting Record Data
  • Undoing A Change
  • Deleting A Record
  • Deleting Several Records
  • Searching In A Table
  • Searching In A Field
  • Finding And Replacing
  • Printing Records From A Table
  • Compacting A Database

Sorting And Filtering

  • Simple Sorting
  • Sorting On Several Fields
  • Simple Filtering
  • Working With Filters
  • Filtering Between Dates

Creating Queries

  • Understanding Queries
  • Creating A Query Design
  • Working With A Query
  • Changing A Query Design
  • Applying Record Criteria
  • Clearing Selection Criteria
  • Saving A Query
  • Running Queries From The Navigation Pane
  • Deleting A Query
  • Creating Queries

Creating And Using Reports

  • Understanding Reporting In Access
  • Creating A Basic Report
  • Working With Existing Reports
  • Previewing And Printing A Report
  • Changing The Report Layout
  • Using The Report Wizard
  • Creating A Grouped Report
  • Creating A Statistical Report
  • Working With Grouped Reports

Creating And Using Forms

  • Understanding Forms
  • Creating A Basic Form
  • Creating A Split Form
  • Binding A Form To A Query
  • Using The Form Wizard
  • Working With Existing Forms
  • Editing Records In A Form
  • Deleting Records Through A Form
  • Deleting An Unwanted Form

Data Validation

  • Assigning Default Values
  • Validation Rules And Text
  • Validating Numbers
  • Setting Required Fields
  		  Parameter Queries
  • Creating A Parameter Query
  • Displaying All Records
  • Using Parameters To Display A Range
  • Using Parameters In Expressions
  • Calculations In Queries
  • Creating A Calculated Field
  • Formatting Calculated Fields
  • Summarising Data Using A Query
  • Changing The Grouping
  • Calculating With Dates
  • Using Criteria In Calculations
  • Concatenating String Fields

Modifying Forms

  • Understanding Form Design And Layout
  • Switching Between Form Views
  • Selecting Form Objects
  • Working With A Control Stack
  • Changing Control Widths
  • Moving Controls On A Form
  • Aligning Controls
  • Understanding Properties
  • Changing Label Captions
  • Adding An Unbound Control
  • Adding A Control Source
  • Formatting A Control
  • Checking The Current Tab Order
  • Changing The Tab Order
  • Inserting The Date Into The Form Header

Creating And Using Macros

  • Understanding Macros And VBA
  • Creating A Macro
  • Running A Macro
  • Modifying An Existing Macro
  • Interacting With The User
  • Stepping Through A Macro
  • Documenting Macros
  • Macro Techniques
  • Creating A Print Macro
  • Using Conditions To Enhance A Macro
  • Creating A Sequence Of Conditions
  • Understanding The Versatility Of MsgBox
  • Using The MsgBox Function
  • Reconfiguring A Message Box
  • Using The InputBox Function
  • Macros On Forms
  • Understanding Macros On Forms
  • Creating Navigation Macros
  • Accessing Event Macros


 




Admin   Terms   Contact