Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


This three-day course takes an in-depth look at three topics: relating tables, creating forms and creating reports. We look at relating tables, then how to create queries, forms and reports that are based on related tables.


 
Course Outline
Almost all databases use multiple relational tables, and this course teaches you why and how to work with them.
Building on the base of the Introduction course, you will create your own small relational database. Once that€(TM)s done you€(TM)ll move on to making reports based on it, in particular learning how to join together information from multiple tables into single sources of data, including data that is outside the database in Excel. You€(TM)ll also learn how on-screen forms and print-outs are affected by having two or more tables in play at the same time, as well as sophisticated form tools like drop-down boxes.

This course is classroom style instruction: Instructor-led, hands-on training.

Creating Forms

Creating a Form
Using the Wizard
Creating a Form from Scratch
Add Text
Add Fields & Formulas
Add a Picture/Drawing
What are Controls?
Select Boxes
Move and Size Controls
Align Controls and the Different Views
Basic Formatting
Using the Colour Icons
Spacing Between Objects
Delete Objects
Cut, Copy, Paste
Copy Formats
Bring to Front/Send to Back
The Toolbox
Tab Order
Print
Forms Based on Multiple Tables
Control Properties
Name
Control Source
Default Value
Validation Rule, Validation Text
Format, Decimal Places
Custom Date Formats
Input Mask
Status Bar Text & Control Tip
Enabled & Locked
Tab Stop
Combo Boxes
Type 1 - You Type a List of Choices
Type 2 - Display Data from a Table
Type 3 - Display from Master Table, Store
in Related Table (Linked)
Working with Bands/Form
Change the Background Colour
Rulers/Grid
Form Properties
Command Buttons
Creating with the Wizard
Subforms
Add to Main Form
About Child Fields and Master Fields
Edit a Subform from within the Main Form
Relating Tables
Why Relate Tables?
How to Relate Tables
Referential Integrity
Cascade Update/Delete
Testing the Relationship
Edit and Delete Relationships
Primary Keys and Unique Indexing
See Related Data in a Table

Creating Reports
All Applicable Forms Topics, plus:
Wizards, Creating a Blank Report
Print Preview vs. Layout Preview
Page Setup
Report Bands & Band Properties
Sorting and Grouping
Calculations in a Report
Envelopes
Label Wizard
Import, Export, & Link
Importing and Linking Tables
Exporting Tables or Queries
Word Merge

Prerequisites & Certificates
Pre-Requisites

Solid understanding of all Access Introduction topics is required.

Certificates offered

Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion


Cancellation Policy
A full 5 business days notice is required to change or cancel any course date.

Once payment has been received, a credit will be held in your account if we have received sufficient notice of your cancellation or date change (we do not provide refunds). If insufficient notice is received, the entire fee or Tickets for that course date will be charged.

There is no charge for substitutions. If you cannot attend your course and cannot provide the 3 business days notice, you can send someone else in your place with no penalty.

Course Retake

If you cannot provide 5 business days notice of cancellation, you may take the course at a later date at no further charge with the following conditions.

1. You must take the course within 6 months of the original course date (no exceptions). After that time, the full course fee will be charged again.

2. Registration is on a stand-by basis only. If the course date you select becomes fully booked you will be asked to choose another date, which must be within 6 months of the original course date.

3. If you need to change or cancel your free re-take course, we must receive a full 5 business days notice of the change. If insufficient notice is received, this offer no longer applies and the full course fee will be charged again, should you choose to book another date.

4. This course is not transferable to another person. It must be taken by the same person who was scheduled for the original course.

