Deck 20: Database Forms and Reports

Question 1

To keep your database file a reasonable size, you should it on a regular basis, such as every time you exit Access.

Answer 1

compact

Question 2

A report can be created by choosing the "Create report by using wizard" option.

Answer 2

True

Question 3

An Access _ is a single file.

Answer 3

database

Question 4

One caution about using database _ is that the size of the database file can grow quickly.

Question 5

To view the form's design, choose View, and then choose Design.

Question 6

Information that is to be written only once at the top of the report is referred to as the:

A)page header.
B)page title.
C)header.
D)report header.

Question 7

How can you set Access to automatically compact the database when you exit the program?

Question 8

What are the types of objects in an Access database?

Question 9

What is contained in the header and footer sections of a report?

Question 10

Data rules in the definition of the data field itself are automatically enforced within a form.

Question 11

How can data entry be aided by the use of a form?

Question 12

The first step in creating a form using the wizard is to:

A)choose the form layout.
B)choose the fields.
C)change the name of the form.
D)choose the correct table.

Question 13

To enter a validation rule from the form's design view:

A)choose Edit, then choose Validation Rule.
B)choose View, then choose Properties.
C)right- click on the data field, then click Properties.
D)right- click on the field label, then click Properties.

Question 14

Records from different tables can be combined when a common value exists between the two tables.

Question 15

Users like to use features such as the command that can easily reverse mistakes.

Question 16

If you extend the width of the report in design view, then an extra page will be added to the report.

Question 17

What are the commands in Access to compact your database?

Question 18

Within Access, you can use the command to cut and paste objects.

Question 19

Which of the following is not a method of creating a form?

A)Double- clicking "Create form by entering data."
B)Double- clicking "Create form in design view."
C)Clicking the New button on the toolbar.
D)Double- clicking "Create form by using wizard."

Question 20

To return to the form after viewing the design:

A)choose Form, then choose View.
B)choose Form, then choose View Form.
C)choose View, then choose Form.
D)choose View, then choose Form View.