Page 318 - Trackpad 402_Class-X_Final
P. 318
REVISIT
▶ Data is a collection of values in the form of text, numbers, date, images, audio, video, etc.
▶ OpenOffice base is an open source RDBMS.
▶ RDBMS is the next advanced form of Database Management System and is based on a Relational Model.
▶ A wizard is a step-by step-process of doing a specific task through a set of dialog boxes.
▶ Field properties provide extra functionality to the fields created in a table.
▶ Table is a collection of related data stored in the form of rows and columns. It contains information about one
type of item.
▶ Query is a set of commands that generates a request to access or manipulate data in a table.
▶ Form is a database Object which is used to create an interactive user interface by connecting it with a table.
▶ Report is the formatted data displayed from one or more tables or queries.
▶ Sorting means rearrangement of the data either in the ascending order (smaller value to bigger value) or in
the descending order (bigger value to smaller value).
▶ Relationships help you join two or more tables using a common field so that common data can be retrieved
from multiple tables at the same time.
Sneak Peek MS Office
I To Create a Database in Microsoft Access:
1. Click on Blank database icon and enter a name for the database.
2. Click on Browse to search and select a location for storing the database.
3. Click on Create button.
318 Trackpad Information Technology-X

