Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


Provides competency in creating and using forms and sub forms, using advanced form features, reports, advanced report features, using data access pages, managing databases, and importing and exporting data.


 
Course Outline

Intermediate

Topic-Level Outline

                          

          

                         Unit 1 :  Creating relational databases

                               Topic A: 0  Database normalization

                               A-1:                               Determining first normal form

                               A-2:                               Determining second normal form

                               A-3:                               Determining third normal form

                               Topic B: 0  Relating tables

                               B-1:                               Establishing a one-to-one table relationship

                               B-2:                               Establishing a one-to-many table relationship

                               B-3:                               Establishing a many-to-many relationship

                               Topic C: 0  Implementing referential integrity

                         C-1:                         Planning table relationships

                         C-2:                         Working with orphan records

                         C-3:                         Setting cascading deletes

                         C-4:                         Testing cascading deletes

                         C-5:                         Setting cascading updates

                         C-6:                         Testing cascading updates

                         Unit 2 :  Working with related tables

                               Topic A: 0  Using the Lookup Wizard

                               A-1:                               Examining table relationships

                               A-2:                               Creating a Lookup list field

                               Topic B: 0  Modifying Lookup fields

                               B-1:                               Modifying Lookup field properties

                               B-2:                               Changing a text box control to another type of control

                               Topic C: 0  Adding data to related tables

                         C-1:                         Adding data to related tables

                         Unit 3 :  Defining data entry rules

                               Topic A: 0  Working with input masks

                               A-1:                               Creating an input mask to control how data is entered in a field

                               A-2:                               Creating an input mask for a combo box in a form

                               A-3:                               Working with the Input Mask Wizard

                               Topic B: 0  Setting properties

                               B-1:                               Setting the Required property for a field

                               B-2:                               Using the AllowZeroLength property for a field

                               B-3:                               Setting the Field Size property to limit field length

                               Topic C: 0  Setting validation rules

                         C-1:                         Establishing default values

                         C-2:                         Creating validation rules

                         C-3:                         Setting validation text

                         Unit 4 :  Using advanced query features

                               Topic A: 0  Joining tables in queries

                               A-1:                               Using a query to join tables

                               A-2:                               Creating a join in Design view

                               A-3:                               Creating an outer join

                               A-4:                               Creating a join by using an intermediate table

                               A-5:                               Creating a self-join query

                               Topic B: 0  Creating calculated fields

                               B-1:                               Creating a calculated field

                               B-2:                               Modifying the format of a displayed value

                               B-3:                               Using the Expression Builder

                               Topic C: 0  Using action queries

                         C-1:                         Copying a table object

                         C-2:                         Using an append query to add a record to a table

                         C-3:                         Deleting records with a delete query

                         C-4:                         Modifying records with an update query

                         C-5:                         Creating a make-table query

                         Unit 5 :  Creating advanced queries

                               Topic A: 0  Summarizing and grouping values

                               A-1:                               Creating a query to display summary values

                               A-2:                               Concatenating values

                               A-3:                               Finding records that do not match between tables

                               Topic B: 0  Creating crosstab queries

                               B-1:                               Viewing a crosstab query

                               B-2:                               Creating a crosstab query with the Crosstab Query Wizard

                               Topic C: 0  Using parameter queries

                               C-1:                               Creating a single-criterion parameter query

                               C-2:                               Creating a query with multiple parameters

                               C-3:                               Using a wildcard in a parameter query

                               Topic D: 0  Using indexes

                         D-1:                         Creating a single-field index

                         D-2:                         Creating a multiple-field index

                         Unit 6 :  Creating advanced form design

                               Topic A: 0  Adding graphics

                               A-1:                               Adding a graphic to a form

                               A-2:                               Embedding a graphic in an unbound object frame

                               Topic B: 0  Adding calculations

                               B-1:                               Binding a control to a calculated field

                               B-2:                               Creating a calculated control

                               B-3:                               Aligning objects

                               Topic C: 0  Adding combo boxes

                               C-1:                               Adding a combo box to a form

                               C-2:                               Modifying the properties of a combo box

                               Topic D: 0  Adding unbound controls

                         D-1:                         Adding an unbound control to a form

                         D-2:                         Drawing a rectangle around a control

                         D-3:                         Changing tab order

                         Unit 7 :  Using advanced report features

                               Topic A: 0  Creating customized headers and footers

                               A-1:                               Adding a report header

                               A-2:                               Adding a report footer

                               A-3:                               Applying conditional formatting

                               A-4:                               Keeping parts of the report on the same page

                               A-5:                               Adding controls to group footers

                               A-6:                               Forcing a new page

                               A-7:                               Working with the HideDuplicates property

                               Topic B: 0  Adding calculated values

                               B-1:                               Working with the DateDiff function

                               B-2:                               Using the IIF function

                               Topic C: 0  Working with subreports

                         C-1:                         Embedding the subreport

                         C-2:                         Viewing and troubleshooting report results

                         Unit 8 :  Creating charts

                               Topic A: 0  Creating charts in forms

                               A-1:                               Creating a chart in a form

                               A-2:                               Enhancing a chart in a form

                               Topic B: 0  Creating charts in reports

               B-1:               Adding a chart to a report

               B-2:               Modifying a chart in a report

               Appendix A :  Working with data access pages

                               Topic A: 0  Creating a data access page

               A-1:               Creating a data access page by using the Page Wizard

               Appendix B :  MOUS exam objectives map

                               Topic A: 0  Core exam objectives

                               Topic B: 0  Expert exam objectives

 

 

 

 


Prerequisites & Certificates
Pre-Requisites

Access 2001: Basic

Certificates offered

MANUALS / CERTIFICATES
All program fees include a manual on CD complete with self study lessons. Course manuals can be purchased for an additional fee and are dependent on subject and level. The manual fee is a passed through cost to our clients.
Upon completion of the each program each participant will receive a certificate of completion.
PARKING
Parking is available for our students at the rear of the building.Please, dont park in the reserved parking spaces around the building, your car will be tagged and/or towed away.
BREAKS AND LUNCH
Our courses run between 9:00AM 4:00PM. There are two 15 minutes coffee breaks: one at 10:30AM and the other are at 2:30PM. The lunch break is between 12:00AM and 1:00PM.
REFRESHMENTS
Coffee and suitable drinks are provided by us during the course. There are numerous restaurants and take-out places in the area, or you may prefer to bring your own lunch and enjoy it on site. Microwave and fridge available.


Cancellation Policy
Commitment of resources and industry standards require that we be notified of any cancellation. As such, you may reschedule any training course up to five (5) working days before the actual training date. Simply call us, and we send you a new registration confirmation without extra charge. If training is rescheduled less than five (5) working days before the training date, a rescheduling fee of 50% of the course fee will be invoiced.

The latest time we accept rescheduling is until noon on the working day before
the training date. "No-shows" without prior notification are charged as if you had attended the course. There are no refunds. We reserve the right to cancel any course and reschedule if attendance is not sufficient to run the course. In this case you will be notified, usually five (5) working days or more prior to the
training day and the training is rescheduled.

Map & Reviews
Careers in Transition
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 225 times.