Entering data into a database - DB01

General Description

Database applications are used in all manner of workplaces. Become proficient in using a database efficiently to enter, edit and select data.

Target Audience

This session is intended for participants with little or no knowledge of Microsoft Access.

Pre-requisites

Participants should have a basic understanding of using a computer including working with Windows, using a mouse, accessing the menus and file management.

Duration

3 hours

Learning Outcomes

• Define the elements of a database system
• Describe how Access databases work
• Work with menus and toolbars
• Locate and open database files
• Open and close a database
• Navigate around a table
• Sort a table
• Locate specific data
• Format a table
• Adjust the width and height of columns and rows
• Select data
• Change the grid lines
• Hide and freeze columns
• Change fonts
• Move columns
• Update records
• Delete records