MS Access Introduction

Duration: One Day

Interested in this course?

Complete the form and let us know your preferred training date. Our team will contact you to discuss your requirements and arrange a suitable course schedule.

Whether you're booking for yourself or a team, we'll work with you to find a convenient training date.

Prefer to get in touch directly? You can also email us at forrest@forresttraining.com.au, and we'll be happy to assist you.

    Target Audience & Purpose

    Access Introduction is for people new to databases, & for self-taught users to enhance their knowledge. It is a pre-requisite for the Intermediate & Advanced courses.

    Objectives

    By the end of this course participants should be able to:

    • Design and create a database
    • Create tables and set the primary key
    • Define the fields and properties for a table
    • Enter data and modify the layout of a table
    • Find data in tables
    • Create queries
    • Create table relationships
    • Design and create forms and reports
    • Print reports

    Course Inclusions

    • Comprehensive learning materials incl. exercise files
    • Post course telephone support
    • ‘Certificate of Attendance’ on completion of course
    • Morning & afternoon tea

    Course Prerequisites

    Participants should already:

    • Be competent in using a mouse and keyboard
    • Have an understanding of Windows

    MS Access Introduction Course Content

    Download Exercise Files

    Exploring Access
    Start Access, Open & Close a Database, Use the Ribbon, Use the Contextual Tabs, Use Toolbar, Use Database Objects, Use Navigation Pane, Open a Database Object, Use & Close All Tabbed Documents, Use the Status Bar, Use the Options Dialog Box, Exit Access

    Creating Tables
    Use Database Templates, Create a Database, Design Tables, Create a Table in Datasheet View, Create a Table in Design View, Add Field Names, Assign Data Types, Save a Table, Add a Field Description, Set a Primary Key, Use Multi-valued Fields

    Working with Tables
    Use Datasheet View, Navigate Fields in Tables, Add & Move through Records, Select, Editing, Save, Delete Records

    Editing Tables
    Change Row Height & Column Width, Change Font Attribute, Change Cell Effect, Use Alternate Background Colors, Select, Move, Hide, Unhide & Freeze a Column

    Finding & Filtering Data
    Sort Records, Find Specific Records, Find Records using Wildcards, Use Replace, Use Filter By Selection, Apply/Remove a Filter, Use Filter Exclude Selection, Use the Search Box, Use Quick Filter, Use AutoFilter

    Printing Data
    Change Page Setup, Use Print Preview, Print Selected Records

    Creating Relationships
    Use Related Tables, Create a Relationship between Tables, Set Referential Integrity, View Subdatasheets, Delete a Join Line

    Using Simple Queries
    Use Queries & Recordsets, Simple Query Wizard, Create Query in Design View, Open a Query, Add a Table, Join Tables, Run a Query

    Modifying Query Results
    Sort a Query, Add Criteria to a Query, Hide a Field in a Query, Display a Totals Row in a Query, Add a Record using a Query, Print a Query

    Creating Basic Forms
    Use Form Button, Add a Record using a Form, Use the Calendar for Date Picking, Use the Form Wizard, View Records in a Form, Print Records in a Form, Base a Form on a Query

    Creating Basic Reports
    Use Report Button, Use Print Preview, Print Pages of a Report, Report Wizard, Change Views in a Report, Group & Summarize Report Data, Base a Report on a Query

    Modifying Tables
    Insert a Column into a Table, Insert a Lookup Column, Insert a Hyperlink Column, Create a Many-to-Many Relationship

    Setting Field Properties
    Limit Field Size, Set Number Formats, Set Date/Time Formats, Setting Yes/No Formats, Set Default Values, Set Validation Rules, Create an Input Mask – Wizard, Create an Input Mask Manually, Create a Custom Input Mask, Lookup List, Modify Lookup Properties

    Using Operators in Queries
    Use Comparison Operators, Use an & Condition, Use an Or Condition, Use the Between & Operator, Use a Wildcard Character

    Designing Advanced Queries
    Set Top Values in a Query, Create a Calculated Field, Format a Calculated Field, Create a Function Query, Create a Parameter Query, Multivalued Fields, Create a Concatenation in a Query, Filter a Query

    Using Advanced Query Wizards
    Use the Crosstab Query Wizard, Find Duplicates Query Wizard, Find Unmatched Query Wizard

    Manipulating Form Controls in Design View
    Select, Delete, Size Controls, Set Control Margins & Padding, Hide the Ruler, Disable Snap to Grid Feature, Display Field List, Add a Field, Move Part of a Paired Control, Align & Space Controls

    Using Design View
    Add a Label, Add an Image, Add a Rectangle, Add a Line, Edit an Unbound Control, Use Multiple Undo/Redo in Design View

    Using Editing Tools
    Change the Font, Change Character Format, Change Fill & Background Colors, Format Lines & Borders, Apply Special Effects, Conditional Formatting, Use Format Painter, Use AutoFormat, Use Error Checking, Run Spelling Checker, Set AutoCorrect Options, Add AutoCorrect Entries

    Using Advanced Form Design
    Use Forms in Design View, Create a Combo Box, Edit List Items, Create a List Box, Create an Option Group, Add a Logic Control, Set the Tab Order Automatically, Set the Tab Order Manually, Add a Form Header & Footer, Create a Blank Form

    Using Advanced Report Design
    Add Report Sections in Design View, Create a Calculated Control, Create a Running Summary, Insert a Date/Time Control, Insert a Page Break, Chang the Report Margins, Use the Label Wizard, Create a Report without Using a Wizard