access-icon

Access Courses

access-icon

Access Level 1

Level:
For beginners

Audience:
Most suitable for people who had some experience with Excel databases and wish to create a more complete solution with Access. This program requires a lot of practice before being able to design a stable database, therefore it is only recommended for students who will have this time to practice (1-2 hrs/day for 2-3 weeks). It is also recommended to do Access Level 1 and 2 together to provide the student with the main topics of database design.

Aim:
of this course is to understand the concept of a database, its different objects, and relationships between tables (modelling). At the end of this course, students will be able to create a new database, create tables by adding fields, setting up the data type and modify the different properties.

Overview:
Module 1: The Screen and Help
Module 2: Working with Existing Tables
Module 3: Creating Database and Tables

Cost

$700 + GST

Venue
Advantage Training Centre

Duration
Two days (L1 & L2)

Quantity:

Select a Date:

Access Level 2

Level:
For intermediate levels

Audience:
Most suitable for people who had some experience with Excel databases and wish to create a more complete solution with Access. This program requires a lot of practice before being able to design a stable database, therefore it is only recommended for students who will have this time to practice (1-2 hrs/day for 2-3 weeks). It is also recommended to do Access Level 1 and 2 together to provide the student with the main topics of database design.

Aim:
of this course is to design the relationships between tables (modelling), creating selection queries with criteria, linking tables through queries, understanding what summary and compound queries are. The student will also start using the form and report wizards in order to create simple forms/reports.

Overview:
Module 1: Importing/exporting
Module 2: Relationships
Module 3: Queries
Module 4: Forms and Reports Wizards

Cost

$700 + GST

Venue
Advantage Training Centre

Duration
Two days (L1 & L2)

Quantity:

Select a Date:

related COURSES