‹ HOME   |   TIPS & TRICKS 705.728.5761   |   
   
CTC Computer Training
Excel 2010 Courses

Microsoft Access 2010 - Level 2

Students learn how to use data from other sources, and get more complete query and reporting capability from their databases.

  • Importing data
  • Attaching external data
  • Custom data entry forms
    - Creating calculated fields
    - Performing Date calculations
    - Formatting calculated fields
    - Changing Tab Order
    - Adding Drop-down list (combo box) controls (efficiently)
    - Adding List box controls
    - Adding Group box controls
  • Master Forms & Sub Forms
  • Action Queries
    - Update queries
    - Make-table Queries
    - Append Queries
    - Delete Queries
    - Parameter Queries
  • Importing data from Excel
  • Exporting data to Excel
  • Exporting data to Word
  • Relationships
    - One-to-One
    - One-to-Many
    - Many-to-Many
  • Custom reports
    - Sorting
    - Grouping
    - Adding calculated fields to detail bands
    - Adding Summary Information to a Group Footer
  • Database design principles
  • Compacting a database

Hot Tip: Be careful about having different version of Access in your office – once you convert a database to Access 2000, you cannot convert it back to an earlier version – or use it in an earlier version. This is just one of the many tips that you will learn in our 1-day Access computer training courses (onsite and classroom).

COURSES COST:
$175 per person (+ HST)
9am - 4pm (approx)
Access 2010 - Level 2 manual included
After-course email and telephone support included
Contact us for on-site Access 2010 training prices
Maximum 10 Students.