Question 1

Which of the following is the highest 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 D

Question 2

Which of the following does the Table Analyzer tool do if you accept the recommendation to create new tables?

Accepted Answer

A)  creates a relationship between the new tables 
B)  enforces referential integrity 
C)  both A and B 
D)  neither A nor B 
A)  creates a relationship between the new tables 
B)  enforces referential integrity 
C)  both A and B 
D)  neither A nor B C

Question 3

In an ERD,a single line symbol indicates a one,while a crow's foot symbol indicates a many.

Accepted Answer

A) True 
 B)False  True

Question 4

Which of the following is an authentication mechanism that contains identifying information about the creator?

Accepted Answer

A)  digital certificate 
B)  digital signature 
C)  front-end certificate 
D)  front-end signature 
A)  digital certificate 
B)  digital signature 
C)  front-end certificate 
D)  front-end signature

Question 5

Which of the following should you consider in order to create a strong password?

Accepted Answer

A)  use at least one uppercase letter and one lowercase letter 
B)  use at least one special character 
C)  use at least one number 
D)  all of the above 
A)  use at least one uppercase letter and one lowercase letter 
B)  use at least one special character 
C)  use at least one number 
D)  all of the above

Question 6

Within the text data type,a Long Text field takes longer to search than a Short Text field.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following file types the extension given to an Access executable file?

Accepted Answer

A)  .accdb 
B)  .accde 
C)  .accdc 
D)  .xls 
A)  .accdb 
B)  .accde 
C)  .accdc 
D)  .xls

Question 8

What normalization does is take smaller tables that have problems and join them together into bigger tables that no longer have problems.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following statements is true about the Database Documenter tool?

Accepted Answer

A)  It lets you select the level of detail displayed about the different objects in your database. 
B)  You can choose to see information about the property settings of fields and relationships of tables. 
C)  You can choose to see the property settings for controls and macro code attached to a form or report. 
D)  all of the above 
A)  It lets you select the level of detail displayed about the different objects in your database. 
B)  You can choose to see information about the property settings of fields and relationships of tables. 
C)  You can choose to see the property settings for controls and macro code attached to a form or report. 
D)  all of the above

Question 10

Which of the following extensions identifies a database that has been signed and packaged?

Accepted Answer

A)  .accdb 
B)  .accde 
C)  .accdc 
D)  .xls 
A)  .accdb 
B)  .accde 
C)  .accdc 
D)  .xls

Question 11

Which of the following does normalizing a database help with?

Accepted Answer

A)  increase the consistency of the data 
B)  increase the integrity of the data 
C)  minimize potential problems 
D)  all of the above 
A)  increase the consistency of the data 
B)  increase the integrity of the data 
C)  minimize potential problems 
D)  all of the above

Question 12

A database that is signed and packaged has a file extension of .accde.

Accepted Answer

A) True 
 B)False

Question 13

While not designed as a security mechanism,a customized Navigation pane can also add a degree of security and protection to the database by hiding objects you don't want users to accidentally modify.

Accepted Answer

A) True 
 B)False

Question 14

In an ERD,which of the following are the details relating to an entity?

Accepted Answer

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

Question 15

Which of the following statements about analyzing a table is not true?

Accepted Answer

A)  If you allow the Table Analyzer tool to make changes to your database,Access selects new primary keys. 
B)  If you allow the Table Analyzer tool to make changes to your database,Access creates new tables. 
C)  The Table Analyzer tool changes the original table in the database. 
D)  The Table Analyzer tool helps optimize how a table is sorted. 
A)  If you allow the Table Analyzer tool to make changes to your database,Access selects new primary keys. 
B)  If you allow the Table Analyzer tool to make changes to your database,Access creates new tables. 
C)  The Table Analyzer tool changes the original table in the database. 
D)  The Table Analyzer tool helps optimize how a table is sorted.

Question 16

To use a packaged database,the database must be extracted from the packaged file and saved as a normal ________________ database.

Accepted Answer

A)  .accdb 
B)  .accde 
C)  .accdc 
D)  .xls 
A)  .accdb 
B)  .accde 
C)  .accdc 
D)  .xls

Question 17

Why might a user decide to split a database? What is the Database Splitter tool?

Accepted Answer

Some of your databases may be designed t

Question 18

Explain what you know about the Database Documenter tool.

Accepted Answer

Access contains a Database Documenter to

Question 19

Which of the following prevents users from opening forms and reports and Design view?

Accepted Answer

A)  executable files 
B)  fewer controls 
C)  graphics 
D)  compact the database 
A)  executable files 
B)  fewer controls 
C)  graphics 
D)  compact the database

Question 20

In Access,an attribute of an entity is the same as a field of an object or table.

Accepted Answer

A) True 
 B)False

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

Which of the following does the Table Analyzer tool do if you accept the recommendation to create new tables?

In an ERD,a single line symbol indicates a one,while a crow's foot symbol indicates a many.

Which of the following is an authentication mechanism that contains identifying information about the creator?

Which of the following should you consider in order to create a strong password?

Within the text data type,a Long Text field takes longer to search than a Short Text field.

Which of the following file types the extension given to an Access executable file?

What normalization does is take smaller tables that have problems and join them together into bigger tables that no longer have problems.

Which of the following statements is true about the Database Documenter tool?

Which of the following extensions identifies a database that has been signed and packaged?

Which of the following does normalizing a database help with?

A database that is signed and packaged has a file extension of .accde.

While not designed as a security mechanism,a customized Navigation pane can also add a degree of security and protection to the database by hiding objects you don't want users to accidentally modify.

In an ERD,which of the following are the details relating to an entity?

Which of the following statements about analyzing a table is not true?

To use a packaged database,the database must be extracted from the packaged file and saved as a normal ________________ database.

Why might a user decide to split a database? What is the Database Splitter tool?

Explain what you know about the Database Documenter tool.

Which of the following prevents users from opening forms and reports and Design view?

In Access,an attribute of an entity is the same as a field of an object or table.

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

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

Which of the following does the Table Analyzer tool do if you accept the recommendation to create new tables?

In an ERD,a single line symbol indicates a one,while a crow's foot symbol indicates a many.

Which of the following is an authentication mechanism that contains identifying information about the creator?

Which of the following should you consider in order to create a strong password?

Within the text data type,a Long Text field takes longer to search than a Short Text field.

Which of the following file types the extension given to an Access executable file?

What normalization does is take smaller tables that have problems and join them together into bigger tables that no longer have problems.

Which of the following statements is true about the Database Documenter tool?

Which of the following extensions identifies a database that has been signed and packaged?

Which of the following does normalizing a database help with?

A database that is signed and packaged has a file extension of .accde.

While not designed as a security mechanism,a customized Navigation pane can also add a degree of security and protection to the database by hiding objects you don't want users to accidentally modify.

In an ERD,which of the following are the details relating to an entity?

Which of the following statements about analyzing a table is not true?

To use a packaged database,the database must be extracted from the packaged file and saved as a normal ________________ database.

Why might a user decide to split a database? What is the Database Splitter tool?

Explain what you know about the Database Documenter tool.

Which of the following prevents users from opening forms and reports and Design view?

In Access,an attribute of an entity is the same as a field of an object or table.

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