Question 1

A(n)________ relationship has one record in the first table that corresponds to many records in the second table.

Accepted Answer

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

Question 2

A set of cells that can be used within a formula or function are a(n)________.

Accepted Answer

A)  export range 
B)  import range 
C)  named range 
D)  called range 
A)  export range 
B)  import range 
C)  named range 
D)  called range

Question 3

Normalization is the process of cascading updates throughout a database.

Accepted Answer

A) True 
 B)False

Question 4

Fields such as names or addresses should be split into their ________ parts.

Accepted Answer

A)  different 
B)  component 
C)  individual 
D)  separate 
A)  different 
B)  component 
C)  individual 
D)  separate

Question 5

When two fields are required to uniquely identify a record,they are called a(n)________ key.

Accepted Answer

The answer of When two fields are required to uniquely...

Question 6

Information about an entity is called a(n)________.

Accepted Answer

A)  field 
B)  attribute 
C)  table 
D)  row 
A)  field 
B)  attribute 
C)  table 
D)  row

Question 7

In Access,the relationship information is stored in the ________ window.

Accepted Answer

The answer of In Access,the relationship information is stored in...

Question 8

A(n)________ defines a consistent template and provides the punctuation.

Accepted Answer

The answer of A(n)________ defines a consistent template and provides...

Question 9

There is an upper limit of 155 characters for a text field.

Accepted Answer

A) True 
 B)False

Question 10

The Text data types give users the ability to calculate values.

Accepted Answer

A) True 
 B)False

Question 11

The ________ pane in Design view gives information on how data is stored,entered,and processed.

Accepted Answer

The answer of The ________ pane in Design view gives...

Question 12

When you open a table in ________ view,you can type data directly into the table.

Accepted Answer

The answer of When you open a table in ________...

Question 13

To type data into the table without using a form,you use the ________ view.

Accepted Answer

A)  Datasheet 
B)  Spreadsheet 
C)  Design 
D)  Worksheet 
A)  Datasheet 
B)  Spreadsheet 
C)  Design 
D)  Worksheet

Question 14

The maximum length of a data field is the ________.

Accepted Answer

A)  information size 
B)  field length 
C)  data size 
D)  field size 
A)  information size 
B)  field length 
C)  data size 
D)  field size

Question 15

________ are created by joining the tables in a relational database together.

Accepted Answer

A)  Relationships 
B)  Reports 
C)  Forms 
D)  Queries 
A)  Relationships 
B)  Reports 
C)  Forms 
D)  Queries

Question 16

________ makes changes and replicates the changes through all related tables so that referential integrity is maintained.

Accepted Answer

A)  Torrent update 
B)  Flow update 
C)  Cascade update 
D)  Waterfall update 
A)  Torrent update 
B)  Flow update 
C)  Cascade update 
D)  Waterfall update

Question 17

To allow for creating reports based on city or zip code,you should split address fields into their component parts.

Accepted Answer

A) True 
 B)False

Question 18

If the Undo button is dimmed,you CANNOT ________ the change you made.

Accepted Answer

A)  Redo 
B)  Undo 
C)  Enter 
D)  Delete 
A)  Redo 
B)  Undo 
C)  Enter 
D)  Delete

Question 19

To reference part of a worksheet in formulas or graphics by cell addresses or range addresses,you have to use a named range.

Accepted Answer

A) True 
 B)False

Question 20

By default,Access orders tables by the ________.

Accepted Answer

A)  secondary key 
B)  foreign key 
C)  primary key 
D)  composite key 
A)  secondary key 
B)  foreign key 
C)  primary key 
D)  composite key

Exam 6: Microsoft Access 2010,workshop 2: Gathering Data Into a Database

A(n)________ relationship has one record in the first table that corresponds to many records in the second table.

A set of cells that can be used within a formula or function are a(n)________.

Normalization is the process of cascading updates throughout a database.

Fields such as names or addresses should be split into their ________ parts.

When two fields are required to uniquely identify a record,they are called a(n)________ key.

Information about an entity is called a(n)________.

In Access,the relationship information is stored in the ________ window.

A(n)________ defines a consistent template and provides the punctuation.

There is an upper limit of 155 characters for a text field.

The Text data types give users the ability to calculate values.

The ________ pane in Design view gives information on how data is stored,entered,and processed.

When you open a table in ________ view,you can type data directly into the table.

To type data into the table without using a form,you use the ________ view.

The maximum length of a data field is the ________.

________ are created by joining the tables in a relational database together.

________ makes changes and replicates the changes through all related tables so that referential integrity is maintained.

To allow for creating reports based on city or zip code,you should split address fields into their component parts.

If the Undo button is dimmed,you CANNOT ________ the change you made.

To reference part of a worksheet in formulas or graphics by cell addresses or range addresses,you have to use a named range.

By default,Access orders tables by the ________.

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters