Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


Provides competency in database fundamentals, creating databases and tables, working with table data and structure, working with related tables, using select queries and advanced query features.


 
Course Outline


Basic

Topic-Level Outline

                       

          

             Unit 1 :           Database concepts

           Topic A: 0   Database concepts and terminology

           A-1:           Using database terminology

 

           Topic B: 0   Exploring the Access environment

           B-1:           Starting and examining the Access window

 

           B-2:           Opening a database

 

           B-3:           Examining the database window

 

           B-4:           Examining a database table

 

           Topic C: 0   Planning and designing databases

           C-1:           Planning a database

 

           C-2:           Exploring database relationships

 

           Topic D: 0   Getting help

           D-1:           Using the Ask a Question box

 

           D-2:           Using the Office Assistant

 

           Topic E: 0   Closing a database and Access

             E-1:             Closing a database and Access

 

             Unit 2 :           Access basics

           Topic A: 0   Exploring tables and forms

           A-1:           Discussing views

 

           A-2:           Examining a table in Datasheet view

 

           A-3:           Navigating in a table in Datasheet view

 

           A-4:           Examining a table in Design view

 

           A-5:           Identifying the primary key

 

           A-6:           Navigating in a form

 

           A-7:           Examining a form in Design view

 

           Topic B: 0   Examining queries

           B-1:           Planning a query

 

           B-2:           Examining a query in Design view

 

           B-3:           Running the query and viewing the results

 

           Topic C: 0   Exploring reports

             C-1:             Examining a report

 

             C-2:             Examining a report in Design view

 

             Unit 3 :           Creating databases

           Topic A: 0   Creating a database

           A-1:           Verifying object names

 

           A-2:           Creating a database by using the Database Wizard

 

           A-3:           Creating a blank database          

 

           Topic B: 0   Using the Table Wizard

           B-1:           Creating a table and setting a primary key using the Table Wizard

 

           Topic C: 0   Working in Design View

             C-1:             Creating a table in Design view

 

             C-2:             Adding text fields to a table

 

             C-3:             Adding fields of other data types

 

             C-4:             Entering field descriptions

 

             C-5:             Adding a Memo field

 

             C-6:             Setting the primary key

 

             C-7:             Saving the design and viewing the table

 

             C-8:             Adding a record

 

             Unit 4 :           Working with fields and records

           Topic A: 0   Changing the design of a table

           A-1:           Examining field names

 

           A-2:           Changing the name of a field

 

           A-3:           Deleting and inserting fields

 

           A-4:           Moving a field

 

           A-5:           Setting field properties

 

           Topic B: 0   Adding and deleting records

           B-1:           Adding a new record

 

           B-2:           Deleting a record

 

           Topic C: 0   Finding and editing records

           C-1:           Finding and replacing a value

 

           C-2:           Undoing changes

 

           C-3:           Using spelling checker

 

           Topic D: 0   Sorting and filtering records

             D-1:             Sorting records by a single field

 

             D-2:             Sorting records by multiple fields

 

             D-3:             Filtering records

 

             Unit 5 :           Querying tables

           Topic A: 0   Creating and using queries

           A-1:           Creating a simple query by using the Simple Query Wizard

 

           A-2:           Creating a simple query in Design view

 

           A-3:           Sorting query results

 

           A-4:           Filtering query results

 

           A-5:           Saving a query

 

           Topic B: 0   Modifying query results and queries

           B-1:           Editing query results

 

           B-2:           Modifying a query by adding more fields

 

           B-3:           Modifying a query by removing fields

 

           B-4:           Using comparison operators

 

           B-5:           Using the OR condition

 

           B-6:           Using the AND condition

 

           B-7:           Using the * wildcard

 

           B-8:           Finding records with empty fields

 

           Topic C: 0   Using calculations in queries

             C-1:             Using calculations in a query

 

             C-2:             Totaling a group of records

 

             C-3:             Calculating values with the Avg and Count functions

 

             Unit 6 :           Creating and using forms

           Topic A: 0   Creating forms by using AutoForm

           A-1:           Creating a form by using AutoForm

 

           A-2:           Navigating in a form by using the navigation bar

 

           A-3:           Using a form for data entry

 

           Topic B: 0   Using the Form Wizard

           B-1:           Creating a form by using the Form Wizard          

 

           Topic C: 0   Using Design view

           C-1:           Creating a form in Design view

 

           C-2:           Adding a title to a form

 

           C-3:           Adding controls

 

           C-4:           Modifying properties

 

           Topic D: 0   Finding, sorting, and filtering records

             D-1:             Using a form to find records

 

             D-2:             Using a form to sort records

 

             D-3:             Using a form to filter records

 

             Unit 7 :           Creating and using reports

           Topic A: 0   Using the Report Wizard and queries

           A-1:           Using the Report Wizard to create a report

 

           A-2:           Create a report by using a query

 

           Topic B: 0   Creating, modifying, and printing reports

             B-1:             Modifying the appearance of a report by using Design view

 

             B-2:             Grouping information in a report

 

             B-3:             Adding summary fields by using the Report Wizard

 

             B-4:             Modifying the layout and style of a report

 

             B-5:             Changing field properties

 

             B-6:             Printing a report

 

             Unit 8 :           Importing, exporting, and linking objects

           Topic A: 0   Importing Access objects

           A-1:           Importing an object from a database

 

           A-2:           Importing multiple objects

 

           Topic B: 0   Exporting Access objects

           B-1:           Exporting objects

 

           Topic C: 0   Exporting and importing XML documents

           C-1:           Exporting and importing XML documents

 

           Topic D: 0   Linking Access objects

   D-1:   Linking objects

 

   D-2:   Updating a link

 

   Appendix A :           MOUS exam objectives map

           Topic A: 0   Core exam objectives

           Topic B: 0   Expert exam objectives

 

 


Prerequisites & Certificates
Pre-Requisites

Windows 2000: 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, donít 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 297 times.