Software School

For more information, please :
send email to trainer@softwareschool.ca or call us at (780) 452-8907

Training and Consulting in Windows, PowerPoint, Publisher, QuickBooks, Simply Accounting, Office, Word, Excel, Access, Outlook.

 

Introduction to MS-ACCESS

Prerequisites: Basic Windows skills or a Windows Course

Course outline:

 

What is a database?
Basic concepts, terms and features

Parts of Access
- Tables
- Queries
- Forms
- Reports
- Macros

Creating, modifying and managing Tables

Querying a database
- Getting only selected data
- Getting data from multiple tables

Creating simple forms and reports

Customizing Tables
- Relationships
- Referential Integrity
- Cascade Update/Delete
- AutoLookup

Forms
- Using multiple tables; Subforms
- Controls - Calculated, Calendar
- Automating with simple macros

Queries
- Adding calculated fields
- Parameter Queries

Reports
- Calculations in a report
- Report on selected data, using a Parameter Query