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
This course provides competency in database fundamentals, working with Access objects, creating databases and tables, working with table data and structure, locating information, working with related tables, using select queries and advanced query features, and creating advanced queries.
Unit 1 : Database concepts
Topic A: 0 Database concepts and terminologyA-1: Using database terminology
Topic B: 0 Exploring the Access environmentB-1: Starting and examining the Access window
Topic C: 0 Planning and designing databasesC-1: Planning a database
Topic D: 0 Getting helpD-1: Using the Ask a Question box
Topic E: 0 Closing a database and AccessE-1: Closing a database and Access
Unit 2 : Access basics
Topic A: 0 Exploring tables and formsA-1: Discussing views
Topic B: 0 Examining queriesB-1: Planning a query
Topic C: 0 Exploring reportsC-1: Examining a report
Unit 3 : Creating databases
Topic A: 0 Creating a databaseA-1: Verifying object names
Topic B: 0 Using the Table WizardB-1: Creating a table and setting a primary key using the Table Wizard
Topic C: 0 Working in Design ViewC-1: Creating a table in Design view
Unit 4 : Working with fields and records
Topic A: 0 Changing the design of a tableA-1: Examining field names
Topic B: 0 Adding and deleting recordsB-1: Adding a new record
Topic C: 0 Finding and editing recordsC-1: Finding and replacing a value
Topic D: 0 Sorting and filtering recordsD-1: Sorting records by a single field
Unit 5 : Querying tables
Topic A: 0 Creating and using queriesA-1: Creating a simple query by using the Simple Query Wizard
Topic B: 0 Modifying query results and queriesB-1: Editing query results
Topic C: 0 Using calculations in queriesC-1: Using calculations in a query
Unit 6 : Creating and using forms
Topic A: 0 Creating forms by using AutoFormA-1: Creating a form by using AutoForm
Topic B: 0 Using the Form WizardB-1: Creating a form by using the Form Wizard
Topic C: 0 Using Design viewC-1: Creating a form in Design view
Topic D: 0 Finding, sorting, and filtering recordsD-1: Using a form to find records
Unit 7 : Creating and using reports
Topic A: 0 Using the Report Wizard and queriesA-1: Using the Report Wizard to create a report
Topic B: 0 Creating, modifying, and printing reportsB-1: Modifying the appearance of a report by using Design view
Unit 8 : Importing, exporting, and linking objects
Topic A: 0 Importing Access objectsA-1: Importing an object from a database
Topic B: 0 Exporting Access objectsB-1: Exporting objects
Topic C: 0 Exporting and importing XML documentsC-1: Exporting and importing XML documents
Topic D: 0 Linking Access objectsD-1: Linking objects
Appendix A : MOUS exam objectives map
Topic A: 0 Core exam objectives
Topic B: 0 Expert exam objectives
- Prerequisites & Certificates
Windows 2000: Basic
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 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.
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 ]
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.
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 548 times.