COURSE LIST / MICROSOFT ACCESS 2003 - LEVEL 2
 

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 (+ HST)
9am - 4pm (approx)
Access manual included
After-course email and telephone support included
Contact us for on-site Access training prices
Maximum 10 Students.
 

↑ BACK TO TOP