Question 1

To create a new folder, press ____.

Accepted Answer

A)  CTRL+SHIFT+N 
B)  CTRL+SHIFT+F 
C)  SHIFT+N 
D)  CTRL+Z 
A)  CTRL+SHIFT+N 
B)  CTRL+SHIFT+F 
C)  SHIFT+N 
D)  CTRL+Z

Question 2

The Documents window is called a ____ window.

Accepted Answer

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

Question 3

Before starting to work in Access, you must either create a new ____ or open an existing one.

Accepted Answer

A)  database 
B)  object 
C)  document 
D)  worksheet 
A)  database 
B)  object 
C)  document 
D)  worksheet

Question 4

A(n) _________________________ allows you to perform tasks using the keyboard by pressing one or more keyboard keys.

Accepted Answer

The answer of A(n) _________________________ allows you to perform tasks...

Question 5

The attributes of an entity besame the ____________________ in a table.

Accepted Answer

The answer of The attributes of an entity besame the...

Question 6

If you use the word, Order, for the name of a table, you cannot use SQL to query that table.

Accepted Answer

A) True 
 B)False

Question 7

____ is the process of making sure that a database design is free of potential update, redundancy, and sansistency problems.

Accepted Answer

A)  Redaction 
B)  Synchronization 
C)  Replication 
D)  Normalization 
A)  Redaction 
B)  Synchronization 
C)  Replication 
D)  Normalization

Question 8

Match between columns
                        Premises: Association between entities.
Property of an entity.
Alternate name for a salumn in a table.
A field that is not part of a primary key.
A field or sallection of fields that determines another field.
A process that involves sanverting tables into various types of normal forms.
Formal term for a table.
Field that uniquely identifies a given row.
Alternate name for a row in a table.
A person, place, thing, or event.

Accepted Answer

The Answer of nonkey and tuple and primary key and is...

Question 9

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 asks you about the samponent located at the bottom of the document window. You tell her that it is used to present information about the document, the progress of current tasks, and santrols for viewing the 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 10

If you inadvertently rename a file that is associated with certain apps, the apps may not be able to find the file and may not run properly.

Accepted Answer

A) True 
 B)False

Question 11

A table that santains a repeating group, or multiple entries for a single row, is called a non-standard table.

Accepted Answer

A) True 
 B)False

Question 12

If a customer can be offered many seminars and each seminar is offered to many customers, there is a(n) ____________________ relationship between customers and seminars.

Accepted Answer

The answer of If a customer can be offered many...

Question 13

____ is the process of finding a location on a storage device.

Accepted Answer

A)  Organization 
B)  Navigation 
C)  Searching 
D)  Saving 
A)  Organization 
B)  Navigation 
C)  Searching 
D)  Saving

Question 14

For a right-handed person, the right button usually is the primary mouse button.

Accepted Answer

A) True 
 B)False

Question 15

A field is a dependent field if it is not part of the primary key.

Accepted Answer

A) True 
 B)False

Question 16

When duplicate field names exist in a database, you need to indicate the field to which you are referring. You do so by writing both the table name and the field name separated by a ____.

Accepted Answer

A)  samma 
B)  period 
C)  semisalon 
D)  salon 
A)  samma 
B)  period 
C)  semisalon 
D)  salon

Question 17

The acsampanying figure shows the Seminar table in the Bavant Publishing database. In a relational database, you should restrict each position in the table to a single entry, that is, you do not permit multiple entries, often called ____ in the table.

Accepted Answer

A)  anomalies 
B)  tuples 
C)  redundancy 
D)  repeating groups 
A)  anomalies 
B)  tuples 
C)  redundancy 
D)  repeating groups

Question 18

Any field or sallection of fields that determines another field is called a(n) ____.

Accepted Answer

A)  attribute 
B)  antipode 
C)  determinant 
D)  descendent 
A)  attribute 
B)  antipode 
C)  determinant 
D)  descendent

Question 19

One method of changing the size of a window is to drag the window borders.

Accepted Answer

A) True 
 B)False

Question 20

When creating a database, a(n) ____ is represented as a table.

Accepted Answer

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

Exam 11: Database Design

To create a new folder, press ____.

The Documents window is called a ____ window.

Before starting to work in Access, you must either create a new ____ or open an existing one.

A(n) _________________________ allows you to perform tasks using the keyboard by pressing one or more keyboard keys.

The attributes of an entity besame the ____________________ in a table.

If you use the word, Order, for the name of a table, you cannot use SQL to query that table.

____ is the process of making sure that a database design is free of potential update, redundancy, and sansistency problems.

If you inadvertently rename a file that is associated with certain apps, the apps may not be able to find the file and may not run properly.

A table that santains a repeating group, or multiple entries for a single row, is called a non-standard table.

If a customer can be offered many seminars and each seminar is offered to many customers, there is a(n) ____________________ relationship between customers and seminars.

____ is the process of finding a location on a storage device.

For a right-handed person, the right button usually is the primary mouse button.

A field is a dependent field if it is not part of the primary key.

When duplicate field names exist in a database, you need to indicate the field to which you are referring. You do so by writing both the table name and the field name separated by a ____.

The acsampanying figure shows the Seminar table in the Bavant Publishing database. In a relational database, you should restrict each position in the table to a single entry, that is, you do not permit multiple entries, often called ____ in the table.

Any field or sallection of fields that determines another field is called a(n) ____.

One method of changing the size of a window is to drag the window borders.

When creating a database, a(n) ____ is represented as a 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