Access Fundamentals

Course Overview

This class takes students through Microsoft Access from the basics to a complete database level. Topics include: opening databases and defining database objects; creating databases; planning, creating, editing, printing and customisation of tables.

Students will also learn how to create, manage, and modify table relationships; create filters and queries; and query records using expressions, create and format forms, subforms, and reports. In addition, the course will cover how to manage data, add controls on forms and reports, import and export data, and create switchboards and work in an automated database.

Prerequisites

Windows 95/98/2000/XP Introduction or equivalent knowledge

Audience

New users of Microsoft Access

Cost

NZ $550

Learn To

• Open an existing database and define database objects.
• Plan and create tables.
• Edit and print tables.
• Customise the appearance / design of a table.
• Create, manage, and modify table relationships.
• Create filters and queries.
• Query records using expressions.
• Create forms, and use forms to enter and manage data.
• Add and format controls on forms.
• Manipulate data and make changes in Form view.
• Create and use subforms.
• Create reports.
• Add and format controls on reports.
• Import and export data.
• Create switchboards and work in an automated database

Duration

2 Days

Location

Hamilton & Auckland, New Zealand

Schedule

• 12th May 2008
• 24th June 2008
• 16th July 2008

Objectives

Obtaining Help

• Understanding Database Objects
• Understanding Naming Conventions

Creating Databases

• Using the Database Wizard
• Creating a Blank Database

Creating Tables

• Using the Table Wizard to Create Tables Creating a Table in Datasheet View
• Planning for Multiple Tables
• Creating a Table in Design View

Editing and Printing Tables

• Adding Records to a Table
• Navigating Through a Table
• Selecting and Modifying Records
• Manipulating Data and Printing Tables

Creating Table Relationships

• Introducing Table Relationships
• Editing and Deleting Table Relationships

Customising Tables

• Customising Columns and Rows
• Changing the Appearance of Data
• Inserting and Deleting Fields
• Using the Lookup Wizard
• Creating Hyperlinks
• Changing Field Properties

Table Filters

• Working with Filters
• Creating Filters

Creating and Customising Queries

• Understanding Queries
• Creating a Query Using the Simple Query Wizard
• Creating a Query in Design View
• Customising a Query

Working with Query Expressions

• Using Expressions in a Query
• Specifying Multiple Criteria
• Creating Calculated Fields
• Performing Mathematical Calculations

Introduction to Forms

• Understanding Forms
• Opening / Using / Closing a Form
• Navigating Through Forms
• Managing Data with Forms
• Printing a Form
• Creating AutoForms
• Creating Forms with the Form Wizard

Working with Forms in Design View

• Understanding the Parts of a Form
• Resising Sections on a Form
• Using AutoFormat
• Understanding Controls
• Selecting / Manipulating / Formatting Controls
• Adding Controls to Forms
• Applying Conditional Formatting
• Creating Forms in Design View
• Inserting the Date and Time
• Understanding the Toolbox
• Adding and Using Controls from the Toolbox
• Using List Boxes and Combo Boxes
• Adding / Creating a Calculated Control
• Adding Graphic Elements
• Adding Lines, Rectangles, and Images
• Managing Properties
• Changing the Properties of a Control
• Changing Section Properties
• Changing Form Properties

Working with Forms in Form View

• Manipulating Data
• Sorting Records
• Finding Data in Forms
• Replacing Data using Forms
• Working with Filters
• Using Filter For, Filter By Selection &
• Filter By Form
• Making Changes in Form View
• Formatting Controls
• Applying Conditional Formatting
• Changing Properties

Working with Subforms

• Creating and Using Subforms

Introduction to Reports

• Understanding Reports
• Using Reports
• Opening, Printing, and Closing Reports
• Creating AutoReports
• Creating Reports Using Wizards
• Creating a Standard Report
• Creating a Mail Merge with Access Data
• Creating Labels
• Creating a Chart

Working with Reports in Design View

• Using Design View
• Understanding the Parts of a Report
• Resising Sections on a Report
• Using AutoFormat
• Working with Controls
• Selecting, Manipulating, and Formatting Controls
• Adding Controls to Reports
• Creating Reports in Design View
• Understanding Controls
• Inserting the Date and Time
• Inserting Page Numbers
• Understanding the Toolbox
• Using the Toolbox Controls
• Adding Graphic Elements
• Adding Lines, Rectangles, and Images
• Managing Properties
• Changing Properties
• Changing the Report Layout
• Sorting and Grouping Records
• Working with Page Breaks
• Adding Calculated Controls
• Creating a Calculated Control
• Concatenating Text
• Adding a Subreport to an Existing Report

Importing and Exporting Data

• Importing Data
• Importing Spreadsheet Data
• Importing a Text File
• Linking Tables to an External Source
• Exporting Data
• Exporting a Database Object to Another Access Database
• Exporting Data to a Text File
• Exporting Data to a Spreadsheet or Rich Text Format
• Exporting Data to Microsoft Applications using Office Links

Working with an Automated Database

• Understanding an Automated Database
• Navigating in an Automated Database
• Opening an Automated Database
• Using a Switchboard
• Closing an Automated Database
• Editing a Switchboard Using the Switchboard Manager
• Adding Buttons to a Switchboard Page
• Moving and Deleting a Button on a Switchboard Page
• Creating a New Switchboard Using the Switchboard Manager