ACG 103 - Test 2 Review Access (Ch. 3 & 4)

Displays fields horizontally

Which of the following statements is false?

A database object that is used to add data into or edit data in a table

An Access tool that helps you create more complicated expressions

Use this format to send a report to a user w/o MS Office

The simplest view you can use to modify control widths in a form is :

What is the cube root of 343?

False statement about Reports ......

Which of the following cannot be used in a calculated field?

Enables you to see exactly what the report will look like when it is printed

The object that a report is based on is known as the ___

Creating a calculation: which would be identified as an error

The input used to produce output for a function

A defined set of colors, fonts, and graphics that can be applied to a form or report

A method of summarizing data by the values of a field

Which statement about a totals query is true?

The object(s) that a report is based on is known as the:

Provides you with the most flexibility in modifying forms and reports

The location where you change settings such as number format & number of decimal places

A calculation performed on an entire column of data that returns a single value(i.e. AVG, SUM)

Can not be adjusted in the Property sheet

What is the result of the following expression? 2* 5 + 8 - 6 / 2

Which of the following can't be adjusted in the Property Sheet?

Which of the following can be added to a totals query?

Enables you to easily create mailing labels, name tags, and other special tags

Which of the following couldn't be done using an aggregate function?

Can not be done using an aggregate function

To summarize data in a report & override the sort order of the record source you use

False statement about the Total row in Query design .....

Which of the following statements is true?

Use this to summarize data in a report & override the sort order of the record source