Questions and Answers - All Access Chapter

Question 1

A ________ produces professional appearing formatted information derived from the information contained in tables or queries.

Answer 1

report.

Question 2

All the following statements are true regarding functions arguments except which one?
Select one:
a. An argument can be a constant.
b. An argument can be the value of a field.
c. An argument can be the value of a label.
d. An argument can be a variable.

Answer 2

An argument can be the value of a label..

Question 3

Which of the following is the correct mathematical sequence for the order of operations?
Select one:
a. Multiplication, Division, Exponentiation, Addition, Subtraction
b. Multiplication, Exponentiation, Division, Addition, Subtraction
c. Exponentiation, Multiplication, Division, Addition, Subtraction
d. Addition, Subtraction, Multiplication, Exponentiation, Division

Answer 3

Exponentiation, Multiplication, Division, Addition, Subtraction.

Question 4

It is more efficient to copy and use an existing query for a new query when
Select one:
a. the query criteria needed will be unique to the original query.
b. the query criteria needed will be similar to the original query.
c. the query will be deleted after it is run.
d. the query will be sorted alphabetically.

Answer 4

the query criteria needed will be similar to the original query..

Question 5

Data from two or more tables can be connected by specifying a
Select one:
a. field value.
b. common field. 
c. hyperlink.
d. form.

Answer 5

common field

Question 6

Database design begins with
Select one:
a. grouping the data in alphabetical order.
b. creating the correct queries.
c. grouping data into the correct tables.
d. creating the correct forms.

Answer 6

grouping data into the correct tables..

Question 7

Referential integrity should be enforced in a database with related tables because it
Select one:
a. makes the database easier to back up.
b. helps ensure data is automatically updated.
c. helps ensure invalid data is not entered into a table.
d. makes the database easier to repair.

Answer 7

helps ensure invalid data is not entered into a table..

Question 8

Following the rules for the order of operations, what is the result of the following expression:
(9 * 5) + 5 + 10 - 10 * 6
Select one:
a. 25
b. 540
c. 0 
d. 40

Answer 8

0

Question 9

Katie is working in a customer table and needs to know if any customers are located in Texas. In order to locate this information, she would create a
Select one:
a. report. 
b. query.
c. form.
d. new table.

Answer 9

Query

Question 10

en is working on a database that stores employee data. In the EmployeeData Table, there is a field that stores the number of years each employee has been with the company. Jen needs to design a query that shows all employees that have worked for company more than ten years. Which of the following query criteria should Jen use to locate information and display records of employees with the company more than ten years?
Select one:
a. =>10
b. #10#
c. 10
d. >10

Answer 10

> 10

Question 11

Joe is working in a database that stores client data. He needs to design a field that will assign a client ID number each time a user enters a new client. The data type he should apply to this field is
Select one:
a. Number.
b. Memo.
c. Text.
d. AutoNumber.

Answer 11

Autonumber

Question 12

In the table below, if you wanted to organize the data from the lowest Client ID to the highest Client ID, you would \_\_\_\_\_\_\_\_ the Client ID field.
Select one:
a. form
b. report
c. query
d. sort

Answer 12

Sort

Question 13

Aggregate functions are most commonly used in all of the following Access objects except which one?
Select one:
a. tables 
b. forms
c. macros
d. queries

Answer 13

Macros

Question 14

David is working in a database that organizes student exam grade information. He needs to find all students who have scored 100 on an exam. David can apply a(n) \_\_\_\_\_\_\_\_ to the data in order to show only records that meet the criteria.
Select one:
a. Sort
b. Filter 
c. Form
d. Report

Answer 14

Filter

Question 15

You can click the \_\_\_\_\_\_\_\_ button on the table toolbar to sort records in alphabetical order, from A to Z.
Select one:
a. order
b. ascending 
c. descending
d. form

Answer 15

Ascending

Question 16

The \_\_\_\_\_\_\_\_ organizes and lists the database objects in an Access database.
Select one:
a. navigation pane 
b. form wizard
c. query tool
d. report wizard

Answer 16

Navigation Pane

Question 17

Jenny is working on a database that stores invoices. She needs to include the current day, month, and year, which will be derived from the computer system, on each new invoice. She should use the \_\_\_\_\_\_\_\_ function for this purpose.
Select one:
a. DateArithmetic
b. Date 
c. DateDiff
d. DatePart

Answer 17

Date

Question 18

A field, or a combination of fields, that has a unique value is a
Select one:
a. table/
b. foreign key/
c. field value/
d. primary key/ 
Feedback

Answer 18

Primary Key/

Question 19

Which of the following is true regarding the running of queries and the size of a database?
Select one:
a. The size of a database does not affect the speed at which queries run.
b. The queries in larger databases may take longer to run than queries in smaller databases.
c. Queries run slower in smaller databases numeric data.
d. Queries run at the same speed in large or small databases.

Answer 19

The queries in larger databases may take longer to run than queries in smaller databases..

Question 20

Two or more tables that contain duplicate data is an example of
Select one:
a. data redundancy.
b. one-to-many relationships. 
c. many-to-many relationships.
d. data backup.

Answer 20

data redundancy..