Deck 11: Finalizing a Database

Question 1

Use a Web ____________________ to preview a report as a Web page.

Answer 1

browser

Question 2

Reports often include totals and subtotals as well as detailed information.

Answer 2

True

Question 3

The ____________________ layout places field labels at the top of a column, which makes it appear like a table.

Answer 3

Tabular

Question 4

If you want your on-screen form to resemble a printed form, select the Justified layout.

Question 5

Forms that you create need to be saved separately from the database file.

Question 6

In a(n) ____________________ database, tables can be related to each other and you can use that feature to make data management more efficient.

Question 7

As the data in your database changes, the Web page version of the report automatically updates.

Question 8

The options on the REPORT DESIGN TOOLS tabs are used to modify a report.

Question 9

The ____________________ form layout displays fields across the screen in rows, with a label above each field.

Question 10

Most of the time, you'll want to include a subset of the fields on a form.

Question 11

Design View provides maximum flexibility for designing a form, but requires more time on your part.

Question 12

To delete a label from a form, click the label, then press the ____________________ key on the keyboard.

Question 13

The ____________________ form layout places labels next to fields, and lists the fields in columns.

Question 14

In database terminology, a link between two tables is called a(n) ____________________.

Question 15

A(n) ____________________ allows you to view your data one record at a time, with the fields of each record arranged on your computer screen as they might be arranged on a printed form.

Question 16

Use the vertical and horizontal scroll bars to view parts of the report that are not initially visible.

Question 17

A database form allows you to view your data one record at a time.

Question 18

You can modify the design of any form by right-clicking the tab at the top of the form and selecting ____________________ View.

Question 19

When you want to create a polished printout of some or all of the data in your Access database, you can create a(n) ____________________.

Question 20

You are limited to one grouping level per report.

Question 21

The ____ helps you design an on-screen form in which you can enter and manipulate data for each record of a database.

A) Record Wizard
B) Form Wizard
C) Field Wizard
D) Database Wizard

Question 22

In a ____ relationship, a record in one table can be related to several records in another table and vice versa.

A) one-to-one
B) one-to-many
C) many-to-many
D) many-to-one

Question 23

You can organize your data into ____ using a table, which is the best way to view the data contained in a large number of records.

A) rows
B) columns
C) both a. and b.
D) neither a. nor b.

Question 24

Click the FILE tab, click Print, then click Print again to display the ____.

A) Table dialog box
B) Report dialog box
C) Print dialog box
D) Save As dialog box

Question 25

The report ____ is used to identify the report so that you can open it in the future.

A) number
B) name
C) primary key
D) database link

Question 26

To move a label and the associated ____, click to select the object, move the pointer over the edge of the object until the pointer changes to a 4-headed arrow shape, then drag the label and data field to a new location.

A) record field
B) data field
C) query field
D) tab field

Question 27

Click the ____ button to sort from Z to A or high to low.

A) ascending
B) descending
C) either a. or b.
D) neither a. nor b.

Question 28

You can use the Relationships group on the ____ tab to create, view, and modify relationships between the tables in a database.

A) DATABASE
B) DATABASE TOOLS
C) TABLES
D) DETAILS

Question 29

You can modify the design of any form by right-clicking the tab at the top of the form and selecting ____ View.

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

Question 30

In a ____ relationship, one record from a table is related to many records in another table, as when one order contains many items purchased by a customer.

A) one-to-one
B) one-to-many
C) many-to-many
D) many-to-one

Question 31

The Report Wizard simplifies the process of creating a ____.

A) worksheet
B) table
C) field
D) report

Question 32

Each time you display or print a report, the contents of the report are automatically updated to reflect ____.

A) the current data stored in the database
B) the data that was in the database when you last closed Access
C) the last five saved versions of the database
D) none of the above

Question 33

When you use a form to add or change the data in a record, you have to use the Refresh All button on the ____ tab to update the corresponding table.

A) DATABASE TOOLS
B) CREATE
C) HOME
D) FILE

Question 34

To sort records within a group, click the ____ button and select the field by which you want to sort.

A) down-arrow
B) up-arrow
C) right-arrow
D) left-arrow

Question 35

Forms allow you to customize the way Access displays records by ____.

A) selecting particular fields
B) specifying the field order
C) adding description field labels
D) all of the above

Question 36

To delete a label from a form, click the label, then press the ____ key on the keyboard.

A) Cut
B) Delete
C) Remove
D) Purge

Question 37

After you put your report on a Web page, you should periodically open the report and ____ it again as a Web page to keep the Web version up-to-date.

A) import
B) export
C) run
D) save

Question 38

Referring to the figure above, to group report data by a field, you would click a field, then click the ____ button.

A) >
B) <
C) Back
D) Next

Question 39

A ____ type of relationship is rare in the world of databases.

A) one-to-one
B) one-to-many
C) many-to-many
D) all of the above

Question 40

Click the ____ button to sort from A to Z or from low to high.

A) ascending
B) descending
C) either a. or b.
D) neither a. nor b.

Question 41

To access the Report Wizard, first click the ____ tab.

