2007Ó Integrity Computer Solutions.
The
Learning Laboratory
innovate results trust
ABN: 94 081 457 454
11th Floor
Adelaide Bank Building
90 King William Street
ADELAIDE SA 5000
Tel. 1300 731 451
Fax. (08) 8231 2427
www.learnlab.com.au
labinfo@learnlab.com.au
Integrity
Training Solutions
innovate results trust
ABN: 58 309 252 680
Suite 2, Level 1
902 Mt Alexander Road
Essendon VIC 3040
Tel. 1300 731 451
Fax. (03) 9372 9382
www.integritytrainingsolutions.com
info@integritytrainingsolutions.com
A division of...
Microsoft Access Using a Database - Course Outline
Duration
1 day Course
Course Aims
This course will provide new users with the skills to USE an existing database.
Learning Outcomes
Upon completion of this course the participant will be able to:
• open and close Access • use shortcuts to move around a table
• identify parts of the Access screen • delete records
• identify parts of a Database • create basic queries
• analyse an existing Database • create basic reports
• add and modify records • print reports
Training Method
Training is conducted by professional trainers, using hands on exercises and user practise to consolidate concepts.
Prerequisite
Windows XP Getting Started course or equivalent. Participants must have good mouse skills.
Course Content
Getting Started
• What is a Database • What is a Relational Database
• Starting Access • Exiting Access
• Database Window • Opening a Database
• Closing a Database • Database container;
• Tables • Queries • Forms • Reports
• Macros • Modules
Analysing an Existing Database
• Discovering the structure • Relationships (an overview)
• The Relationship Window • Commonly used Database terminology
Data Entry
• Adding records • Adjusting column width
• Moving around tables • Editing records
• Delete records • Moving columns
• Showing and hiding columns • Finding records
• Filtering by selection • Automatic saving
Creating Basic Queries
• Creating Basic Reports