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

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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.

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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.

Question 14

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

Question 15

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

Question 16

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

Question 17

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.

Question 18

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

Question 19

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

Question 20

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.

Question 21

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

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 22

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

Question 23

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

Question 24

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?

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

Question 25

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.

Question 26

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

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

Question 27

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

Question 28

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

Question 29

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

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

Question 30

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

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

Question 31

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

Question 32

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

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

Question 33

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

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

Question 34

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

Question 35

Access implements encryption through password protection.

Question 36

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

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

Question 37

Passwords are not case sensitive.

Question 38

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

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

Question 39

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

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

Question 40

Text data types process more quickly than number data types.

Question 41

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?

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

Question 42

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?

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

Question 43

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

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 44

Which of the following does normalizing a database help with?

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

Question 45

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

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 46

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

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

Question 47

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

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

Question 48

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

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

Question 49

What does the process of normalization involve?

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 50

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

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

Question 51

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

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

Question 52

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

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

Question 53

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

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 54

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?

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

Question 55

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

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

Question 56

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

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 57

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

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 58

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

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

Question 59

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

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

Question 60

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

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

Question 61

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

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

Question 62

In Access,which of the following processes the slowest?

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

Question 63

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

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

Question 64

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

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

Question 65

Which of the following helps a database to run faster?

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

Question 66

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

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

Question 67

What types of solutions does the Performance Analyzer tool provide?

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

Question 68

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

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

Question 69

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

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

Question 70

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

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

Question 71

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

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

Question 72

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

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

Question 73

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

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 74

In Access,which of the following processes the fastest?

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

Question 75

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

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

Question 76

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

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

Question 77

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

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

Question 78

Which of the following contains the database tables?

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

Question 79

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

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

Question 80

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

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