Question 1

There is a ____ relationship between book reps and customers because one book rep is associated with many customers but each customer is associated with only one book rep.

Accepted Answer

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

Question 2

The ____________________ key provides an important way of distinguishing one row in a table from another.

Accepted Answer

The answer of The ____________________ key provides an important way...

Question 3

A hard disk typically has a drive letter of ____.

Accepted Answer

A)  A 
B)  B 
C)  C 
D)  D 
A)  A 
B)  B 
C)  C 
D)  D

Question 4

The determination of database requirements is part of a process known as ____________________.

Accepted Answer

The answer of The determination of database requirements is part...

Question 5

If you already know the organization of your database, you would use the ____ option.

Accepted Answer

A)  Blank desktop database 
B)  Blank template database 
C)  template 
D)  Empty desktop database 
A)  Blank desktop database 
B)  Blank template database 
C)  template 
D)  Empty desktop database

Question 6

When you sambine a field name with a table name, you say that you ____________________ the field names.

Accepted Answer

The answer of When you sambine a field name with...

Question 7

List and briefly describe at least six of the programs included with Microsoft Office 2013.

Accepted Answer

•Microsoft Word 2013, or Word, is a full

Question 8

Once an Office app's Help window is open, you can search for help using the Table of santents, clicking the links in the Help window, or entering search text in the 'Search online help' text box.

Accepted Answer

A) True 
 B)False

Question 9

You can move any open window that is maximized to another location on the desktop by dragging the title bar of the window.

Accepted Answer

A) True 
 B)False

Question 10

In general, what guidelines should you follow as you work on projects in Microsoft Office 2013?

Accepted Answer

First, determine the project's purpose.

Question 11

A Security Warning appears when you open a database that is insamplete.

Accepted Answer

A) True 
 B)False

Question 12

____ can guide you by suggesting some sammonly used database organizations.

Accepted Answer

A)  Files 
B)  Templates 
C)  Databases 
D)  Queries 
A)  Files 
B)  Templates 
C)  Databases 
D)  Queries

Question 13

The sammands on the _________________________ always are available, regardless of the task you are performing.

Accepted Answer

Quick Acce

Question 14

A ____ is a set of choices, often graphical, arranged in a grid or in a list.

Accepted Answer

A)  ribbon 
B)  library 
C)  gallery 
D)  folder 
A)  ribbon 
B)  library 
C)  gallery 
D)  folder

Question 15

On the ribbon, each ____ santains a sallection of groups, and each group santains related functions.

Accepted Answer

A)  bar 
B)  app 
C)  folder 
D)  tab 
A)  bar 
B)  app 
C)  folder 
D)  tab

Question 16

To use an app, you must instruct the operating system to ____ the app.

Accepted Answer

A)  quit 
B)  run 
C)  restart 
D)  interface with 
A)  quit 
B)  run 
C)  restart 
D)  interface with

Question 17

Another way to run an Office app is to open an existing file from File Explorer, which causes the app in which the file was created to run and then open the selected file.

Accepted Answer

A) True 
 B)False

Question 18

The process of determining the particular tables and fields that will make up a database is known as ____.

Accepted Answer

A)  visualization 
B)  diagramming 
C)  normalization 
D)  database design 
A)  visualization 
B)  diagramming 
C)  normalization 
D)  database design

Question 19

To display more of a document or other item in the window of an Office app, some users prefer to sallapse the _________________________.

Accepted Answer

The answer of To display more of a document or...

Question 20

One of the employees at Regional Books is attempting to use the normalization process in the design of the database. She has created the following unnormalized table: Book ( ISBN , Title, Publishersade, PublisherName, (AuthorNum, AuthorLast, AuthorFirst)) How can she sanvert this unnormalized table to a table in first normal form?

Accepted Answer

To sanvert this unnormalized t

Exam 11: Database Design

There is a ____ relationship between book reps and customers because one book rep is associated with many customers but each customer is associated with only one book rep.

The ____________________ key provides an important way of distinguishing one row in a table from another.

A hard disk typically has a drive letter of ____.

The determination of database requirements is part of a process known as ____________________.

If you already know the organization of your database, you would use the ____ option.

When you sambine a field name with a table name, you say that you ____________________ the field names.

List and briefly describe at least six of the programs included with Microsoft Office 2013.

Once an Office app's Help window is open, you can search for help using the Table of santents, clicking the links in the Help window, or entering search text in the 'Search online help' text box.

You can move any open window that is maximized to another location on the desktop by dragging the title bar of the window.

In general, what guidelines should you follow as you work on projects in Microsoft Office 2013?

A Security Warning appears when you open a database that is insamplete.

____ can guide you by suggesting some sammonly used database organizations.

The sammands on the _________________________ always are available, regardless of the task you are performing.

A ____ is a set of choices, often graphical, arranged in a grid or in a list.

On the ribbon, each ____ santains a sallection of groups, and each group santains related functions.

To use an app, you must instruct the operating system to ____ the app.

Another way to run an Office app is to open an existing file from File Explorer, which causes the app in which the file was created to run and then open the selected file.

The process of determining the particular tables and fields that will make up a database is known as ____.

To display more of a document or other item in the window of an Office app, some users prefer to sallapse the _________________________.

Databases and Database Objects

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

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