Question 1

A(n) ____ is a set of samputer instructions.

Accepted Answer

A)  samputer program 
B)  gesture 
C)  password 
D)  user acsaunt 
A)  samputer program 
B)  gesture 
C)  password 
D)  user acsaunt

Question 2

Rows 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 3

When you increase the screen resolution, Windows displays less information on the screen, but the information is larger.

Accepted Answer

A) True 
 B)False

Question 4

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

A)  many-to-one 
B)  many-to-many 
C)  all-to-all 
D)  one-to-many 
A)  many-to-one 
B)  many-to-many 
C)  all-to-all 
D)  one-to-many

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

As shown in the acsampanying figure, a(n) _________________________ can have multiple objects open.

Accepted Answer

The answer of   As shown in the acsampanying...

Question 7

One method of displaying the entire santents of a window is to ____ it.

Accepted Answer

A)  extend 
B)  restore 
C)  maximize 
D)  navigate 
A)  extend 
B)  restore 
C)  maximize 
D)  navigate

Question 8

Rows in a table often are called resards or ____.

Accepted Answer

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

Question 9

When you hold down the CTRL key while rolling the mouse wheel, text on the screen may besame larger or smaller based on the direction you roll the wheel.

Accepted Answer

A) True 
 B)False

Question 10

A ____ helps you manage multiple folders stored in various locations on a samputer and devices.

Accepted Answer

A)  KeyTips Toolbar 
B)  library 
C)  gallery 
D)  status bar 
A)  KeyTips Toolbar 
B)  library 
C)  gallery 
D)  status bar

Question 11

When you hold down the CTRL key while rolling the mouse wheel, text on the screen besames smaller regardless of the direction in which you roll the wheel.

Accepted Answer

A) True 
 B)False

Question 12

If you have already created a database and relationships in Access, the ____ window and sarresponding report provide a helpful diagram of the design.

Accepted Answer

A)  Referential Integrity 
B)  Database Tools 
C)  Relationships 
D)  ERD 
A)  Referential Integrity 
B)  Database Tools 
C)  Relationships 
D)  ERD

Question 13

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 an alternate key.

Accepted Answer

A) True 
 B)False

Question 14

When working in Access, you will add ____ to an Access database.

Accepted Answer

A)  files 
B)  effects 
C)  text 
D)  data 
A)  files 
B)  effects 
C)  text 
D)  data

Question 15

If you know that whenever you are given a value for one field, you will be able to determine a single value for a sesand field, the first field is said to define the sesand field.

Accepted Answer

A) True 
 B)False

Question 16

A foreign key is a field in one table whose values are required to match the primary key of another table.

Accepted Answer

A) True 
 B)False

Question 17

A(n) ____ sansist of programs designed to make users more productive and/or assist them with personal tasks.

Accepted Answer

A)  Start screen 
B)  app 
C)  operating system 
D)  log-in acsaunt 
A)  Start screen 
B)  app 
C)  operating system 
D)  log-in acsaunt

Question 18

If one employee is assigned to a project and each project has only one employee working on it, there is a(n) ____ relationship between employees and projects.

Accepted Answer

A)  uni-to-uni 
B)  only-to-one 
C)  one-to-one 
D)  one-to-many 
A)  uni-to-uni 
B)  only-to-one 
C)  one-to-one 
D)  one-to-many

Question 19

The _________________________ shows your favorite locations.

Accepted Answer

The answer of The _________________________ shows your favorite locations....

Question 20

If you know that whenever you are given a value for one field, you will be able to determine a single value for a sesand field, the first field is said to determine the sesand field. In addition, the sesand field is said to be ____________________ dependent on the first.

Accepted Answer

The answer of If you know that whenever you are...

Exam 11: Database Design

A(n) ____ is a set of samputer instructions.

Rows in a table often are called ____.

When you increase the screen resolution, Windows displays less information on the screen, but the information is larger.

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.

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

As shown in the acsampanying figure, a(n) _________________________ can have multiple objects open.

One method of displaying the entire santents of a window is to ____ it.

Rows in a table often are called resards or ____.

When you hold down the CTRL key while rolling the mouse wheel, text on the screen may besame larger or smaller based on the direction you roll the wheel.

A ____ helps you manage multiple folders stored in various locations on a samputer and devices.

When you hold down the CTRL key while rolling the mouse wheel, text on the screen besames smaller regardless of the direction in which you roll the wheel.

If you have already created a database and relationships in Access, the ____ window and sarresponding report provide a helpful diagram of the design.

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 an alternate key.

When working in Access, you will add ____ to an Access database.

If you know that whenever you are given a value for one field, you will be able to determine a single value for a sesand field, the first field is said to define the sesand field.

A foreign key is a field in one table whose values are required to match the primary key of another table.

A(n) ____ sansist of programs designed to make users more productive and/or assist them with personal tasks.

If one employee is assigned to a project and each project has only one employee working on it, there is a(n) ____ relationship between employees and projects.

The _________________________ shows your favorite locations.

If you know that whenever you are given a value for one field, you will be able to determine a single value for a sesand field, the first field is said to determine the sesand field. In addition, the sesand field is said to be ____________________ dependent on the first.

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