barrie ontario canadabarrie ontario canadabarrie ontario canadabarrie ontario canadacomputer training barriebarrie ontario canadabarrie ontario canadabarrie ontario canada


Microsoft Access 2003 - 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:
$165 per person (+ GST)
9am - 4pm (approx)
Manual Included
After-course email and telephone support included
Contact us for on-site training prices
Maximum 10 Students.

Please click here to view schedule

Please click here to view map

 


Training Courses
(onsite & offsite)
Windows XP / Outlook Combo
Converting to Office 2007 (NEW)
Word 2003 - Level I
Word 2003 - Level II
Word 2003 - Level III
Word 2003 - Level IV
Excel 2003 - Level I
Excel 2003 - Level II
Excel 2003 - Level III
Access 2003 - Level I
Access 2003 - Level II
Access 2003 - Level III
PowerPoint 2003 - Level I
PowerPoint 2003 - Level 2
Web Design - Level 1
Web Design - Level 2
FrontPage 2003
MS Project 2003- Level 1
MS Project 2003- Level 2