Deck 18: Finalizing a Database

Question 1

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

Answer 1

Tabular

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

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

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

Question 8

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 9

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

Question 10

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

Question 11

You are limited to one grouping level per report.

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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 21

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 22

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 23

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 24

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 25

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 26

The Report Wizard simplifies the process of creating a ____.

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

Question 27

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 28

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

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

Question 29

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 30

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 31

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 32

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 33

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 34

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 35

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 36

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 37

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 38

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

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

Question 39

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 40

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

A) Links
B) Relationships
C) Tools
D) Views

Question 41

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 42

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 43

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

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

Question 44

To create a report, first click the ____ tab.

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

Question 45

____ a report in the Navigation Pane to open it.

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

Question 46

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

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

Question 47

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

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

Question 48

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

A) Justified
B) Tabular
C) Datasheet
D) Columnar

Question 49

When exporting a report to an HTML Web page, click the ____ button to open the File Save dialog box.

A) Browse
B) Save
C) Create
D) OK

Question 50

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 51

Click inside a field to ____ data.

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

Question 52

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 53

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 54

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 55

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 56

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 57

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

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

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

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

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

Question 60

Use ____ to preview the report as a Web page.

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

Question 61

Case-Based Critical Thinking Questions Case 18-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 62

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

Question 63

Case-Based Critical Thinking Questions Case 18-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 64

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 65

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 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

Case-Based Critical Thinking Questions Case 18-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 75

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