DATABASE MANAGEMENT III

INPUT DATA

After the field names and their data types have been specified, then records are stored in the database by specifying the appropriate input. In MS Access, to input a 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 data.

To keep 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 Menu, click Options
• Click the Edit/Find tab
• Under Default find/replace behave, do one of the following:
• Select Fast Search to search the current field and match the whole field.
• Select General search to search all fields and match any part of the field.
• Select Start of Field Search to search the current field and match the beginning characters of field.
• DBMS have certain command for saving a database. For example in MS Access, select the save option on the MS Access window to save.

 

Sorting

To sort records in form view or in datasheet view, follow these steps:

1. Start MS Access, and then open the database that you are working with.
2. Open the table or the form whose data you want to view.
3. Click the field that you want to use for sorting records. To sort records in sub-form, click the field that you want to sort. To sort records in a sub-datasheet, display the sub-datasheet by clicking expand indicator, and then click the field that you want to sort.
4. On the records menu, point to sort, and then click Sort Ascending or Sort Descending. NOTE: In a form, you can only sort on only one field at a time.

Sorting with sub-datasheet

In datasheet view, when you sort the sub-datasheet for one record, MS Access sorts all the sub-datasheets at that level. In a datasheet or sub-datasheet, you can select two or more adjacent columns at the same time, and then sort them. Access sorts records starting with the leftmost selected column. When you save the form or datasheet, Access saves the sort order.

Sorting Records on a Report

1. Start MS Access, and then open the database that you are working with.
2. Open the report in Design View.
3. ON the View menu, click sorting and Grouping to display the sorting and Grouping dialog box.
4. In the first row of the Field/Expression column, select a field name or type an expression. NOTE: When you fill in the Field/Expression column, MS Access sets the sort order to Ascending.
5. You can sort up to10 fields or expression in a report. To sort your report on more than one field, add another field or expression to the Field/Expression column. The field or expression in the first row is the first sorting level. The second row is the second sorting level, and so on.

 

Modifying Data

How to Add or edit Data in a Datasheet (Table or Query) or in a Form

1. Open a table or a query in datasheet View or a form in Form View.
2. Do one of the following:

• In MS Office Access 2003 or in earlier versions of Access, to add a new record, point to Go to on the Edit menu, and then click New Record. Type the data, and then press TAB to go to the next field. At the end of the record, press TAB to go to the next record.
• In MS Office Access 2007, to add a new record, click the Home tab, and then click New in the Records group.
• To edit data within a field, click in the field that you want to edit, and then type the data.
• To replace the entire value, move the mouse pointer to the leftmost part of the field until the pointer changes into the plus pointer, and then click. Type the data.

NOTE: To correct a typing mistake, press BACKSPACE. To cancel your changes both in current field and in the entire record, press ESC.

 

GENERAL EVALUATION

1. State the operations that can be performed in a database.
2. List five (5) data type.
3. List the steps in modifying data.
4. Define the basic operations in Database.
5. How to you enter data in Ms-Access?

WEEKEND ASSIGNMENT

1. All these are basic operations except ___ A. modifying B. creating C. sorting
2. Searching
3. One of these explains sorting. A. arrangement of record alphabetically. B. data arrangement in ascending or descending order. C. data Movement D. Record Movement from one place to another.
4. In MS Office Access 2007, to add a new record you do ___ A. click the Home tab
5. open programs C. A and B D. none
6. The data accepted by these fields are either Yes/No or True/False is ___ A. primary key B. Boolean fields C. Data D. None
7. Another name for unique identifier is known as ___ A. Key B. Data C. Field
8. Record.

 

THEORY

1. Highlight how to sort data in Ms-Access.
2. List the four basic operations in Database.

 

See also

DATABASE MANAGEMENT II

DATABASE MANAGEMENT I

Microsoft Excel: Loading, Creating, Entering Data & Saving

Spreadsheet: Examples, Microsoft Excel & Formulas in MS Excel

SPREADSHEET: MEANING, USES AND CONTENTS