1 |
Which key is used to move form field to field in Table window of Datasheet view? |
Tab
Esc
Enter
Spacebar
|
2 |
Which button of Find an Replace dialog box is clicked to start the search process? |
Find
Find Next
Search
Next
|
3 |
Which criteria can be used to find four-character name that starts with H? |
H*4
H?4
H???
H####
|
4 |
How many table views are available in Microsoft Access? |
4
3
2
1
|
5 |
Which rule states that a record form a table cannot be deleted if its associated record exists in related table? |
Referential integrity
Entity relationship
Normalization
All
|
6 |
In a relational database, a single piece of information is called: |
Table
Record
Entity
Attribute
|
7 |
How many types of relationship can be used? |
2
3
4
5
|
8 |
The data in tables is entered in: |
Design view
Normal view
Datasheet view
Layout view
|
9 |
Which of the following is the correct association? |
File = column
Record = row
Field = row
Record = table
|
10 |
A collection of data that consists of name, address and email of a person is called: |
Byte
Record
Character
Field
|
11 |
The smallest meaningful unit of data in a database is called: |
Byte
Record
Character
Field
|
12 |
Each set of related items in a table is called: |
Table
Record
Field
Query
|
13 |
Each separate piece of information stored in a record is called: |
Table
Record
Field
Query
|
14 |
A report may be based on a : |
Table
Query
Both a and b
None
|
15 |
An example of a query is: |
Selection of all records that match a set of criteria.
Importing of a spreadsheet file into the database
Search for a specific record
Both a and c are correct
|
16 |
The maximum numbers of tables in a database can be: |
1
2
3
Any
|
17 |
The columns of a table correspond to: |
Table
Record
Field
Cell
|