Microsoft Office Courses
Web/Graphic Design Courses
Microsoft Certification
Cisco Certification
CompTIA
Linux Certification
Testing Tool courses
Database Courses
Programming courses
MYOB
Engineering / AutoCAD
Networking / VoIP Courses
Security Courses
VMWare Course
Project Management Courses
Microsoft Access 2007 Level 1
Duration:  8 Hours
Price:  $399 AUD

Description:
The skills and knowledge covered in this publication are sufficient to create robust relational database systems in Microsoft Access, enter, edit and delete data in database files, produce information in forms and reports, and generate queries on the data.

Outcomes:

At the completion of this courseware participants will be able to:

  • start and exit Access and understand how Access works
  • understand some elementary database theory.
  • design relational databases
  • create relational databases
  • set table relationships in a database
  • add records to a relational database
  • import data into an Access table from a variety of sources
  • work with records in a relational database
  • create simple queries using more than one table
  • create select queries for a relational database
  • create forms using the Form Wizard
  • create reports using the Report Wizard
  • access the computer's help system and safely work with a computer.
Course Content
  1. Access 2007 Orientation
  2. Database Theory
  3. Database Design
  4. Creating Relational Databases
  5. Setting Table Relationships
  6. Adding Relational Records
  7. Importing Records
  8. Working With Records
  9. Relational Queries
  10. Relational Select Queries
  11. Creating Forms
  12. Creating Reports
  13. General Computer Usage
ENROLL