DATABASE MANAGEMENT III

DATA PROCESSING SSS1 THIRD TERM          

WEEK 10

DATABASE MANAGEMENT III

Contents

INPUT DATA

After the field names and their data types have been specified, the records are stored in the database by specifying the appropriate input. In MS Access, to input data:

• Double-click on the Student Table at the left-hand pane of MS Access windows
• Enter the data beneath the field names and click on the next cell to populate the data.

To keep the database updated, data inputted into the database must be saved regularly. Keyboard command CTRL + S is used. Alternatively, you click on the Office button and save.

BASIC OPERATION

The basic operations to be considered are:

• Searching
• Sorting
• Modifying
• Generate report

Searching

• On the Tools…