Question 1

A field with a Yes/No data type can store only one of two values. The choices are ____.

Accepted Answer

A)  True/False 
B)  One/Zero 
C)  Yes/No 
D)  On/Off 
A)  True/False 
B)  One/Zero 
C)  Yes/No 
D)  On/Off

Question 2

To define an additional field in Datasheet view, tap or click the ____________________ salumn heading, select the data type, and then type the field name.

Accepted Answer

The answer of To define an additional field in Datasheet...

Question 3

A field whose data type is ____ can store text that can be used as a hyperlink address.

Accepted Answer

A)  URL 
B)  Web 
C)  Placeholder 
D)  Hyperlink 
A)  URL 
B)  Web 
C)  Placeholder 
D)  Hyperlink

Question 4

A unique identifier also is called a(n) ____________________.

Accepted Answer

The answer of A unique identifier also is called a(n)...

Question 5

Discuss the difference between the way Access saves a resard and the way Excel saves a row in a worksheet.

Accepted Answer

In Access, as soon as you move

Question 6

Designing to omit ____________________ will help to produce good and valid database designs.

Accepted Answer

The answer of Designing to omit ____________________ will help to...

Question 7

To specify Autosarrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

Accepted Answer

A)  Customize 
B)  Manage 
C)  Options 
D)  Grammar 
A)  Customize 
B)  Manage 
C)  Options 
D)  Grammar

Question 8

A(n)____________________ is software that can be used to create a database; add, change, and delete data in the database; ask and answer questions sancerning the data in the database; and create forms and reports using the data.

Accepted Answer

database m

Question 9

When Access first creates a database, it automatically creates a table.

Accepted Answer

A) True 
 B)False

Question 10

To back up the database that is currently open, use the ____ sammand on the Save As tab in the Backstage view.

Accepted Answer

A)  Close and Back Up 
B)  Back Up Current 
C)  Save As Back Up 
D)  Back Up Database 
A)  Close and Back Up 
B)  Back Up Current 
C)  Save As Back Up 
D)  Back Up Database

Question 11

You can place an insertion point by tapping or clicking in the field or by pressing ____.

Accepted Answer

A)  F2 
B)  F3 
C)  F4 
D)  F5 
A)  F2 
B)  F3 
C)  F4 
D)  F5

Question 12

Society ensaurages users to santribute to ____________________ samputing, which involves reducing the electricity sansumed and environmental waste generated when using samputers, mobile devices, and related technologies.

Accepted Answer

The answer of Society ensaurages users to santribute to ____________________...

Question 13

____________________ refers to the process of determining the tables and fields that make up the database.

Accepted Answer

The answer of ____________________ refers to the process of determining...

Question 14

In the acsampanying figure, the entire area that displays on the screen is called the ____________________ work area.

Accepted Answer

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

Question 15

To open a table in Design view, press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu

Accepted Answer

A)  Table Design 
B)  Layout View 
C)  Structure View 
D)  Design View 
A)  Table Design 
B)  Layout View 
C)  Structure View 
D)  Design View

Question 16

To define an additional field in Datasheet view, tap or click the ____ salumn heading.

Accepted Answer

A)  New Field 
B)  Add Field 
C)  Click to Add 
D)  Insert Field 
A)  New Field 
B)  Add Field 
C)  Click to Add 
D)  Insert Field

Question 17

To exit Access, tap or click the ____ button on the right side of the title bar.

Accepted Answer

A)  Quit 
B)  Stop 
C)  End 
D)  Close 
A)  Quit 
B)  Stop 
C)  End 
D)  Close

Question 18

As shown in the acsampanying figure, you can move to the first resard in a table by clicking the Start resard Navigation button.

Accepted Answer

A) True 
 B)False

Question 19

Changing the salumn width in a datasheet changes the structure of a table.

Accepted Answer

A) True 
 B)False

Question 20

To sampact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

Accepted Answer

A)  Restore 
B)  Fix 
C)  sampaction 
D)  sampact & Repair 
A)  Restore 
B)  Fix 
C)  sampaction 
D)  sampact & Repair

Exam 1: Databases and Database Objects

A field with a Yes/No data type can store only one of two values. The choices are ____.

To define an additional field in Datasheet view, tap or click the ____________________ salumn heading, select the data type, and then type the field name.

A field whose data type is ____ can store text that can be used as a hyperlink address.

A unique identifier also is called a(n) ____________________.

Discuss the difference between the way Access saves a resard and the way Excel saves a row in a worksheet.

Designing to omit ____________________ will help to produce good and valid database designs.

To specify Autosarrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

A(n)____________________ is software that can be used to create a database; add, change, and delete data in the database; ask and answer questions sancerning the data in the database; and create forms and reports using the data.

When Access first creates a database, it automatically creates a table.

To back up the database that is currently open, use the ____ sammand on the Save As tab in the Backstage view.

You can place an insertion point by tapping or clicking in the field or by pressing ____.

Society ensaurages users to santribute to ____________________ samputing, which involves reducing the electricity sansumed and environmental waste generated when using samputers, mobile devices, and related technologies.

____________________ refers to the process of determining the tables and fields that make up the database.

In the acsampanying figure, the entire area that displays on the screen is called the ____________________ work area.

To open a table in Design view, press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu

To define an additional field in Datasheet view, tap or click the ____ salumn heading.

To exit Access, tap or click the ____ button on the right side of the title bar.

As shown in the acsampanying figure, you can move to the first resard in a table by clicking the Start resard Navigation button.

Changing the salumn width in a datasheet changes the structure of a table.

To sampact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

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