Using Design View, Data Validation, And Relationships

This question bank verified by Studydeets

Questions Bank

Creating a Database and Tables
Using Design View, Data Validation, and Relationships
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

All Questions

Question 1

Free

True/False

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

Choose correct answer/s

True

False

Check answer

Question 2

Free

True/False

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

Choose correct answer/s

True

False

Check answer

Question 3

Free

True/False

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

Choose correct answer/s

True

False

Check answer

Question 4

Free

True/False

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

Choose correct answer/s

True

False

Check answer

Question 5

Free

True/False

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.

Choose correct answer/s

True

False

Check answer

Question 6

True/False

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.

Choose correct answer/s

True

False

To unlock the question

Question 7

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 8

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 9

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 10

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 11

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 12

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 13

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 14

True/False

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.

Choose correct answer/s

True

False

To unlock the question

Question 15

True/False

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.

Choose correct answer/s

True

False

To unlock the question

Question 16

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 17

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 18

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 19

True/False

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

Choose correct answer/s

True

False

To unlock the question

Question 20

True/False

Text data types process more quickly than number data types.

Choose correct answer/s

True

False

To unlock the question