Page 50 - Computer - 8

Post-Processing   


 A database is a collection of processed information related to a particular topic or purpose so
that it can be easily accessed, managed, and updated.
 DBMS is a software that enables the user to create a database and add, modify, and delete data
in it.

 Access 2019 is a Relational Database Management System (RDBMS).
 Databases in Access are composed of six objects – tables, forms, queries, reports, macros, and
modules.
 A Field stores a single value for an entity, while a Record contains data about one instance of an
entity.

 A table can be created in Access using the Datasheet View or the Design View.
 The Design view allows you to design the structure of a table, add fields to a table, specify the
data types, add descriptions, and set properties for the fields.
 A Primary Key is a field or set of fields with values that are unique throughout a table and is
used to identify records in a table.

INFO RETENTION
INFO RETENTION

A. Select the correct option for each of the following statements.
1. A database object that organises data in form of rows and columns is ______.
(a) Table (b) Query (c) Form (d) Module

2. A view that allows you enter data in a table is ______.
(a) Datasheet view (b) Design view (c) Layout view (d) Entry View

3. The data type that increments automatically when a new record is added to the table is ______.
(a) Decimal (b) Calculated (c) Number (d) AutoNumber

4. The ______ in Access main window displays a list of all the objects in the database.

(a) Ribbon (b) Status Bar (c) Work Area (d) Navigation Pane
5. The field property that specifies the maximum size for data stored in a field is ______.
(a) Input Mask (b) Field Size (c) Validation Rule (d) Format

6. A field or set of fields with values that are unique throughout a table is called ______.

(a) Data Key (b) Row Key (c) Column key (d) Primary Key
7. The field property that specifies an alternative or more descriptive name for the field is ______.

(a) Validation Rule (b) Caption (c) Format (d) Input Mask

48