DATABASE MANAGEMENT III : LSUS
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
Subscribe now to gain full access to this lesson note
Take Me ThereClick here to gain access to the full notes.