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