Calendar

January 2012 February 2012 March 2012
Mo Tu We Th Fr Sa Su
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29

Search

Search

Course List

Request a course date
  Sign Up to our News letter Today!

 

Access 2 2003
Download PDF

Next Dates:
Thu, 16. Feb. 2012
Tue, 13. Mar. 2012
Tue, 08. May. 2012

Choose a date:


Mode:

Length:
1 day

Location:
Ottawa

Language:
EE

Max Attendees:
10 students

Price:
$ 235

Target audience & Prerequisites:
Participants must be comfortable with Access Introduction concepts. 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. 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: