Access 2007: Level 1 (Win) (workbooks)

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.

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.

Number of sessions: 1

• 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

• 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

• Databases
• Self-Taught
• Statistical and Mathematical Software