5. This offer applies to the same course only (same software program, same course level and the same software version as was originally booked).
Map & Reviews
Excel Training Toronto
[ 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.

Here are some reviews of the training vendor.
Horrible directions to facility - should include recognizable locations, sites, instead of just east-west-north-south. More instructor emphasis on course content less time talking about irrelevant anecdotes from previous classes. E.g., Honda assembly or most memorable students. Prefer more time on the content of course as she rushed a lot of it toward the end due to lack of time Was a good knowledgeable instructor nonetheless.
Reviewed by 2013
The content was easy to follow and the instructor was very knowledgeable and was able to teach to the level of the participants.
Reviewed by 2013
I was the only pupil in the class. The instructor could have learned about me (my employer, job description, background in PPT) beforehand, or just asked me -- I told him I don't use PPT on an everyday basis and he assumed I was a beginner and started telling me I should be in the beginner course and scolded me for "not reading course descriptions" before enrolling. I found his assessment to be inaccurate and a bit insulting... just because I don't use PPT every day in my current role doesn't mean I can't insert a text box!
Reviewed by 2013
Donna was an excellent trainer. She took the time to determine each person's needs and desires of why they were attending the course. She was then able to apply training towards each attendees specific needs.
Reviewed by 2013
Course offer introduction to form creation only. It does not go in depth to form filling, distribution and collection.
Reviewed by 2013
This was a very worthwhile course. The instructor, Rob, was a great instructor, and I loved the extra history lessons too. Thanks for a great session!
Reviewed by 2013
Unfortunately, i found too much time spent on obscure applications of Excel. We spent most of the course on Excel, save for couple hours in afternoon. I was anticipating much more time on Outlook, Word and PowerPoint and Excel as a low priority. This may not be the instructor's fault, but a miscommunication when we enrolled.
Reviewed by 2013
There was no afternoon break - we finished shortly after 3 around 3:15 made for a long afternoon.
Reviewed by 2013
Make the print larger in the booklets
Reviewed by 2013
The breaks were way to long and the course material was streched out and thus way more could of been covered in 2 days than what was covered.
Reviewed by 2013
Good course, covered all the basics
Reviewed by 2013
Trainer was great, he was very knowledgable in the topic! The course was great, however I would have liked to complete exercises at the end of each topic as oppose to one big exercise at the end.
Reviewed by 2013
The computers used for the training were slow, and had a tendency to freeze up when trying to open new documents. While there aren't many differences between 2007 and 2010, I had signed up with the understanding 2007 would be taught alongside 2010, but when I got there, I was asked to use 2010.
Reviewed by 2012
Really enjoyed both the instructor and the course. Very professional, practical and efficient.
Reviewed by 2012
The trainer was interesting and answered all our questions! He was very knowlegeable and I would take another seminar with this instructor.
Reviewed by 2012
the hour lunch was too long. two 15min breaks and one 30min lunch would be fine
Reviewed by 2012
I would love to take this course for Level two with same instructor Tina.
Reviewed by 2012
Well run, good pace given that all three versions of Project had to be covered simultaneously.
Reviewed by 2012
Perhaps give option for 1/2 hour lunch as not familiar with area and just passing time during the break.
Reviewed by 2012
I think the intermediate course could be taught in 1 day rather than 2
Reviewed by 2012
The instructor, Katie Geoghan was phenomenal. Her energy and level of expertise were wonderful. This is the best class I have ever attended and I learned so much from it.
Reviewed by 2011
Too much material to cover, did not really learn what I went for. One hour is way too long a break, especially since you can't work on your own, you need the instructor to be present. We went to learn, not eat.
Reviewed by 2011
I was extremley impressed with the Instructor, Katie Geoghegan. Katie was very outgoing and easy to talk to. No questions was a "stupid" question. She went thru the course manual step by step. She made sure that everyone understood what they were doing before we moved on. She was very pleasant thru out the day. I walked out of that cours feeling very confident.
Reviewed by 2011
The course was excellent and the instructor was very helpful and knowledgeable. I am recommending this course to my colleagues.
Reviewed by 2011
I had no previous exposure to Pivot Tables and was a bit apprehensive at the start of the course, however the presenter made it really easy to grasp the concepts and made sure I was learning at the same pace as the rest of the class, which I really appreciated!
Reviewed by 2011
recommend you update the content to Exchange SP1
Reviewed by 2011
Really enjoyed the course and and Katie G the instructor was absolutely fantastic. I would definately take another course with her for excel in the near future.
Reviewed by 2011
Material covered too quickly. No opportunity for exercises.
Reviewed by 2011
I had already filled out an evaluation for this course at the end of the course so I am not sure why I have to do it again???
Reviewed by 2011
Instructor needs to use breath mints. As to the course, it's understood that there was a great deal to cover in two short days. However, I did feel we didn't have enough time to work with individual elements (through exercises) to get a solid personal grasp. It's one thing to listen to someone talk about a procedure. You do not learn until you have a chance to do it. Also, we weren't given a final exercise of designing a simple page to try to bring together all the material presented.
Reviewed by 2011
A lot of information to cover in one day. Maybe 2 days would be better to adsorb info and have more for excerises. The handout was not easy to read as it was very small font and the print was too light/faded (almost like it needed a new toner).
Reviewed by 2011
Great instructor
Reviewed by 2011
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 1343 times.