Microsoft Access

Our introductory course will provide you with an excellent overview of the product and allow you to build a database with tables, data entry forms, filters, and reports. You will learn and apply the elements needed for a good design / plan in a database that you build from scratch. This course covers all of the fundamentals thoroughly and is good for users, designers, and self taught individuals. You will use the wizards briefly, but more importantly you will build your own elements for full control of them.
Database Concepts
* What is a Database? & Why use Access?
* Microsoft Database File (MDB)
* Planning and Determining database needs

Using Microsoft Access
* The Access Window
* Tool and Menu Bars
* The Database Window & Database Objects

* Creating Tables using the Wizard
* Creating Tables in Design View
* Fields, Field Properties and Data Types
* The Primary Key
* Adding Data
* Sorting, Filtering and Searching in the Datasheet View

* Sorting and Filtering using a Query
* Using a Parameter to filter a Query
* Calculations using Queries

* Setting up a Data Entry Form for Ease of Use
* Navigating, Adding and Deleting from Form
* Using Form Design for Modifying Format and Layout
* Adding Form controls to enhance the Form

* Report Wizard
* Grouping Report
* Reports from Queries
* Summary Reports
* Mailing Labels
Cost:$259/person (+ hst) includes workbook, certificate & 2 month hotline
Guarantee:Repeat at no charge up to 2 months later! (minimum class size required)
Duration:1 day(s) 9:00 am - 4:30 pm or 2 evenings 6:00 pm - 9:00 pm
Prerequisite:We recommend a good knowledge of Windows