A) HOME
B) CREATE
C) EXTERNAL DATA
D) DATABASE TOOLS

Question 42

You can hold down the ____ key to select more than one field in a report.

A) Home
B) +
C) Shift
D) Alt

Question 43

You can use the Relationships group on the ____ tab to create, view, and modify relationships between the tables in a database.

A) HOME
B) FILE
C) DATABASE TOOLS
D) DESIGN

Question 44

____ a report in the Navigation Pane to open it.

A) Right-click
B) Left-click
C) Double-click
D) none of the above

Question 45

Use ____ to preview the report as a Web page.

A) a Web browser
B) Windows Explorer
C) a database application
D) presentation software

Question 46

In a ____ relationship, a record in one table can be related to several records in another table and vice versa.

A) many-to-many
B) one-to-many
C) one-to-one
D) many-to-one

Question 47

To convert a report to a Web page, open the report, then click the ____ DATA tab.

A) EXPORT
B) IMPORT
C) EXTERNAL
D) INERNAL

Question 48

In database terminology, a link between two tables is called a(n) ____.

A) active join
B) relationship
C) import
D) export

Question 49

Grouping helps arrange data when you want to produce a report containing ____.

A) totals
B) subtotals
C) column borders
D) row borders

Question 50

As with other Web pages, your report must be in ____ format to be accessible to Web browsers.

A) JavaScript
B) ActiveX
C) HTML
D) FTP

Question 51

To create a report, first click the ____ tab.

A) HOME
B) CREATE
C) EXTERNAL DATA
D) DATABASE TOOLS

Question 52

In a ____ relationship, one record from a table is related to many records in another table, as when one order contains many items purchased by a customer.

A) many-to-many
B) one-to-one
C) one-to-many
D) many-to-one

Question 53

Like a ____, a report can be based on criteria that determine which data is included in the report.

A) query
B) question
C) sort
D) parameter

Question 54

Create and modify relationships using controls found on the ____ tab.

A) HOME
B) DATABASE TOOLS
C) EXTERNAL DATA
D) RELATIONSHIP TOOLS DESIGN

Question 55

When working with a report, add ____.

A) no more than three fields
B) no more than five fields
C) no more than seven fields
D) as many fields as you would like

Question 56

To add the date or time to the report header, first right-click the report name in the Navigation Pane, then click ____ View on the shortcut menu.

A) Design
B) Table
C) Database
D) Print

Question 57

A ____ relationship means that a record in one table is related to only one record in another table. This type of relationship is rare in the world of databases.

A) many-to-many
B) one-to-one
C) many-to-one
D) one-to-many

Question 58

When using the Report Wizard, select the table that ____.

A) contains data to be merged with the report
B) contains relational links
C) contains data for the report
D) contains fields to place the printed data

Question 59

Click inside a field to ____ data.

A) enter
B) edit
C) either a. or b.
D) neither a. nor b.

Question 60

When designing your own on-screen form using the Form Wizard, first click the ____ tab.

A) CREATE
B) HOME
C) EXTERNAL DATA
D) DATABASE TOOLS

Question 61

The Datasheet form layout resembles a spreadsheet, with cells for entering data.

Question 62

When you click the Finish button in the Report Wizard, the report is displayed in a window.

Question 63

Access gives you the option of printing database reports. Please describe the types of information database reports often include.

Question 64

Case-Based Critical Thinking Questions Case 11-1 Darcy wants to publish some of her reports on the Internet so that other people on her team can easily access them. Please answer the questions below. Over time, as the data in the database changes, the Web version will ____.

A) become increasingly out of date
B) stay updated automatically
C) change the way it is displayed
D) none of the above

Question 65

Using the Report Wizard, the report layout is automatically saved in the table file along with the queries and forms that you have already created.

Question 66

Case-Based Critical Thinking Questions Case 11-1 Darcy wants to publish some of her reports on the Internet so that other people on her team can easily access them. Please answer the questions below. Darcy then previews the ____ version of the report in her browser to make sure the conversion was successful before posting it on the Web.

A) HTTP
B) HTML
C) Java
D) FTP

Question 67

In a(n) many-to-many relationship, a record in one table can be related to several records in another table and vice versa.

Question 68

The Columnar form layout places field labels at the top of a column, which makes it appear like a table.

Question 69

When you add a(n) grouping level, records are sorted according to entries in the group field.

Question 70

The Form Wizard includes a section on laying out your form. Please describe the four types of form layouts.

Question 71

Your report must be in HTTP format to be accessible to Web browsers.

Question 72

Case-Based Critical Thinking Questions Case 11-1 Darcy wants to publish some of her reports on the Internet so that other people on her team can easily access them. Please answer the questions below. To get started, Darcy opens the report she wants to convert to a Web page and then clicks the ____ tab.

A) HOME
B) CREATE
C) EXTERNAL DATA
D) DATBASE TOOLS

Question 73

Layout View provides maximum flexibility for designing a form, but requires more time on your part.

Question 74

Click the Open (blank) record button to add a new record.

Question 75

Select an object on the report, then use the drag bars to adjust their size.