Question 1

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

Accepted Answer

attribute

Question 2

When data has a unique identifier included as part of the data,this is called a ________ key.

Accepted Answer

A)  primary 
B)  natural 
C)  composite 
D)  normal 
A)  primary 
B)  natural 
C)  composite 
D)  normal B

Question 3

When you have a relationship between tables in which one record in one table has many matching records in a second table,and one record in the second table has many matching records in the first table,you have a(n)________ relationship.

Accepted Answer

many-to-many

Question 4

Though it does not affect the way data is stored in Access,a ________ tells Access how the data is to be displayed.

Accepted Answer

A)  label 
B)  preset 
C)  format 
D)  design 
A)  label 
B)  preset 
C)  format 
D)  design

Question 5

Delimited text has a special character such as a tab or a comma separating field entries.

Accepted Answer

A) True 
 B)False

Question 6

In a numeric data type,the Field size property defines the ________ or value.

Accepted Answer

A)  maximum length 
B)  property 
C)  calculated value 
D)  total value 
A)  maximum length 
B)  property 
C)  calculated value 
D)  total value

Question 7

You can add primary key data later after defining a primary key in a table.

Accepted Answer

A) True 
 B)False

Question 8

A relationship between tables where a record in the first table has only one matching record in the second table is called a(n)________ relationship.

Accepted Answer

The answer of A relationship between tables where a record...

Question 9

The three columns in the upper pane of a Table Design view are ________.

Accepted Answer

A)  Field Name, Data Type, and Description 
B)  Field Name, Data Type, and Information 
C)  Data Type, Description, and Information 
D)  Field Name, Description, and Information 
A)  Field Name, Data Type, and Description 
B)  Field Name, Data Type, and Information 
C)  Data Type, Description, and Information 
D)  Field Name, Description, and Information

Question 10

In table design,the ________ field property allows you to customize how data is displayed and printed in tables,queries,reports,and forms.

Accepted Answer

The answer of In table design,the ________ field property allows...

Question 11

When cutting and pasting columns from Excel to Access,they must be the exactly the same.

Accepted Answer

A) True 
 B)False

Question 12

Rules that Access uses to ensure that the relationships you form between records in your tables make sense are called ________.

Accepted Answer

referentia

Question 13

In a database,data about a person,place,item or event is called a(n)________.

Accepted Answer

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

Question 14

A set of rules that Access uses to make sure that the relationships you are forming between the records in your tables make sense are called ________.

Accepted Answer

A)  table integrity 
B)  referential integrity 
C)  cascade rules 
D)  relationship rules 
A)  table integrity 
B)  referential integrity 
C)  cascade rules 
D)  relationship rules

Question 15

A field that CANNOT be blank and and must be unique is called a ________.

Accepted Answer

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

Question 16

You should use cascade delete to maintain your records and prevent redundancies.

Accepted Answer

A) True 
 B)False

Question 17

The field called the ________ that uniquely identifies a record in a table must be a field that will not change.

Accepted Answer

The answer of The field called the ________ that uniquely...

Question 18

If you are not using the same foreign key in two different tables to create a many-to-many relationship,you must use a(n)________ table to create the relationship.

Accepted Answer

The answer of If you are not using the same...

Question 19

The ________ data type can store up to 1 gigabyte of characters and should be used when the text data type will not hold enough text.

Accepted Answer

The answer of The ________ data type can store up...

Question 20

A shirt is an example of an item,or attribute,in a clothing store database,while an entity is information about the shirt,such as the color or style.

Accepted Answer

A) True 
 B)False

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

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

When data has a unique identifier included as part of the data,this is called a ________ key.

When you have a relationship between tables in which one record in one table has many matching records in a second table,and one record in the second table has many matching records in the first table,you have a(n)________ relationship.

Though it does not affect the way data is stored in Access,a ________ tells Access how the data is to be displayed.

Delimited text has a special character such as a tab or a comma separating field entries.

In a numeric data type,the Field size property defines the ________ or value.

You can add primary key data later after defining a primary key in a table.

A relationship between tables where a record in the first table has only one matching record in the second table is called a(n)________ relationship.

The three columns in the upper pane of a Table Design view are ________.

In table design,the ________ field property allows you to customize how data is displayed and printed in tables,queries,reports,and forms.

When cutting and pasting columns from Excel to Access,they must be the exactly the same.

Rules that Access uses to ensure that the relationships you form between records in your tables make sense are called ________.

In a database,data about a person,place,item or event is called a(n)________.

A set of rules that Access uses to make sure that the relationships you are forming between the records in your tables make sense are called ________.

A field that CANNOT be blank and and must be unique is called a ________.

You should use cascade delete to maintain your records and prevent redundancies.

The field called the ________ that uniquely identifies a record in a table must be a field that will not change.

If you are not using the same foreign key in two different tables to create a many-to-many relationship,you must use a(n)________ table to create the relationship.

The ________ data type can store up to 1 gigabyte of characters and should be used when the text data type will not hold enough text.

A shirt is an example of an item,or attribute,in a clothing store database,while an entity is information about the shirt,such as the color or style.

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