Which of the following database object is created first before any other created?
- (A)Â Table
- (B)Â Form
- (C)Â Report
- (D)Â query
- (A)Â Table
This type of database contains multiple tables that are connected to produce combined output from all tables:
- (A)Â Bound
- (B)Â Linked
- (C)Â Relational
- (D)Â Joined
- (C)Â Relational
The ‘Filter by selection’ allows you to filter those records:
- (A)Â That match the selected field
- (B)Â That match the criteria specified
- (C)Â That meet any of several criteria specified
- (D)Â All of above
- (A)Â That match the selected field
The operation of checking input data against specified criteria is known as?
- (A)Â Data Verification
- (B) Data Validation
- (C)Â Cross Check
- (D)Â Data Control
- (B) Data Validation
Database access levels are specified so as to define who can access what in a database. It is identified through:
- (A)Â User ID
- (B)Â Password
- (C)Â Status
- (D)Â None
- (A)Â User ID
What it is called to present information in a particular order based on numeric or alphabetical value?
- (A)Â Sorting
- (B)Â Searching
- (C)Â Arranging
- (D)Â Cropping
- (A)Â Sorting
A collection of related records in database is known as a:
- (A)Â Table
- (B)Â Database
- (C)Â File
- (D)Â None
- (A)Â Table
A part of database that stores complete information about an entity such as employee, sales, orders etc:
- (A)Â File
- (B)Â Record
- (C)Â Field
- (D) Query
- (B)Â Record
To create this, you enter an expression in the design grid that instructs Access to perform a calculation using the current field values:
- (A)Â Formulated field
- (B)Â Numeric field
- (C)Â Formula field
- (D)Â Calculated field
- (D)Â Calculated field
The ascending order of data hierarchy is?
- (A) Bit Byte Field – Record – File – Database
- (B) Bit Byte Record – Field – File Database
- (C)Â Byte Bit Field – Record – File – Database
- (D) Bit Byte Field – Record – Database – File
- (A) Bit Byte Field – Record – File – Database