Designing And Managing Databases

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

New tables always open in Design view.

Choose correct answer/s

True

False

Check answer

Question 2

Free

True/False

New tables do not contain any fields.

Choose correct answer/s

True

False

Check answer

Question 3

Free

True/False

When you add a new field,you must give the field a name,but you do not have to assign a data type.

Choose correct answer/s

True

False

Check answer

Question 4

Free

True/False

Field names must be unique and are limited to 32 characters.

Choose correct answer/s

True

False

Check answer

Question 5

Free

True/False

Before adding a new field between an existing field in a table,you must insert a new row.

Choose correct answer/s

True

False

Check answer

Question 6

True/False

When you insert a new row between fields,the new row is inserted below the selected field.

Choose correct answer/s

True

False

To unlock the question

Question 7

True/False

A primary key is a field that contains a unique value for each record.

Choose correct answer/s

True

False

To unlock the question

Question 8

True/False

Design view is used to enter records into a table.

Choose correct answer/s

True

False

To unlock the question

Question 9

True/False

When you make changes to field properties,you must save the table for the changes to be permanent.

Choose correct answer/s

True

False

To unlock the question

Question 10

True/False

A Short Text field can have a size from 0-50.

Choose correct answer/s

True

False

To unlock the question

Question 11

True/False

A number field can have seven possible field sizes depending on the number data type.

Choose correct answer/s

True

False

To unlock the question

Question 12

True/False

The Format property indicates the way a field displays in a table; it doesn't change what is actually stored.

Choose correct answer/s

True

False

To unlock the question

Question 13

True/False

If you don't select a format,Access uses the Currency format for a number field.

Choose correct answer/s

True

False

To unlock the question

Question 14

True/False

If a field must have a value you should set the Required property to Yes.

Choose correct answer/s

True

False

To unlock the question

Question 15

True/False

The process of verifying the accuracy,or integrity,of data is known as data integrity.

Choose correct answer/s

True

False

To unlock the question

Question 16

True/False

Data integrity rules are included as part of the metadata,the descriptions about what the different data fields represent and their formats.

Choose correct answer/s

True

False

To unlock the question

Question 17

True/False

One of the key advantages to a database is that the DBMS automatically uses the metadata for the data integrity rules to perform data validation.

Choose correct answer/s

True

False

To unlock the question

Question 18

True/False

It is possible to create validation rules in Design view,but not in Datasheet view.

Choose correct answer/s

True

False

To unlock the question

Question 19

True/False

Access checks field validation rules when a user navigates out of a field.

Choose correct answer/s

True

False

To unlock the question

Question 20

True/False

Expressions written for a record validation rule cannot use the same operators and wildcard characters used in field level validation rules.

Choose correct answer/s

True

False

To unlock the question