Question 1

You can rename or delete the built-in Tables and Related Views or the Object Type categories or the groups within those categories.

Accepted Answer

A) True 
 B)False

Question 2

Once you have designed the database tables,you are ready to review the ERD with your users.

Accepted Answer

A) True 
 B)False

Question 3

When an object is assigned to a custom group,Access creates a shortcut to that object.

Accepted Answer

A) True 
 B)False

Question 4

Normalization helps ensure that the fields describe only the entity represented in the table.

Accepted Answer

A) True 
 B)False

Question 5

In an ERD,which of the following are the associations or connections between entities?

Accepted Answer

A)  relationships 
B)  attributes 
C)  entities 
D)  instance 
A)  relationships 
B)  attributes 
C)  entities 
D)  instance

Question 6

In Access,which of the following processes the slowest?

Accepted Answer

A)  short text fields 
B)  long text fields 
C)  number fields 
D)  date fields 
A)  short text fields 
B)  long text fields 
C)  number fields 
D)  date fields

Question 7

What does it mean to optimize a database? What are some tips for optimizing a database?

Accepted Answer

There are a variety of ways to optimize

Question 8

Which of the following is the second level organizational structure of the Navigation pane?

Accepted Answer

A)  category 
B)  group 
C)  index 
D)  primary key 
A)  category 
B)  group 
C)  index 
D)  primary key

Question 9

Which of the following removes temporary objects that Access automatically creates due to the way it operates?

Accepted Answer

A)  executable files 
B)  fewer controls 
C)  use the Image Gallery 
D)  compact the database 
A)  executable files 
B)  fewer controls 
C)  use the Image Gallery 
D)  compact the database

Question 10

Which of the following statements is true about splitting a database?

Accepted Answer

A)  You must apply a password to the back-end database. 
B)  You must apply a password to all copies of the front-end database. 
C)  Your databases will be more secure if you password protect all parts of a split database. 
D)  all of the above 
A)  You must apply a password to the back-end database. 
B)  You must apply a password to all copies of the front-end database. 
C)  Your databases will be more secure if you password protect all parts of a split database. 
D)  all of the above

Question 11

What does encryption do and how is it implemented?

Accepted Answer

Encryption converts data into a coded fo

Question 12

An Entity-Relationship Diagram (ERD)is a type of data model that graphically represents the data needs of an organization.

Accepted Answer

A) True 
 B)False

Question 13

Passwords are not case sensitive.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following modes of opening a database allows shared use of the database and full access to all objects?

Accepted Answer

A)  Open 
B)  Open Read-Only 
C)  Open Exclusive 
D)  Open Exclusive Read-Only 
A)  Open 
B)  Open Read-Only 
C)  Open Exclusive 
D)  Open Exclusive Read-Only

Question 15

Ideally you should use the Analyze Table tool after you create the other objects in your database.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following statements is true about the goal of normalization?

Accepted Answer

A)  The goal of normalization is to ensure that the fields of a table describe only the entity represented in the table. 
B)  The goal of normalization is to ensure that the fields of a table describe many entities. 
C)  The goal of normalization is to ensure that information is stored more than once in a table. 
D)  all of the above 
A)  The goal of normalization is to ensure that the fields of a table describe only the entity represented in the table. 
B)  The goal of normalization is to ensure that the fields of a table describe many entities. 
C)  The goal of normalization is to ensure that information is stored more than once in a table. 
D)  all of the above

Question 17

In Access,which of the following processes the fastest?

Accepted Answer

A)  short text fields 
B)  long text fields 
C)  number fields 
D)  date fields 
A)  short text fields 
B)  long text fields 
C)  number fields 
D)  date fields

Question 18

Which of the following requires that a table must be in 1NF and all of the non-key fields must depend on the entire primary key?

Accepted Answer

A)  normal forms 
B)  first normal form 
C)  second normal form 
D)  third normal form 
A)  normal forms 
B)  first normal form 
C)  second normal form 
D)  third normal form

Question 19

When you open a form,report or query,the front-end database links to the back-end database to retrieve the data.

Accepted Answer

A) True 
 B)False

Question 20

In an ERD,which of the following should you use to review an ERD with your users so that they understand the data being represented in the diagram?

Accepted Answer

A)  relationships 
B)  attributes 
C)  entities 
D)  instances 
A)  relationships 
B)  attributes 
C)  entities 
D)  instances

You can rename or delete the built-in Tables and Related Views or the Object Type categories or the groups within those categories.

Once you have designed the database tables,you are ready to review the ERD with your users.

When an object is assigned to a custom group,Access creates a shortcut to that object.

Normalization helps ensure that the fields describe only the entity represented in the table.

In an ERD,which of the following are the associations or connections between entities?

In Access,which of the following processes the slowest?

What does it mean to optimize a database? What are some tips for optimizing a database?

Which of the following is the second level organizational structure of the Navigation pane?

Which of the following removes temporary objects that Access automatically creates due to the way it operates?

Which of the following statements is true about splitting a database?

What does encryption do and how is it implemented?

An Entity-Relationship Diagram (ERD)is a type of data model that graphically represents the data needs of an organization.

Passwords are not case sensitive.

Which of the following modes of opening a database allows shared use of the database and full access to all objects?

Ideally you should use the Analyze Table tool after you create the other objects in your database.

Which of the following statements is true about the goal of normalization?

In Access,which of the following processes the fastest?

Which of the following requires that a table must be in 1NF and all of the non-key fields must depend on the entire primary key?

When you open a form,report or query,the front-end database links to the back-end database to retrieve the data.

In an ERD,which of the following should you use to review an ERD with your users so that they understand the data being represented in the diagram?

Creating a Database and Tables

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters

Exam 2: Using Design View, Data Validation, and Relationships

You can rename or delete the built-in Tables and Related Views or the Object Type categories or the groups within those categories.

Once you have designed the database tables,you are ready to review the ERD with your users.

When an object is assigned to a custom group,Access creates a shortcut to that object.

Normalization helps ensure that the fields describe only the entity represented in the table.

In an ERD,which of the following are the associations or connections between entities?

In Access,which of the following processes the slowest?

What does it mean to optimize a database? What are some tips for optimizing a database?

Which of the following is the second level organizational structure of the Navigation pane?

Which of the following removes temporary objects that Access automatically creates due to the way it operates?

Which of the following statements is true about splitting a database?

What does encryption do and how is it implemented?

An Entity-Relationship Diagram (ERD)is a type of data model that graphically represents the data needs of an organization.

Passwords are not case sensitive.

Which of the following modes of opening a database allows shared use of the database and full access to all objects?

Ideally you should use the Analyze Table tool after you create the other objects in your database.

Which of the following statements is true about the goal of normalization?

In Access,which of the following processes the fastest?

Which of the following requires that a table must be in 1NF and all of the non-key fields must depend on the entire primary key?

When you open a form,report or query,the front-end database links to the back-end database to retrieve the data.

In an ERD,which of the following should you use to review an ERD with your users so that they understand the data being represented in the diagram?

Creating a Database and Tables

Creating and Using Queries

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters