MS Office Access 2003: Level 2

Eligible

La Trobe staff, postgraduate & undergraduate students.

Description

As you begin this course, you should have the basic skills you need to work with an Access database. This includes working with Access tables, relationships, queries, forms, and reports. Thus far, you have been focusing on essential database user skills only. In this course, you will consider how to design and create a new Access database, how to Customise database components, and how to share Access data with other applications. Access 2003: Level 2 is designed for the student who wishes to learn intermediate-level operations of the Microsoft Access Database program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft Word or Excel. It is also designed for students pursuing the Microsoft MOUS Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.

Objectives

In this course, you will design and create a new Access database; improve queries, forms, and reports; and integrate Access with other applications.

Topics

Course introduction
Planning a database
Building the structure of a database
Controlling data entry
Finding and joining data
Creating flexible queries
Improving your forms
Customising your reports
Expanding the reach of your data
Course follow up

Duration

The estimated time of completion is 5 hours and 13 minutes.

Element K catalog menu

Office Productivity - End-user Databases.

Costs

Staff - Free
Postgraduates - $50
Undergraduates - $50