Question 1

If a table is in 2NF and has only one non-key field,the table is automatically in 3NF.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is a benefit of splitting a database?

Accepted Answer

A)  improved performance 
B)  customized front-ends for different users 
C)  increased security and protection 
D)  all of the above 
A)  improved performance 
B)  customized front-ends for different users 
C)  increased security and protection 
D)  all of the above

Question 3

Which of the following tools analyzes objects in the database and suggests potential solutions to improve the operation of the 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 4

It is a good idea to back up your database before optimizing it.

Accepted Answer

A) True 
 B)False

Question 5

What is the Performance Analyzer tool and how is it used?

Accepted Answer

Access includes a Performance Analyzer t

Question 6

If you hide an object,the shortcuts that reference that object aren't automatically hidden.

Accepted Answer

A) True 
 B)False

Question 7

Text data types process more quickly than number data types.

Accepted Answer

A) True 
 B)False

Question 8

When normalizing a database,what is the name for the series of rules that a table is evaluated against to ensure that all of the fields describe only the entity represented in the table?

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 9

If a table is in 1NF and only has one field in the primary key,it automatically is in 2NF.

Accepted Answer

A) True 
 B)False

Question 10

In ERD terminology,which of the following specifies whether an entity must participate in the relationship or not?

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 11

When you open a form,report,or query,which of the following does the front-end database link to?

Accepted Answer

A)  back-end database 
B)  front-end database 
C)  query 
D)  form or report 
A)  back-end database 
B)  front-end database 
C)  query 
D)  form or report

Question 12

Which of the following is a common problem that you might find in a poorly designed table?

Accepted Answer

A)  having redundant data 
B)  having more than one value stored in a field 
C)  not having the ability to store the required data 
D)  all of the above 
A)  having redundant data 
B)  having more than one value stored in a field 
C)  not having the ability to store the required data 
D)  all of the above

Question 13

Which of the following contains the database tables?

Accepted Answer

A)  back-end database 
B)  front-end database 
C)  query 
D)  form or report 
A)  back-end database 
B)  front-end database 
C)  query 
D)  form or report

Question 14

Which of the following describes a table that is in 1NF and only has one field in the primary key?

Accepted Answer

A)  1NF 
B)  2NF 
C)  3NF 
D)  none of the above 
A)  1NF 
B)  2NF 
C)  3NF 
D)  none of the above

Question 15

Explain what you know about packaging and signing a database.

Accepted Answer

Once you have completed your database,yo

Question 16

Which of the following modes of opening a database permits only the person opening the database to have the database open?

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 17

Access includes a Database Splitter tool that analyzes objects in the database and suggests potential solutions to improve performance.

Accepted Answer

A) True 
 B)False

Question 18

In order for a database to be relational,one of the requirements is that each row must have a primary key able to uniquely identify one record from another.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is the maximum number of characters that can be stored in text field?

Accepted Answer

A)  25 characters 
B)  55 characters 
C)  155 characters 
D)  255 characters 
A)  25 characters 
B)  55 characters 
C)  155 characters 
D)  255 characters

Question 20

Which of the following statements is true about customizing the Navigation pane?

Accepted Answer

A)  By default,the objects in the Navigation pane are grouped by the type of object. 
B)  You can customize the Navigation pane to make a database more efficient for the users. 
C)  To customize the Navigation pane,you first create categories and groups that reflect the needs of the user. 
D)  all of the above 
A)  By default,the objects in the Navigation pane are grouped by the type of object. 
B)  You can customize the Navigation pane to make a database more efficient for the users. 
C)  To customize the Navigation pane,you first create categories and groups that reflect the needs of the user. 
D)  all of the above

If a table is in 2NF and has only one non-key field,the table is automatically in 3NF.

Which of the following is a benefit of splitting a database?

Which of the following tools analyzes objects in the database and suggests potential solutions to improve the operation of the database?

It is a good idea to back up your database before optimizing it.

What is the Performance Analyzer tool and how is it used?

If you hide an object,the shortcuts that reference that object aren't automatically hidden.

Text data types process more quickly than number data types.

When normalizing a database,what is the name for the series of rules that a table is evaluated against to ensure that all of the fields describe only the entity represented in the table?

If a table is in 1NF and only has one field in the primary key,it automatically is in 2NF.

In ERD terminology,which of the following specifies whether an entity must participate in the relationship or not?

When you open a form,report,or query,which of the following does the front-end database link to?

Which of the following is a common problem that you might find in a poorly designed table?

Which of the following contains the database tables?

Which of the following describes a table that is in 1NF and only has one field in the primary key?

Explain what you know about packaging and signing a database.

Which of the following modes of opening a database permits only the person opening the database to have the database open?

Access includes a Database Splitter tool that analyzes objects in the database and suggests potential solutions to improve performance.

In order for a database to be relational,one of the requirements is that each row must have a primary key able to uniquely identify one record from another.

Which of the following is the maximum number of characters that can be stored in text field?

Which of the following statements is true about customizing the Navigation pane?

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

If a table is in 2NF and has only one non-key field,the table is automatically in 3NF.

Which of the following is a benefit of splitting a database?

Which of the following tools analyzes objects in the database and suggests potential solutions to improve the operation of the database?

It is a good idea to back up your database before optimizing it.

What is the Performance Analyzer tool and how is it used?

If you hide an object,the shortcuts that reference that object aren't automatically hidden.

Text data types process more quickly than number data types.

When normalizing a database,what is the name for the series of rules that a table is evaluated against to ensure that all of the fields describe only the entity represented in the table?

If a table is in 1NF and only has one field in the primary key,it automatically is in 2NF.

In ERD terminology,which of the following specifies whether an entity must participate in the relationship or not?

When you open a form,report,or query,which of the following does the front-end database link to?

Which of the following is a common problem that you might find in a poorly designed table?

Which of the following contains the database tables?

Which of the following describes a table that is in 1NF and only has one field in the primary key?

Explain what you know about packaging and signing a database.

Which of the following modes of opening a database permits only the person opening the database to have the database open?

Access includes a Database Splitter tool that analyzes objects in the database and suggests potential solutions to improve performance.

In order for a database to be relational,one of the requirements is that each row must have a primary key able to uniquely identify one record from another.

Which of the following is the maximum number of characters that can be stored in text field?

Which of the following statements is true about customizing the Navigation pane?

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