Question 1

A ____ is the name assigned to a file when it is saved.

Accepted Answer

A)  password 
B)  user name 
C)  document ID 
D)  file name 
A)  password 
B)  user name 
C)  document ID 
D)  file name

Question 2

If there are two possibilities for a primary key, one field is chosen as the primary key and the other field is called a(n) ____________________ key.

Accepted Answer

The answer of If there are two possibilities for a...

Question 3

You work on objects such as tables, forms, and reports in the ____.

Accepted Answer

A)  Access work area 
B)  Navigation area 
C)  Object tabs area 
D)  Options area 
A)  Access work area 
B)  Navigation area 
C)  Object tabs area 
D)  Options area

Question 4

From the Windows 8 Start screen, you can choose which apps to run using a ____.

Accepted Answer

A)  touch screen 
B)  mouse 
C)  printer 
D)  storage device 
A)  touch screen 
B)  mouse 
C)  printer 
D)  storage device

Question 5

If you delete a file from removable media, it is stored in the Recycle Bin where you can resaver it until you empty the Recycle Bin.

Accepted Answer

A) True 
 B)False

Question 6

____ is(are) used in the shorthand representation of table.

Accepted Answer

A)  Underlining ____ 
B)  Slashes / / 
C)  Parentheses ( ) 
D)  Ampersands & 
A)  Underlining ____ 
B)  Slashes / / 
C)  Parentheses ( ) 
D)  Ampersands &

Question 7

Each Office app has its own Help home page.

Accepted Answer

A) True 
 B)False

Question 8

A(n) ____ interviews users, examines existing and proposed documents, investigates current procedures, and reviews organizational policies to determine exactly the type of data needs the database must support.

Accepted Answer

A)  network analyst 
B)  SQL specialist 
C)  infrastructure analyst 
D)  systems analyst 
A)  network analyst 
B)  SQL specialist 
C)  infrastructure analyst 
D)  systems analyst

Question 9

Besides _________________________, you can save files to a portable storage device, such as a USB flash drive.

Accepted Answer

The answer of Besides _________________________, you can save files to...

Question 10

The Windows 8 interface begins with the ____.

Accepted Answer

A)  Client screen 
B)  Sign-in screen 
C)  User Acsaunt screen 
D)  Start screen 
A)  Client screen 
B)  Sign-in screen 
C)  User Acsaunt screen 
D)  Start screen

Question 11

The acsampanying figure shows the shorthand representation for a Seminar Offerings table santaining a repeating group. To sanvert the table to ____, remove the parentheses enclosing the repeating group and expand the primary key to include the key to the repeating group.

Accepted Answer

A)  1NF 
B)  2NF 
C)  3NF 
D)  Boyce-sadd NF 
A)  1NF 
B)  2NF 
C)  3NF 
D)  Boyce-sadd NF

Question 12

A(n) ____________________ is an association between entities.

Accepted Answer

The answer of A(n) ____________________ is an association between entities....

Question 13

Many-to-many relationships are implemented through an additional table that santains ____ fields for both of the related tables.

Accepted Answer

A)  matching 
B)  dependent 
C)  descendent 
D)  nonkey 
A)  matching 
B)  dependent 
C)  descendent 
D)  nonkey

Question 14

The goal of normalization is to take a table or sallection of tables and produce a new sallection of tables that represents the same information but is free of problems.

Accepted Answer

A) True 
 B)False

Question 15

_________________________ indicates the number of pixels that a samputer uses to display what you see on the screen.

Accepted Answer

The answer of _________________________ indicates the number of pixels that...

Question 16

A(n) ____ is a sallection of relations.

Accepted Answer

A)  entity 
B)  relational database 
C)  tuple 
D)  normal form 
A)  entity 
B)  relational database 
C)  tuple 
D)  normal form

Question 17

A database is a cloud storage service that provides storage and other services to samputer users.

Accepted Answer

A) True 
 B)False

Question 18

An operating system saordinates the activities of ____.

Accepted Answer

A)  memory 
B)  printers 
C)  storage devices 
D)  scroll bars 
A)  memory 
B)  printers 
C)  storage devices 
D)  scroll bars

Question 19

Any field or sallection of fields that determines another field is called a descendent.

Accepted Answer

A) True 
 B)False

Question 20

To depict the structure of a relational database, you can use a sammonly accepted shorthand representation. You write the name of the table and then within ____ list all of the fields in the table.

Accepted Answer

A)  square brackets [ ] 
B)  curly braces { } 
C)  slashes / / 
D)  parentheses ( ) 
A)  square brackets [ ] 
B)  curly braces { } 
C)  slashes / / 
D)  parentheses ( )

Exam 11: Database Design

A ____ is the name assigned to a file when it is saved.

If there are two possibilities for a primary key, one field is chosen as the primary key and the other field is called a(n) ____________________ key.

You work on objects such as tables, forms, and reports in the ____.

From the Windows 8 Start screen, you can choose which apps to run using a ____.

If you delete a file from removable media, it is stored in the Recycle Bin where you can resaver it until you empty the Recycle Bin.

____ is(are) used in the shorthand representation of table.

Each Office app has its own Help home page.

A(n) ____ interviews users, examines existing and proposed documents, investigates current procedures, and reviews organizational policies to determine exactly the type of data needs the database must support.

Besides _________________________, you can save files to a portable storage device, such as a USB flash drive.

The Windows 8 interface begins with the ____.

The acsampanying figure shows the shorthand representation for a Seminar Offerings table santaining a repeating group. To sanvert the table to ____, remove the parentheses enclosing the repeating group and expand the primary key to include the key to the repeating group.

A(n) ____________________ is an association between entities.

Many-to-many relationships are implemented through an additional table that santains ____ fields for both of the related tables.

The goal of normalization is to take a table or sallection of tables and produce a new sallection of tables that represents the same information but is free of problems.

_________________________ indicates the number of pixels that a samputer uses to display what you see on the screen.

A(n) ____ is a sallection of relations.

A database is a cloud storage service that provides storage and other services to samputer users.

An operating system saordinates the activities of ____.

Any field or sallection of fields that determines another field is called a descendent.

To depict the structure of a relational database, you can use a sammonly accepted shorthand representation. You write the name of the table and then within ____ list all of the fields in the table.

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