Page 304 - IT 402 v2.0 class 10
P. 304
Step 14: lick on the radio button of reate report now option.
Step 15: lick on the Finish button to generate the report.
Step 16: o take a hard copy of the report click on the printer icon from the Standard oolbar.
Inserting Date and Time
fter creating the report we can add different types of fields
from the Insert menu in the report. et us add date and time
in the report. Perform the following steps to add date and
time in a report:
Step 1: Open a report in esign Mode.
Step 2: Place the cursor at the place where we want to add
the date and time.
Step 3: Click on the Insert menu from the menu bar.
Step 4: Hover the mouse pointer on the Fields option.
Step 5: Select the ate or ime option. urrent date or time
will be inserted on the report.
Recap Zone
database is defined as an organised collection of data that can be visualised as a container of
information. The data is processed and interpreted to the real aspects to support processes that
require this information.
A database management system is a software package that controls the creation, maintenance and
use of a database.
Database servers are dedicated computers that can hold the actual databases. It can run only the
MS and its related software.
Data integrity implies validation of data. The database management system ensures that only valid
data can be entered into the database.
A table is a collection of logically related records. The multiple records of a database are arranged
together in a tabular structure to make a table.
A call or a request to generate some information from the tables is called query. It is the basic tool
for retrieving information from the database.
rimary key is a field which is used to uni uely identify records in a database. It is a uni ue field and
it cannot be left blank.
i ards are the predefined format which already exist in the package. his option provides the
facility that enables the user to select a category re uired fields from predefined tables and to set
type, formats and primary key and create a table.
Sorting means to arrange the data of a table in a particular order like in ascending or descending order.
here are two options for sorting records of a table: Sort scending and Sort escending .
Field level data validation ensures that the data entered in a particular field is correct and valid.
Forms enable to provide a user interface for entering of data or to display intermediary information.
In the Form, the user can add or modify data.
302 Touchpad Information Technology-X

