Question 1

In what ways can you customize the Navigation pane and how can it be used as a security pane?

Accepted Answer

The Navigation pane displays the objects

Question 2

When drawing an ERD,which of the following indicates a one?

Accepted Answer

A)  primary key field 
B)  circle symbol 
C)  single line symbol 
D)  crow's foot symbol 
A)  primary key field 
B)  circle symbol 
C)  single line symbol 
D)  crow's foot symbol

Question 3

Which of the following statements is true related to customizing the Navigation pane?

Accepted Answer

A)  You can delete a shortcut or an object. 
B)  You can delete a shortcut,but not an object. 
C)  You can delete an object,but not a shortcut. 
D)  To delete an object,double-click the object and then select Delete from the shortcut menu. 
A)  You can delete a shortcut or an object. 
B)  You can delete a shortcut,but not an object. 
C)  You can delete an object,but not a shortcut. 
D)  To delete an object,double-click the object and then select Delete from the shortcut menu.

Question 4

The back-end database contains all of the original objects,except the tables,which have been replaced with linked tables.

Accepted Answer

A) True 
 B)False

Question 5

What is an Entity-Relationship Diagram (ERD)?

Accepted Answer

An Entity-Relationship Diagram (ERD)is a

Question 6

In an ERD,which of the following indicates optional participation?

Accepted Answer

A)  circle symbol 
B)  cardinality 
C)  single line symbol 
D)  modality 
A)  circle symbol 
B)  cardinality 
C)  single line symbol 
D)  modality

Question 7

When drawing an ERD,which of the following indicates a many?

Accepted Answer

A)  primary key field 
B)  circle symbol 
C)  single line symbol 
D)  crow's foot symbol 
A)  primary key field 
B)  circle symbol 
C)  single line symbol 
D)  crow's foot symbol

Question 8

In an ERD,which of the following are the people,places,or things about which you want to store data?

Accepted Answer

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

Question 9

When would you want to lock a database? What is the process for creating an executable file?

Accepted Answer

Another Save As option in Access creates

Question 10

In newer versions of Access,which of the following has an extension of .accde?

Accepted Answer

A)  executable file 
B)  denormalized database 
C)  graphics file 
D)  compacted database 
A)  executable file 
B)  denormalized database 
C)  graphics file 
D)  compacted database

Question 11

What is the minimum number of characters you should use in order to create a strong password?

Accepted Answer

A)  4 
B)  6 
C)  8 
D)  10 
A)  4 
B)  6 
C)  8 
D)  10

Question 12

What types of solutions does the Performance Analyzer tool provide?

Accepted Answer

A)  recommendations 
B)  suggestions 
C)  ideas 
D)  all of the above 
A)  recommendations 
B)  suggestions 
C)  ideas 
D)  all of the above

Question 13

When using the Database Documenter,to where can you export your report?

Accepted Answer

A)  PDF file 
B)  Excel or Word 
C)  Text File 
D)  all of the above 
A)  PDF file 
B)  Excel or Word 
C)  Text File 
D)  all of the above

Question 14

Which of the following tools creates the back-end database and moves the table objects into the back-end database?

Accepted Answer

A)  Performance Analyzer tool 
B)  Database Documenter tool 
C)  Table Analyzer tool 
D)  Database Splitter tool 
A)  Performance Analyzer tool 
B)  Database Documenter tool 
C)  Table Analyzer tool 
D)  Database Splitter tool

Question 15

What does the process of normalization involve?

Accepted Answer

A)  organizing attributes 
B)  organizing fields into the correct tables 
C)  creating a set of tables that minimizes problems in the database 
D)  all of the above 
A)  organizing attributes 
B)  organizing fields into the correct tables 
C)  creating a set of tables that minimizes problems in the database 
D)  all of the above

Question 16

Which of the following requires that a table must not have any repeating values?

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 17

Which of the following affects the quality of the recommendations made by the Table Analyzer tool?

Accepted Answer

A)  the actual data in the table 
B)  whether fields in the table are associated with too many different entities 
C)  whether a table contains a concatenated key 
D)  all of the above 
A)  the actual data in the table 
B)  whether fields in the table are associated with too many different entities 
C)  whether a table contains a concatenated key 
D)  all of the above

Question 18

In ERD terminology,what is another name for relationship's type?

Accepted Answer

A)  circle symbol 
B)  cardinality 
C)  single line symbol 
D)  modality 
A)  circle symbol 
B)  cardinality 
C)  single line symbol 
D)  modality

Question 19

Which of the following helps a database to run faster?

Accepted Answer

A)  executable files 
B)  fewer controls and graphics 
C)  compact the database 
D)  all of the above 
A)  executable files 
B)  fewer controls and graphics 
C)  compact the database 
D)  all of the above

Question 20

The goal of normalization is for each table to reach 1NF.

Accepted Answer

A) True 
 B)False

In what ways can you customize the Navigation pane and how can it be used as a security pane?

When drawing an ERD,which of the following indicates a one?

Which of the following statements is true related to customizing the Navigation pane?

The back-end database contains all of the original objects,except the tables,which have been replaced with linked tables.

What is an Entity-Relationship Diagram (ERD)?

In an ERD,which of the following indicates optional participation?

When drawing an ERD,which of the following indicates a many?

In an ERD,which of the following are the people,places,or things about which you want to store data?

When would you want to lock a database? What is the process for creating an executable file?

In newer versions of Access,which of the following has an extension of .accde?

What is the minimum number of characters you should use in order to create a strong password?

What types of solutions does the Performance Analyzer tool provide?

When using the Database Documenter,to where can you export your report?

Which of the following tools creates the back-end database and moves the table objects into the back-end database?

What does the process of normalization involve?

Which of the following requires that a table must not have any repeating values?

Which of the following affects the quality of the recommendations made by the Table Analyzer tool?

In ERD terminology,what is another name for relationship's type?

Which of the following helps a database to run faster?

The goal of normalization is for each table to reach 1NF.

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

In what ways can you customize the Navigation pane and how can it be used as a security pane?

When drawing an ERD,which of the following indicates a one?

Which of the following statements is true related to customizing the Navigation pane?

The back-end database contains all of the original objects,except the tables,which have been replaced with linked tables.

What is an Entity-Relationship Diagram (ERD)?

In an ERD,which of the following indicates optional participation?

When drawing an ERD,which of the following indicates a many?

In an ERD,which of the following are the people,places,or things about which you want to store data?

When would you want to lock a database? What is the process for creating an executable file?

In newer versions of Access,which of the following has an extension of .accde?

What is the minimum number of characters you should use in order to create a strong password?

What types of solutions does the Performance Analyzer tool provide?

When using the Database Documenter,to where can you export your report?

Which of the following tools creates the back-end database and moves the table objects into the back-end database?

What does the process of normalization involve?

Which of the following requires that a table must not have any repeating values?

Which of the following affects the quality of the recommendations made by the Table Analyzer tool?

In ERD terminology,what is another name for relationship's type?

Which of the following helps a database to run faster?

The goal of normalization is for each table to reach 1NF.

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