Deck 2: Access Lesson 2: Creating Queries, Forms, and Reports

Question 1

To run a query at any time, double-click it in the ____.

A) Access program window
B) Navigation Pane
C) Home tab of the Ribbon
D) record source

Answer 1

B

Question 2

To save a form, click the Save button on the Navigation Pane .

Answer 2

False

Question 3

The Report button guides you through the process of creating a report.

Answer 3

False

Question 4

A select query ____.

A) retrieves specific data out of a record source for you to use
B) guides you through the process of creating a query
C) gives instructions to display the records and fields you asked to see
D) displays query results in Design view

Question 5

A filter is a set of predesigned formatting elements that can be applied to quickly give your forms a professional and consistent look.

Question 6

To be guided through the process of creating a query, click the Simple Query button.

Question 7

When you save a query, you are saving the query results.

Question 8

Because a database is continually being updated, if you want to see the query results with the latest data, you must run the query.

Question 9

Reports can be printed from any view or even while closed.

Question 10

Forms are powerful tools that can extract data from one or more tables.

Question 11

To make changes to a report, switch to Report view.

Question 12

You can sort data in Form view of a form, in Layout view of a report, or in Datasheet view of a query or table.

Question 13

A pencil icon is displayed in the upper-left corner of the form when a record is being edited.

Question 14

If you create a query using the Query Wizard, it is automatically ____ when you complete the wizard.

A) saved
B) closed
C) displayed in Print Preview
D) displayed in Design view

Question 15

To sort text from Z to A, numbers from 9 to 0, or dates from latest to earliest, click the Descending button in the Sort & Filter group.

Question 16

Which of the following can be used as a record source?

A) Filter
B) Form
C) Table
D) Report

Question 17

You can delete a form by right-clicking it in the Navigation Pane and clicking Delete on the shortcut menu.

Question 18

AutoFilter options are specific to the type of data in that field.

Question 19

You can use the Form tool to create a simple form that includes all the fields from the selected record source.

Question 20

You can start the Query Wizard by clicking the Query Wizard button in the ____ group on the Create tab.

A) Design
B) Wizard
C) Select
D) Queries

Question 21

To remove a filter, click the ____ button in the Sort & Filter group.

A) Clear All Filters
B) Toggle Filter
C) Delete Filter
D) Undo

Question 22

A simple report created using the Report button includes ____.

A) the same title as the title of the records source
B) every field from the record source
C) the date and time the report was created
D) all of the above

Question 23

Case AC 2-2 Rahim is the manager of a large apartment complex. Information about all of the apartments is stored in a database on the computer in the main office so he can access it easily. If Rahim wanted to know which apartment would be available on a specific date, he would create a ____.

A) table
B) query
C) form
D) report

Question 24

A selected field on a form is indicated by a(n) ____ border.

A) green
B) blue
C) orange
D) black

Question 25

After you have created a form, you can modify it using ____.

A) Form view
B) Form view or Design view
C) Layout view or Design view
D) Form view, Layout view, or Design view

Question 26

Which view allows you to make design changes to a form while it is displaying data?

A) Form
B) Layout
C) Datasheet
D) Design

Question 27

When generated from a query, a ____ can enable you to create mailing labels of clients from a specific ZIP code.

A) filter
B) table
C) form
D) report

Question 28

Case AC 2-1 Anita prepared a report containing information about new products now available from her company. Now she wants to modify it before she prints it. If Anita wants to use the Format and Arrange contextual tabs to modify her report, she should display it in which view?

A) Report
B) Print Preview
C) Layout
D) Design

Question 29

FIGURE AC 2-1 Which record is displayed on the simple form shown in Figure AC 2-1?

A) 1
B) 2
C) 8
D) can't tell from the figure

Question 30

Case AC 2-1 Anita prepared a report containing information about new products now available from her company. Now she wants to modify it before she prints it. If Anita accidentally deletes a field from the report, what can she do?

A) Click the Add Existing Fields button to reverse the action.
B) Click the Undo button to undo the deletion.
C) Close the report so the action is not saved.
D) Nothing, because the action is permanent.

Question 31

Which of the following actions can you perform on a report in the Print Preview window?

A) Add a field.
B) Apply a theme.
C) Zoom to display it differently.
D) Any of the above.

Question 32

To view the entire gallery of themes, click the ____ button in the Themes group on the Form Layout Tools Design tab.

A) Themes
B) Design
C) Gallery
D) Formatting

Question 33

If you want to select which fields are included on a form and also choose the form layout and style, then you can use ____.

A) the Form tool
B) the Form Wizard
C) Form view
D) none of the above

Question 34

To delete a report, right-click it in the ____ and click Delete on the shortcut menu.

A) Create tab of the Ribbon
B) record source
C) Navigation Pane
D) Quick Access Toolbar

Question 35

FIGURE AC 2-1 The newly created simple form shown in Figure AC 2-1 is displayed in ____ view?

A) Form
B) Layout
C) Design
D) Datasheet

Question 36

The commands to sort and filter data are located on the ____ tab in the Sort & Filter group.

A) Home
B) Create
C) Format
D) Arrange

Question 37

Case AC 2-2 Rahim is the manager of a large apartment complex. Information about all of the apartments is stored in a database on the computer in the main office so he can access it easily. To control what types of information can be viewed, changed, or entered by other people in the office, Rahim would create a ____.

A) table
B) query
C) form
D) report

Question 38

The navigation buttons located ____ can be used to move among records in a form.

A) on the Create tab of the Ribbon
B) in the Navigation Pane
C) at the bottom of the Access program window
D) on the Format contextual tab

Question 39

When you create a query, form, or report, it is based on an existing object in the database, called a(n) ____________________.

Question 40

To move a field, use the Move Up or Move Down buttons in the Move group on the Form Layout Tools ____ tab.

A) Design
B) Control
C) Arrange
D) Format

Question 42

To see how a report will look when printed, you can display it in the ____________________ window to make sure it looks the way you want.

Question 43

Using ____________________ view, you can view, enter, or edit data, but cannot change the layout or design of the form.

Question 44

When you ____________________ a query, you perform the query with the most recent data, and give instructions to display the records and fields in your original query design.

Question 45

What is the purpose of a filter? Give examples of when a filter would be useful. When would you want to use a filter to display certain records instead of a query? When might you need to use a type of filter other than an AutoFilter? Give an example.

Question 46

When you choose to sort in ____________________ order, text is sorted from A to Z, numbers are sorted from 0 to 9, and dates are sorted from earliest to latest.