Microsoft Access 2007 Course

• Create a database
• Create a database from a template, from scratch and from a blank database
• Database properties
• Rename a database file.
• Design a table
• Fields and fields data type
• Primary key
• Creating relationships
• Integrity Rules
• One-to-Many relationship. One-to-One relationship and Many-to-Many relationship
• Using input masks
• Validating inputs
• Create a preset list
• Create a query from Wizard
• Running a query
• Query sorting
• Setting criteria in a query
• Design forms
• Forms layout
• Finding Records
• Create a form to navigate and add new record
• Create and run a report
• Create a switchboard
• Create data access web pages

Date: Friday 1 October 2010

Cost: $330 (Australian dollars) including morning tea, lunch, afternoon tea, notes and lots of hands on exercises

Time: 9 am - 5pm

Place: 600 Collins Street or at a place close to the Monash freeway about 25 minutes drive from Melbourne city in Australia

Enquiries or Enrolment:

Email: melbourne@expert.com.hk

We also offer on-site training courses at your place anywhere in Australia, email to us for details: melbourne@expert.com.hk