Question 1

Which of the following is the process of intentionally returning tables to a lower normal form?

Accepted Answer

A)  executable files 
B)  denormalization 
C)  graphics 
D)  compact the database 
A)  executable files 
B)  denormalization 
C)  graphics 
D)  compact the database

Question 2

To change the Navigation pane,you first open the Navigation menu and select a new category.

Accepted Answer

A) True 
 B)False

Question 3

If you allow the Table Analyzer tool to made changes to your database,the original table remains unchanged.

Accepted Answer

A) True 
 B)False

Question 4

In the Navigation pane,what is the procedure for opening an object's shortcut menu?

Accepted Answer

A)  click the object 
B)  double-click the object 
C)  right-click the object 
D)  both B and C 
A)  click the object 
B)  double-click the object 
C)  right-click the object 
D)  both B and C

Question 5

In an ERD,which of the following indicates mandatory or required 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 6

What types of problems are common to poorly designed databases? What is normalization and why is it important to know about it?

Accepted Answer

If you have followed the steps of databa

Question 7

Which of the following requires that a table be in 2NF and all non-key fields must depend only on the 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 8

Which of the following converts data into a coded format that can't be understood unless it is decoded?

Accepted Answer

A)  creating a digital certificate 
B)  locking the database 
C)  packaging and signing a database 
D)  encryption 
A)  creating a digital certificate 
B)  locking the database 
C)  packaging and signing a database 
D)  encryption

Question 9

Normalization involves evaluating a table against a series of rules to ensure that all of the fields describe only the entity represented in the table.

Accepted Answer

A) True 
 B)False

Question 10

When customizing the Navigation pane,which of the following might you need to delete at some point?

Accepted Answer

A)  custom categories 
B)  groups and objects 
C)  shortcuts 
D)  all of the above 
A)  custom categories 
B)  groups and objects 
C)  shortcuts 
D)  all of the above

Question 11

Which of the following modes of opening a database allows shared use to see,but not change,any data in the database?

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 12

Which of the following is true about Entity-Relationship Diagrams,or ERDs?

Accepted Answer

A)  An ERD is created during the database design process. 
B)  An ERD can help you organize the information collected about the business needs. 
C)  An ERD is a useful tool to review with database users. 
D)  all of the above 
A)  An ERD is created during the database design process. 
B)  An ERD can help you organize the information collected about the business needs. 
C)  An ERD is a useful tool to review with database users. 
D)  all of the above

Question 13

Which of the following are considerations when using passwords to protect a database?

Accepted Answer

A)  You may need to remove a password assigned to a database. 
B)  You may need to periodically change a password. 
C)  Some companies have policies that establish the frequency with which you must change a password. 
D)  all of the above 
A)  You may need to remove a password assigned to a database. 
B)  You may need to periodically change a password. 
C)  Some companies have policies that establish the frequency with which you must change a password. 
D)  all of the above

Question 14

If you are working with Short Text fields,be sure to change the default size from 255 to a number that better matches the needs of your data.

Accepted Answer

A) True 
 B)False

Question 15

Access implements encryption through password protection.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following tools allows you to view and print general information as well as detailed data about the characteristics of objects in your 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 17

Which of the following is the equivalent of an electronic stamp?

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 18

It is possible to export the report created by the Database Documenter tool to a PDF file or other format including Excel,Text File,Email,Word,or HTML.

Accepted Answer

A) True 
 B)False

Question 19

In order for a database to be relational,one of the requirements is that the columns of the table must represent records.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following tools helps you determine if a table is well designed?

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

Which of the following is the process of intentionally returning tables to a lower normal form?

To change the Navigation pane,you first open the Navigation menu and select a new category.

If you allow the Table Analyzer tool to made changes to your database,the original table remains unchanged.

In the Navigation pane,what is the procedure for opening an object's shortcut menu?

In an ERD,which of the following indicates mandatory or required participation?

What types of problems are common to poorly designed databases? What is normalization and why is it important to know about it?

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

Which of the following converts data into a coded format that can't be understood unless it is decoded?

Normalization involves evaluating a table against a series of rules to ensure that all of the fields describe only the entity represented in the table.

When customizing the Navigation pane,which of the following might you need to delete at some point?

Which of the following modes of opening a database allows shared use to see,but not change,any data in the database?

Which of the following is true about Entity-Relationship Diagrams,or ERDs?

Which of the following are considerations when using passwords to protect a database?

If you are working with Short Text fields,be sure to change the default size from 255 to a number that better matches the needs of your data.

Access implements encryption through password protection.

Which of the following tools allows you to view and print general information as well as detailed data about the characteristics of objects in your database?

Which of the following is the equivalent of an electronic stamp?

It is possible to export the report created by the Database Documenter tool to a PDF file or other format including Excel,Text File,Email,Word,or HTML.

In order for a database to be relational,one of the requirements is that the columns of the table must represent records.

Which of the following tools helps you determine if a table is well designed?

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 process of intentionally returning tables to a lower normal form?

To change the Navigation pane,you first open the Navigation menu and select a new category.

If you allow the Table Analyzer tool to made changes to your database,the original table remains unchanged.

In the Navigation pane,what is the procedure for opening an object's shortcut menu?

In an ERD,which of the following indicates mandatory or required participation?

What types of problems are common to poorly designed databases? What is normalization and why is it important to know about it?

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

Which of the following converts data into a coded format that can't be understood unless it is decoded?

Normalization involves evaluating a table against a series of rules to ensure that all of the fields describe only the entity represented in the table.

When customizing the Navigation pane,which of the following might you need to delete at some point?

Which of the following modes of opening a database allows shared use to see,but not change,any data in the database?

Which of the following is true about Entity-Relationship Diagrams,or ERDs?

Which of the following are considerations when using passwords to protect a database?

If you are working with Short Text fields,be sure to change the default size from 255 to a number that better matches the needs of your data.

Access implements encryption through password protection.

Which of the following tools allows you to view and print general information as well as detailed data about the characteristics of objects in your database?

Which of the following is the equivalent of an electronic stamp?

It is possible to export the report created by the Database Documenter tool to a PDF file or other format including Excel,Text File,Email,Word,or HTML.

In order for a database to be relational,one of the requirements is that the columns of the table must represent records.

Which of the following tools helps you determine if a table is well designed?

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