MS Access 02 / 03 Introduction Course Outline

COURSE INFORMATION

Duration: Two Days: 9am - 4:30pm
Price: $780
Book: Enquire or make a course booking

TARGET AUDIENCE & PURPOSE

This Access Introduction Course is for people new to databases, and for self-taught users to enhance their knowledge. It is a pre-requisite for the Intermediate and 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

PREREQUISITES

Participants should already be competent in using a mouse and keyboard and have an understanding of Windows.

COURSE CONTENT

Exploring Access
Using Menu Commands, Displaying & Hiding Toolbars, Changing Menu & Toolbar Options, Using Database Objects, Using the Database Window, Opening a Database Object, Using the Task Pane

Creating Tables
Using the Database Wizard, Creating a New Database, Designing Tables, Creating a Table in Design View, Using Design View, Adding Field Names, Assigning Data Types, Adding a Field Description, Setting a Primary Key, Saving a New Table, Using the Table Wizard

Working with Tables
Using Datasheet View, Navigating Fields in Tables, Adding Records, Moving through Records, Selecting Records, Saving Records

Editing Tables
Changing the Row Height, Changing the Column Width, Changing a Font Attribute, Changing a Cell Effect, Selecting a Column, Moving a Column, Hiding a Column, Unhiding a Column, Freezing a Column

Finding & Filtering Data
Sorting Records, Finding Specific Records, Finding Records using Wildcards, Using Replace, Using Filter By Selection, Applying / Removing a Filter, Using Filter Excluding Selection, Using Filter For

Printing Data
Changing Page Setup, Using Print Preview, Printing Selected Records

Creating Relationships
Using Related Tables, Creating a Relationship between Tables, Setting Referential Integrity, Viewing Subdatasheets, Deleting a Join Line

Using Simple Queries
Using Queries & Recordsets, Creating a Query in Design View, Adding a Table to a Query, Joining Tables in a Query, Running a Query

Modifying Query Results
Sorting a Query, Adding Criteria to a Query, Hiding a Field in a Query, Adding a Record using a Query, Printing a Query

Creating Basic Forms
Using Forms, Using the Form Wizard, Viewing Records in a Form, Printing Records in a Form, Basing a Form on a Query, Using AutoForm, Adding a Record using a Form

Creating Basic Reports
Using Print Preview, Printing Pages of a Report, Grouping & Summarizing, Basing a Report on a Query, Using AutoReport

Modifying Tables
Inserting a Column into a Table, Inserting a Lookup Column, Inserting a Hyperlink Column, Creating a Many-to-Many Relationship		 Setting Field Properties
Limiting Field Size, Setting Number Formats, Setting Date/Time Formats, Setting Yes/No Formats, Setting Default Values, Setting Validation Rules, Creating an Input Mask – Wizard, Creating an Input Mask Manually, Creating a Custom Input Mask, Typing a Lookup List, Modifying Lookup Properties

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

Designing Advanced Queries
Setting Top Values in a Query, Creating a Calculated Field, Formatting a Calculated Field, Creating a Function Query, Creating a Parameter Query, Creating a Concatenation in a Query, Filtering a Query

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

Manipulating Controls
Using Controls, Selecting Non-adjacent Controls, Selecting Adjacent Controls, Deleting & Moving Controls, Sizing a Control by Dragging, Sizing Controls Automatically, Changing a Control Property

Using Design View
Hiding the Ruler, Disabling the Snap to Grid Feature, Displaying the Field List, Adding a Field, Moving Part of a Paired Control, Aligning Controls Spacing Controls, Using the Toolbox, Adding a Label, Image, Rectangle, Line, Editing an Unbound Control, Using Undo/Redo in Design View

Using Editing Tools
Selecting Objects with the Toolbar, Changing the Font, Font Size, Character Format, Font Colour, Fill & Background Colours, Formatting Lines & Borders, Applying Special Effects, Using the Format Painter Using AutoFormat, Setting AutoCorrect Options

Using Advanced Form Design
(Time Permitting)
Using Forms in Design View, Creating a Combo Box, List Box, Option Group, Adding a Logic Control, Setting the Tab Order, Adding a Form Header & Footer, Creating a Blank Form

Using Advanced Report Design
(Time Permitting)
Adding Report Sections in Design View, Creating a Calculated Control, Grouping Data in a Report, Creating Group Headers & Footers, Creating a Running Summary, Inserting a Date/Time Control & Page Break, Changing the Report Margins, Using the Label Wizard

 

Access 02 / 03 Intro

Course Inclusions