Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


Upon completion, students will understand inserting & deleting text into a document, enhancing tables by creating lookups, creating advanced forms by adding controls, subforms, calculations, & graphic images, working with & creating web-based objects.


 
Course Outline
This course will take students further into the intermediate features of Access. Upon completion of this course students will understand inserting and deleting text into a document, enhancing tables by creating lookups, creating advanced forms by adding controls, subforms, calculations, and graphic images, and working with and creating web-based objects.

Course Content Database Overview
  • Database Overview
Enhanced Tables
  • Copying a Database
  • Lookup Fields
  • Creating a Lookup
Advanced Queries
  • Query Overview
  • The Query Wizard
  • Nested Queries
  • Query Joins
  • Make Table Queries
  • Append Queries
  • Summary Queries
  • Crosstab Queries
Advanced Forms
  • Form Design
  • Controls
  • Form Properties
  • Subforms
  • Advanced Calculations
  • Customizing Forms
Advanced Reports
  • Designing Reports
  • Sorting and Grouping
  • Layout Properties
  • Calculations
  • Subreports
  • Graphic Reports
  • Chart Wizard
Supplemental Topics: Working with Web Tools
  • Working with Web Pages
  • Data Access Pages
  • Hyperlinks

Additional Details
Pre-Requisites

Access 2007 - Level I or equivalent knowledge/experience

Certificates offered

Certificate of completion


Cancellation Policy
10 business days cancellation or full course fee will be charged
Map & Reviews
Technology Training Centre
[ 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.
Enjoyed the day
Reviewed by 2012
Concise, clear and well presented. I would request this facilitator for any future courses based on my confidence is her ability to communicate effectively and based on her knowledge of the materials.
Reviewed by 2012
We were hoping there would be more about 'forms'. (Portfolio was interesting, but not really releveant to my needs). - Actually, my boss asked if we talked about Forms Manager, I said no, and then we couldn't decide if Forms Manager is something that was discontinued in X (from 9).
Reviewed by 2012
Parking facilities at the UofA are incredibly expensive, for those who need to drive there. $40/day for parking was disappointing!
Reviewed by 2012
Made sure you did everyting twice, was double checked by instructor.
Reviewed by 2012
Had never done Excel before, it was all greek to me. Maybe need to repeat work sheets twice. I will come back for repeat class.
Reviewed by 2012
Great course
Reviewed by 2011
Course instuctor did not hand out the manuals until end of the day. Therefore not able to write notes in for reference later on. - kinda silly.
Reviewed by 2011
You shoudl have a Excel 3 class available
Reviewed by 2011
Great training, had to meet the various needs from no experience to some with experience. Washrooms looked tired and need of improvement. Personally prefer an early start/early finish 8am to 3pm would be great
Reviewed by 2011
Course materials were not handed out till the end of the course and may have been useful to follow along. Some of the example/course files were missing from my folder.
Reviewed by 2011
The Instructor was very knowledgable on the subject. The class moved quickly. I think an additional day would have been nice.
Reviewed by 2011
Trainer was open to answering questions and provide information in a clear manner.
Reviewed by 2011
Well presented, hands on course! The instructor was extremely knowledgable and helpful!! I have already reccommended this course to my managers.
Reviewed by 2011
The trainer I had was great. She had a great personality that kept me interested. Awesome Job! Thank you
Reviewed by 2011
The course was excellent and the instructor did a great job but why does everybody cut the time short. I think we should take a shorter lunch and get more class time instead of leaving a half of an hour early!
Reviewed by 2011
EXCELLENT instructor!!! Very patient ... customized the class to the needs of the students!
Reviewed by 2011
The only improvement I can suggest is focusing a bit more on the basics of Visio - more on Org & flow charts as opposed to so much time spent on designing rooms.
Reviewed by 2011
George was personable and easy to follow and work with.
Reviewed by 2011
Sue is an awesome instructor!
Reviewed by 2011
The instructor was excellent. It was evident that several of us who were competent with Excel 2003 Level 1 should have probably taken Excel 2007 Level 1 again rather than Excel 2007 Level 2, but the instructor was very patient and managed to cover basics from Level I as well as Level 2.
Reviewed by 2011
With myself being very green with this program I got very useful information that I can use daily.
Reviewed by 2011
One more hour would allow for more hands-on training.
Reviewed by 2011
Good course. Friendly instructor. I found the speed of the course to be a little slow for me, however I understand that other attendees required more help/detail than I did. Overall, a good experience.
Reviewed by 2011

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates.

 

This page has been viewed 233 times.