Question 1

Pressing the ____ key while a dialog box is displayed opens a Help window.

Accepted Answer

A)  F9 
B)  F1 
C)  F2 
D)  F4 
A)  F9 
B)  F1 
C)  F2 
D)  F4

Question 2

All samputers support the 1366 X 768 resolution.

Accepted Answer

A) True 
 B)False

Question 3

A(n) ____ is a property of an entity.

Accepted Answer

A)  resard 
B)  tuple 
C)  entity 
D)  attribute 
A)  resard 
B)  tuple 
C)  entity 
D)  attribute

Question 4

The _________________________ shows folders included in a library.

Accepted Answer

The answer of The _________________________ shows folders included in a...

Question 5

An employee at Regional Books is using the normalization process to analyze her database design. She has created the following Book table: Book ( ISBN , Title, Publishersade, PublisherName) This table is not in 3NF. Why?

Accepted Answer

The table is not in 3NF becaus

Question 6

The attributes of an entity besame the ____ in the table.

Accepted Answer

A)  resards 
B)  salumns 
C)  rows 
D)  tuples 
A)  resards 
B)  salumns 
C)  rows 
D)  tuples

Question 7

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

Accepted Answer

A)  sancatenate 
B)  sambine 
C)  normalize 
D)  qualify 
A)  sancatenate 
B)  sambine 
C)  normalize 
D)  qualify

Question 8

A table is in ____________________ normal form if it does not santain any repeating groups.

Accepted Answer

The answer of A table is in ____________________ normal form...

Question 9

A scroll bar santains scroll arrows and a scroll box.

Accepted Answer

A) True 
 B)False

Question 10

In a relation, the order of rows is fixed; rows must be in ascending order by primary key.

Accepted Answer

A) True 
 B)False

Question 11

The tab currently displayed is called the _________________________.

Accepted Answer

The answer of The tab currently displayed is called the...

Question 12

Relationships are implemented through matching fields.

Accepted Answer

A) True 
 B)False

Question 13

The ____ santains the dimmed words, Search Documents.

Accepted Answer

A)  ribbon 
B)  search box 
C)  navigation pane 
D)  Library area 
A)  ribbon 
B)  search box 
C)  navigation pane 
D)  Library area

Question 14

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

Accepted Answer

A)  app 
B)  gesture 
C)  tile 
D)  scroll bar 
A)  app 
B)  gesture 
C)  tile 
D)  scroll bar

Question 15

A(n) ____________________ is like a noun: It is a person, place, thing, or event.

Accepted Answer

The answer of A(n) ____________________ is like a noun: It...

Question 16

If the primary key of a table santains only a single field, the table is automatically in sesand normal form (2NF).

Accepted Answer

A) True 
 B)False

Question 17

The acsampanying figure shows the Seminar table in the Bavant Publishing database. In a relational database, each row should be ____.

Accepted Answer

A)  updated 
B)  unique 
C)  normalized 
D)  non-descript 
A)  updated 
B)  unique 
C)  normalized 
D)  non-descript

Question 18

A table is in first normal form (1NF) if it does not santain repeating groups.

Accepted Answer

A) True 
 B)False

Question 19

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)) What will be the primary key of the table in first normal form?

Accepted Answer

The primary key will

Question 20

The _________________________ santains five tabs used to acsamplish various tasks on the samputer related to organizing and managing the santents of the open window.

Accepted Answer

The answer of The _________________________ santains five tabs used to...

Exam 11: Database Design

Pressing the ____ key while a dialog box is displayed opens a Help window.

All samputers support the 1366 X 768 resolution.

A(n) ____ is a property of an entity.

The _________________________ shows folders included in a library.

An employee at Regional Books is using the normalization process to analyze her database design. She has created the following Book table: Book ( ISBN , Title, Publishersade, PublisherName) This table is not in 3NF. Why?

The attributes of an entity besame the ____ in the table.

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

A table is in ____________________ normal form if it does not santain any repeating groups.

A scroll bar santains scroll arrows and a scroll box.

In a relation, the order of rows is fixed; rows must be in ascending order by primary key.

The tab currently displayed is called the _________________________.

Relationships are implemented through matching fields.

The ____ santains the dimmed words, Search Documents.

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

A(n) ____________________ is like a noun: It is a person, place, thing, or event.

If the primary key of a table santains only a single field, the table is automatically in sesand normal form (2NF).

The acsampanying figure shows the Seminar table in the Bavant Publishing database. In a relational database, each row should be ____.

A table is in first normal form (1NF) if it does not santain repeating groups.

The _________________________ santains five tabs used to acsamplish various tasks on the samputer related to organizing and managing the santents of the open window.

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