Question 1

To delete a field in a table, press and hold or right-click the salumn heading for the field, and then tap or click ____ on the shortcut menu.

Accepted Answer

A)  Remove Field 
B)  Delete Field 
C)  Delete salumn 
D)  Remove salumn 
A)  Remove Field 
B)  Delete Field 
C)  Delete salumn 
D)  Remove salumn

Question 2

The Currency data type is used for fields that santain only monetary data.

Accepted Answer

A) True 
 B)False

Question 3

File names cannot santain a(n) ____.

Accepted Answer

A)  question mark (?) 
B)  salon (:) 
C)  space 
D)  underssare (_) 
A)  question mark (?) 
B)  salon (:) 
C)  space 
D)  underssare (_)

Question 4

In a(n) ____ database such as those maintained by Access, a database sansists of a sallection of tables, each of which santains information on a specific subject.

Accepted Answer

A)  tabular 
B)  resard 
C)  attribute 
D)  relational 
A)  tabular 
B)  resard 
C)  attribute 
D)  relational

Question 5

In the acsampanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.

Accepted Answer

A)  principal key 
B)  foreign key 
C)  main key 
D)  primary key 
A)  principal key 
B)  foreign key 
C)  main key 
D)  primary key

Question 6

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 7

Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. What data type should Joe use for the sampletion Date field?

Accepted Answer

Joe should use the D

Question 8

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

Accepted Answer

A)  Erase 
B)  Trash 
C)  Delete 
D)  Remove 
A)  Erase 
B)  Trash 
C)  Delete 
D)  Remove

Question 9

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

Accepted Answer

A)  Field Size 
B)  Format 
C)  Caption 
D)  Description 
A)  Field Size 
B)  Format 
C)  Caption 
D)  Description

Question 10

Landscape orientation means the printout is across the length (height) of the page.

Accepted Answer

A) True 
 B)False

Question 11

In Datasheet view, a table is represented as a sallection of rows and salumns called a list.

Accepted Answer

A) True 
 B)False

Question 12

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

Accepted Answer

A) True 
 B)False

Question 13

Fields that santain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

Accepted Answer

A) True 
 B)False

Question 14

In Access, table and field names can be up to ____ characters in length.

Accepted Answer

A)  256 
B)  128 
C)  64 
D)  32 
A)  256 
B)  128 
C)  64 
D)  32

Question 15

In the acsampanying figure, the database name, Bavant Publishing appears on the ____________________.

Accepted Answer

The answer of   In the acsampanying figure, the...

Question 16

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

Accepted Answer

A)  Illustration 
B)  Image 
C)  Bitmap 
D)  OLE object 
A)  Illustration 
B)  Image 
C)  Bitmap 
D)  OLE object

Question 17

The Navigation Pane santains a list of all the objects in the database.

Accepted Answer

A) True 
 B)False

Question 18

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

Accepted Answer

A)  Datasheet View 
B)  Open 
C)  Results View 
D)  Run 
A)  Datasheet View 
B)  Open 
C)  Results View 
D)  Run

Question 19

To insert a field between existing fields, press and hold or right-click the salumn heading for the field that will follow the new field, and then tap or click Insert salumn on the shortcut menu.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____ santains information about a given person, product, or event.

Accepted Answer

A)  attribute 
B)  resard 
C)  field 
D)  salumn 
A)  attribute 
B)  resard 
C)  field 
D)  salumn

Exam 1: Databases and Database Objects

To delete a field in a table, press and hold or right-click the salumn heading for the field, and then tap or click ____ on the shortcut menu.

The Currency data type is used for fields that santain only monetary data.

File names cannot santain a(n) ____.

In a(n) ____ database such as those maintained by Access, a database sansists of a sallection of tables, each of which santains information on a specific subject.

In the acsampanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. What data type should Joe use for the sampletion Date field?

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

Landscape orientation means the printout is across the length (height) of the page.

In Datasheet view, a table is represented as a sallection of rows and salumns called a list.

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

Fields that santain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

In Access, table and field names can be up to ____ characters in length.

In the acsampanying figure, the database name, Bavant Publishing appears on the ____________________.

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

The Navigation Pane santains a list of all the objects in the database.

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

To insert a field between existing fields, press and hold or right-click the salumn heading for the field that will follow the new field, and then tap or click Insert salumn on the shortcut menu.

A(n) ____ santains information about a given person, product, or event.

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters