skip to navigation skip to content
Self-taught course

Provided by: University Computing Service


Booking

This course is self taught.

Bookings cannot be made on this course (Course is not taking bookings).



Booking / availability

Access 2007: Level 1 (Win) (workbooks)


Description

The skills and knowledge acquired in Microsoft Access 2007 Level 1 are sufficient to create robust relational database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data. Microsoft Access 2007 Level 1 is designed for people who need to know how to create effective databases and to manipulate data to provide viable information.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

Prerequisites

Microsoft Access 2007 Level 1 assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Topics covered
  • Access 2007 Orientation
  • Designing A Lookup Database
  • Creating A Lookup Database
  • Modifying Table Structures
  • Adding Records To A Table
  • Adding Transactional Records
  • Working With Records
  • Sorting And Filtering
  • Creating Queries
  • Creating And Using Reports
  • Creating And Using Forms
Objectives
  • Understand how Access is used and how to navigate around it
  • Design a database with lookup tables
  • Create a database structure using Access 2007
  • Modify the structure of an existing table
  • Add records to a new table
  • Add transactional records to a lookup database
  • Work with the records in a database table
  • Sort and filter records in a table
  • Create simple and effective queries
  • Create meaningful reports from tables
  • Create and use a variety of forms
Themes

Booking / availability

Override user: