Software School

For more information, please :
send email to 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

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

- Adding calculated fields
- Parameter Queries

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