Exploring Microsoft Office

Computing

Quiz 3 :

Access: Presentation Design

Quiz 3 :

Access: Presentation Design

Question Type
search
arrow
Which of the following statements is true in reference to calculated fields:
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
A(n) ________ is a variable or constant that is needed to produce output for a function in a calculated field.
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
Constants that are used as arguments in expressions can be defined as ________.
Free
Multiple Choice
Answer:

Answer:

C

Tags
Choose question tag
close menu
arrow
Syntax can most accurately be defined as the ________.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following statements is true about date formatting?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Access contains ________ that perform routine calculations.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Sum, Avg, and Max are examples of ________ functions that are used to evaluate entire columns of data.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Aggregate functions are most commonly used in all of the following Access objects EXCEPT:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
When designing a calculated field, complex formulas can be created with the ________.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In addition to verifying the accuracy of a calculated field using a calculator, you can also use a(n) ________ to verify results
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
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.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
All of the following are arguments of the built-in PMT function EXCEPT:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The ________ function measures the amount of time that has elapsed between two dates.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The first two arguments of the DatePart function are ________ which describes the part of the date that will be returned; and ________ which tells Access where to locate the date / time information.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Rich is working on a database that stores a list of vendors and price quotes for a remodeling project. If Rich wanted to create a query to find the least expensive price quote, he should use the ________ function on the column containing the price quotes.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Following the rules for the order of operations, what is the result of the following expression: (9 * 5) + 5 + 10 - 10 * 6
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The ________ function isolates a specific portion of a date, such as the day, month, or year, in a date field.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Expression Builder inserts ________ that tell you where each argument belongs.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Jenna is working on a database that stores a company's invoices. The database includes a Table called Invoices, which has a column called outBalances that shows all outstanding balances. Jenna's boss has asked her to design a query that calculates the numerical mean of all outstanding balances. Which function should Jenna use on the outBalances column to help her complete this task?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The built-in IIf Function evaluates a condition and displays ________.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 96