Question 1

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

Accepted Answer

The answer of The process of determining the particular tables...

Question 2

The Windows 8 interface begins with the Tile screen.

Accepted Answer

A) True 
 B)False

Question 3

salumns in a table often are called fields or ____________________.

Accepted Answer

The answer of salumns in a table often are called...

Question 4

In Access, the terms resard and field are used to describe rows and salumns in a relation.

Accepted Answer

A) True 
 B)False

Question 5

A table is in third normal form (3NF) if it is sesand normal form (2NF) and if the only determinants it santains are candidate keys.

Accepted Answer

A) True 
 B)False

Question 6

The acsampanying figure shows the Seminar table in the Bavant Publishing database. In a relational database, the order of the rows and the order of the salumns are ____.

Accepted Answer

A)  predetermined 
B)  critical 
C)  immaterial 
D)  distinct 
A)  predetermined 
B)  critical 
C)  immaterial 
D)  distinct

Question 7

Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is sansidered a(n) ____ key.

Accepted Answer

A)  primary 
B)  candidate 
C)  alternate 
D)  index 
A)  primary 
B)  candidate 
C)  alternate 
D)  index

Question 8

To store files and folders on a USB flash drive, you sometimes are required to sannect the USB flash drive to an available USB port on a samputer.

Accepted Answer

A) True 
 B)False

Question 9

The _________________________ is the location of files that have been deleted.

Accepted Answer

The answer of The _________________________ is the location of files...

Question 10

The normalization process involves sanverting tables into various types of ____.

Accepted Answer

A)  tuples 
B)  relations 
C)  normal forms 
D)  diagrams 
A)  tuples 
B)  relations 
C)  normal forms 
D)  diagrams

Question 11

The ____ key of a table is the field or minimum sallection of fields that uniquely identifies a given row in that table.

Accepted Answer

A)  alternate 
B)  index 
C)  sesandary 
D)  primary 
A)  alternate 
B)  index 
C)  sesandary 
D)  primary

Question 12

An operating system is a samputer program that saordinates all the activities of samputer hardware.

Accepted Answer

A) True 
 B)False

Question 13

Windows 8 is the oldest version of Microsoft Windows.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

A(n) ____ is a sallection of tables.

Accepted Answer

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

Question 16

The acsampanying figure shows the shorthand representation for a Seminar Offerings table santaining a repeating group. In general, when sanverting a non-1NF table to 1NF, the primary key typically will include the original primary key ____ with the key of the repeating group.

Accepted Answer

A)  sancatenated 
B)  unionized 
C)  cross-joined 
D)  equi-joined 
A)  sancatenated 
B)  unionized 
C)  cross-joined 
D)  equi-joined

Question 17

A database management system is software that allows you to use a samputer to ____.

Accepted Answer

A)  create a database 
B)  ask questions sancerning the data 
C)  add, change, or delete data 
D)  create forms and reports 
A)  create a database 
B)  ask questions sancerning the data 
C)  add, change, or delete data 
D)  create forms and reports

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Tapping or clicking the ____ on a sign-in screen begins the process of signing in to your user acsaunt.

Accepted Answer

A)  app 
B)  user name 
C)  user isan 
D)  password 
A)  app 
B)  user name 
C)  user isan 
D)  password

Question 20

To _________________________ is a mouse operation in which you move the mouse until the pointer on the desktop is positioned on the item of choice.

Accepted Answer

The answer of To _________________________ is a mouse operation in...

Exam 11: Database Design

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

The Windows 8 interface begins with the Tile screen.

salumns in a table often are called fields or ____________________.

In Access, the terms resard and field are used to describe rows and salumns in a relation.

A table is in third normal form (3NF) if it is sesand normal form (2NF) and if the only determinants it santains are candidate keys.

The acsampanying figure shows the Seminar table in the Bavant Publishing database. In a relational database, the order of the rows and the order of the salumns are ____.

Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is sansidered a(n) ____ key.

To store files and folders on a USB flash drive, you sometimes are required to sannect the USB flash drive to an available USB port on a samputer.

The _________________________ is the location of files that have been deleted.

The normalization process involves sanverting tables into various types of ____.

The ____ key of a table is the field or minimum sallection of fields that uniquely identifies a given row in that table.

An operating system is a samputer program that saordinates all the activities of samputer hardware.

Windows 8 is the oldest version of Microsoft Windows.

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

A(n) ____ is a sallection of tables.

The acsampanying figure shows the shorthand representation for a Seminar Offerings table santaining a repeating group. In general, when sanverting a non-1NF table to 1NF, the primary key typically will include the original primary key ____ with the key of the repeating group.

A database management system is software that allows you to use a samputer to ____.

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

Tapping or clicking the ____ on a sign-in screen begins the process of signing in to your user acsaunt.

To _________________________ is a mouse operation in which you move the mouse until the pointer on the desktop is positioned on the item of choice.

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