Week 4: Advanced Comp. Applications - Adv. Report Techniques

A relational database is the collection of information that organizes data points with defined relationships for easy access.

• True

• False

To import a a file into a table you can right click on the table to see the import section.

• True

• False

Using_________ you can filter data with two or more tables.

• Report wizard

• Relational table

• Concatenate

A one-to-many relationship in a database defines that each record in Table A may have many linked records in Table B, however, each record in Table B may have only one corresponding record in Table A.

• True

• False

Concatenate is the operation of putting two text together such as first and last name.

• True

• False

_____ view is most useful when the changes you need to make are complex.

• Design

• Layout

• Print

The contents of the _____ section appear once at the beginning of the report.

• content

• report page

• report header

In Layout view of the report, you can specify both grouping and sorting by using the Group & Sort button on the _____ tab.

• Design

• Print

• Layout

The report title, column headers, contents of various fields, subtotals, and so on are all contained in _____.

• controls

• totals

• properties

Forms, like reports, have an ARRANGE tab that you can use to modify the form’s layout. However, the PAGE SETUP tab is not available for forms.

• True

• False