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

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

Answer 2

relationship

Question 3

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

Answer 3

Columnar

Question 4

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 5

To delete a label and data field from a form, right-click the label, then click ____________________ on the shortcut menu.

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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 19

The options on the Report Design Tools tabs are not to be used to modify a report.

Question 20

You are limited to one grouping level per report.

Question 21

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 data that appears on your screen currently
D)none of the above

Question 22

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 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

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 25

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 26

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 27

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 28

To delete a label and data field from the form, right-click the label, then click ____ on the shortcut menu.

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

Question 29

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 30

Referring to the figure above, to add the date or time to the report header, you will 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 31

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 32

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 33

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 34

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 35

The Report Wizard simplifies the process of creating a ____.

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

Question 36

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 37

Referring to the figure above, ____ a report to open it.

A)right-click
B)left-click
C)double-click
D)highlight

Question 38

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 39

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 40

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 41

Referring to the figure above, to access the Report Wizard you would need to click on the ____ tab.

A)Home
B)Create
C)External Data
D)Database Tools

Question 42

Click inside a field to ____ data.

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

Question 43

Use ____ to preview the report as a Web page.

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

Question 44

When designing your own on-screen form, click the ____ tab.

A)Create
B)Home
C)External Data
D)Database tools

Question 45

To create a report, first click the ____ tab.

A)Home
B)Create
C)External Data
D)Database Tools

Question 46

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

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

Question 47

Referring to the figure above, in order to print the Products Query report, you will 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 48

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 49

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

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

Question 50

____ a report to open it.

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

Question 51

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 52

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 53

Open the report you want to convert to a Web page, then click the ____ Data tab.

A)Export
B)Import
C)External
D)Internal

Question 54

When working with a report, add ____.

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

Question 55

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 56

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 57

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 58

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 59

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

A)Home
B)Database Tools
C)External Data
D)Relationship Tools Design

Question 60

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 61

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

Question 62

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)Database Tools

Question 63

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

Question 64

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

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

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

Question 67

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

Question 68

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

Question 69

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)will stay updated automatically
C)change the way it is displayed
D)none of the above

Question 70

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 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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