Business Services

Test your knowledge

Select the correct answer for each of the following

In a database, which of the following will allow data to be arranged in alphabetical order?
1. editing
2. formatting
3. proofing
4. sorting
The rows of a table correspond to
1. Fields
2. Records
3. Reports
4. Files
Which of the following is used to answer a question about a database?
1. Form
2. Module
3. Query
4. Table
A report may be based on a
1. Table
2. A query
3. Both a table and a query
4. Neither a table nor a query
What is a relational database?
1. A database that contains multiple tables that are related
2. A database that includes reports, queries, and forms
3. A single table that uses referential integrity
4. A type of database software
Every field in a table has
1. A field name and a data type
2. A field name and a field number
3. A field number and a data type
4. A field name, a field number, and a data type
In a table called Employees, which of the following fields would be the primary key?
1. EmployeeFirstName
2. EmployeeID
3. EmployeeDept
4. None of the above
How many primary keys can a table have?
1. One
2. At least one, but not more than two
3. Between one and five
4. No limit

Answer True or False for the following statements

	True	False
9. A primary key uniquely identifies a record.
10. A person’s last name is often used as a primary key since it guarantees a unique result.
11. The Datasheet view is used to add a new field to a table.
12. The Find command is the best way to search a table for a specific record.
13. Every table must have a primary key.
14.The Design view in Access is used to add, edit, or delete records.