Microsoft Access

Microsoft Office 2013 Access – Level I

This course is designed for students with little or no database experience. Examine basic database concepts,create and modify databases, and perform basic queries. Learn to query a database and generate reports. Students have the opportunity to practice these skills.

Length: 1—day (8:30am – 4:00pm)

Course Cost: $310.00 + GST

Objectives:

Identify the basic components of an Access database

Build the structure of a database

Manage data in tables

Query a database

Design forms

Generate reports

Microsoft Office 2013 Access – Level II

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.

Length: 1—day (8:30am – 4:00pm)

Course Cost: $310.00 + GST

Objectives:

Design a relational database.

Join tables to retrieve data from unrelated tables.

Organize a database for efficiency and performance, and to maintain data integrity.