Ardito Corporate Training

Duration: 2 days | Book this course
Cost: $560.00 + GST

Course Description

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 customization 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
Participants should have completed the Basic Computer Skills course or, preferably have a working knowledge of Microsoft Excel. If you are unsure, you may phone our Bookings Administrator on (07) 857.0770 or (09) 630.1220.

Who Should Take This Course
New users of Microsoft Access.

Course Objectives

Upon completing this course, you will have learned how to:

1. Open an existing database and define database objects.
2. Plan and create tables.
3. Edit and print tables.
4. Customize the appearance / design of a table.
5. Create, manage, and modify table relationships.
6. Create filters and queries.
7. Query records using expressions.
8. Create forms, and use forms to enter and manage data.
9. Add and format controls on forms.
10. Manipulate data and make changes in Form view.
11. Create and use subforms.
12. Create reports.
13. Add and format controls on reports.
14. Import and export data.
15. Create switchboards and work in an automated database

Course Outline

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

Customizing Tables
Customizing 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 Customizing Queries
Understanding Queries
Creating a Query Using the Simple Query Wizard
Creating a Query in Design View
Customizing 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
Resizing 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
Resizing 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