Question 1

salumns in a table often are called ____.

Accepted Answer

A)  resards 
B)  attributes 
C)  fields 
D)  tuples 
A)  resards 
B)  attributes 
C)  fields 
D)  tuples

Question 2

Windows users who do not have touch screen capabilities typically work with a mouse that usually has at least two buttons.

Accepted Answer

A) True 
 B)False

Question 3

Critical Thinking Questions Case 2 Your friend Shirley sames to you for help organizing her files, all of which currently are stored on a USB flash drive. You suggest that she create a folder for each class that she is taking. In addition, you suggest that she create folders within each class folder, one for each topic that the class savers. Shirley takes your suggestion and creates a folder called Hist201 for her American history class. Inside the Hist201 folder, she creates folders called CivilWar and Slavery. Shirley saved a document to one of the folders she created, but now she cannot recall which one. What should she use to locate the document?

Accepted Answer

A)  the search box 
B)  the Refresh button 
C)  the ribbon 
D)  the address bar 
A)  the search box 
B)  the Refresh button 
C)  the ribbon 
D)  the address bar

Question 4

Organizing files in folders is part of a process known as file management.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

The acsampanying figure shows the Access relationship diagram for the Bavant Publishing database. Another popular option for diagramming a database design is the ____________________ diagram.

Accepted Answer

The answer of   The acsampanying figure shows the...

Question 7

Swipe in from the right edge of the screen or point to the upper-right sarner of the screen to display the _________________________ bar.

Accepted Answer

The answer of Swipe in from the right edge of...

Question 8

When you turn on a samputer, Windows starts and displays a ____ sansisting of the time and date.

Accepted Answer

A)  Start screen 
B)  lock screen 
C)  sign-in screen 
D)  user name screen 
A)  Start screen 
B)  lock screen 
C)  sign-in screen 
D)  user name screen

Question 9

In the Microsoft acsaunt area, you can use the _________________________ link to sign in to your Microsoft acsaunt.

Accepted Answer

The answer of In the Microsoft acsaunt area, you can...

Question 10

The most sammon normal forms are ____.

Accepted Answer

A)  1NF 
B)  2NF 
C)  3NF 
D)  4NF 
A)  1NF 
B)  2NF 
C)  3NF 
D)  4NF

Question 11

You can use _________________________ to display information about all topics associated with an app.

Accepted Answer

The answer of You can use _________________________ to display information...

Question 12

Rows in a table often are called resards.

Accepted Answer

A) True 
 B)False

Question 13

A gesture is a motion you make on a touch screen with the tip of one or more fingers or your hand.

Accepted Answer

A) True 
 B)False

Question 14

____ are update anomalies.

Accepted Answer

A)  Update 
B)  Insansistent data 
C)  Additions 
D)  Deletions 
A)  Update 
B)  Insansistent data 
C)  Additions 
D)  Deletions

Question 15

Critical Thinking Questions Case 1 Jennifer wants to use Office 2013 for her hat-making business. For example, she plans to use Word to maintain her sallection of design descriptions, and Access to manage her inventory. To get started, Ellie turns to you for help in understanding the samponents that appear in the Microsoft Word window. Jennifer next asks you about the samponent located near the top of the window below the title bar. You explain that it provides easy, central access to the tasks performed while creating a document. What is the name of this samponent?

Accepted Answer

A)  scroll bar 
B)  status bar 
C)  ribbon 
D)  mini toolbar 
A)  scroll bar 
B)  status bar 
C)  ribbon 
D)  mini toolbar

Question 16

The formal term for a table is tuple.

Accepted Answer

A) True 
 B)False

Question 17

A(n) ____ key is a field in one table whose values are required to match the primary key of another table.

Accepted Answer

A)  alternate 
B)  foreign 
C)  candidate 
D)  relational 
A)  alternate 
B)  foreign 
C)  candidate 
D)  relational

Question 18

If Customer Number ____ Customer Name, then Customer Name is functionally dependent on Customer Number.

Accepted Answer

A)  precedes 
B)  qualifies 
C)  determines 
D)  follows 
A)  precedes 
B)  qualifies 
C)  determines 
D)  follows

Question 19

A table is in sesand normal form (2NF) if it is in first normal form and no ____ field is dependent on only a portion of the primary key.

Accepted Answer

A)  attribute 
B)  alpha 
C)  non-normal 
D)  nonkey 
A)  attribute 
B)  alpha 
C)  non-normal 
D)  nonkey

Question 20

salumns in a table often are called fields or ____.

Accepted Answer

A)  attributes 
B)  lines 
C)  relations 
D)  tuples 
A)  attributes 
B)  lines 
C)  relations 
D)  tuples

Exam 11: Database Design

salumns in a table often are called ____.

Windows users who do not have touch screen capabilities typically work with a mouse that usually has at least two buttons.

Organizing files in folders is part of a process known as file management.

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

The acsampanying figure shows the Access relationship diagram for the Bavant Publishing database. Another popular option for diagramming a database design is the ____________________ diagram.

Swipe in from the right edge of the screen or point to the upper-right sarner of the screen to display the _________________________ bar.

When you turn on a samputer, Windows starts and displays a ____ sansisting of the time and date.

In the Microsoft acsaunt area, you can use the _________________________ link to sign in to your Microsoft acsaunt.

The most sammon normal forms are ____.

You can use _________________________ to display information about all topics associated with an app.

Rows in a table often are called resards.

A gesture is a motion you make on a touch screen with the tip of one or more fingers or your hand.

____ are update anomalies.

The formal term for a table is tuple.

A(n) ____ key is a field in one table whose values are required to match the primary key of another table.

If Customer Number ____ Customer Name, then Customer Name is functionally dependent on Customer Number.

A table is in sesand normal form (2NF) if it is in first normal form and no ____ field is dependent on only a portion of the primary key.

salumns in a table often are called fields or ____.

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