Access 2 2003

Download PDF

Next Dates:

No dates available yet

Length:

1 day

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 235

Target audience & Prerequisites:

This Course is designed to cover important features of Access to users that have the basic knowledge of Access. Participants must be comfortable with Access Introduction concepts.

Learning objectives:

Upon completion of this course, participants will be familiar with advanced Table Design. They will also be more comfortable using complex queries, forms and reports.

Course Outline:

PRINCIPLES OF TABLE RELATIONSHIPS

Normalizing Data
Normalizing Date for Fourth and Fifth Normal Form

PRINCIPLES OF TABLE RELATIONSHIPS

Normalizing Table Relationships
Establishing and Testing Referential Integrity

TABLE DESIGN TECHNIQUES

Data Validations Techniques
Indexing Techniques

DESIGNING FORM DESIGNS

Using Calculated Fields in Queries
Creating Multiple-Table Queries

CUSTOMIZING FORM DESIGNS

Customizing the Form Design
Performing Calculation on a Form
Adding Combo Boxes and Unbound Controls

WORKING WITH DATA ACCESS PAGES

CUSTOMIZING REPORTS

Customizing Reports and Working with Subrepot

Remember that we build our schedule around your requests. Check out our Courses List, call us at (613) 235-6161 or email us at training@compuease.ca:

Calendar

Search

Course List