Course Outline
Pre-Requisites
Good understanding of Windows and Microsoft software
Lessons
Upon completion of the course, participants will be able to accomplish the following: identify the components of a database, and work with those components; open a table, find information stored there, and enter data; create several query types, edit and run queries, and use action and calculation queries; create several report types, enhance reports and print preview reports, preview and print database objects, and change the page setup options.
Please note this class is designed for PC users. You will need Microsoft Access downloaded and activated on your computer to participate.
Course Outline
- The Basics
- Database Concepts
- Getting Started
- Creating a Database
- Converting Access Files
- Working with Objects
- Using Access Help
- Table Data
- Table Concepts
- Viewing Data in a Table
- Changing the Datasheet Appearance
- Entering and Editing Data
- Applying Filters
- Queries
- Using the Query Wizard
- Creating a Query in Design View
- Selecting and Sorting in a Query
- Calculations
- Action Queries
- Parameter Queries
- Reports
- Creating Reports
- Using the Report Wizard
- Previewing Reports
- Creating Reports in Design View
- Changing Report Design
- Control Operations
- Control Attributes
- Printing
- Printing Objects
- Print Preview
Cancellation Policy
10 business days cancellation or full course fee will be charged
Training Location
Online Classroom
.
.,
.
.
I had a very bad experience with the instructor - he centered me out throughout the entire class - asked me continuously if I on pace or knew how to do the work. If I asked him a question he seemed anger made me feel little, stupid, he was very condescending. At one point he helped me and he said things like "this is a desktop" "do you know that?" others laughed. I almost left the course halfway through. I'm a much older person and First Nations and I'm shocked he treated me the way he did. It's like I was less of a person, discriminating, and etc.