Deck 9: Designing and Managing Databases

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

New tables do not contain any fields.

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

You can add a new table into a database from the Create tab.

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

New tables always open in Design view.

Question 17

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.

Question 18

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

Question 19

Design view is used to enter records into a table.

Question 20

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

Question 21

It is possible to import data from an Excel file into an Access table.

Question 22

Which of the following must you do before adding a field between existing fields?

A) enter a field name
B) enter a data type
C) select a primary key
D) insert a new row

Question 23

When data is entered that violates a validation rule,Access automatically displays a message box alerting the user to the problem.

Question 24

Which of the following number data types stores numbers from 0 to 255?

A) Byte
B) Integer
C) Long Integer
D) Decimal

Question 25

Which of the following properties indicates the way a field displays in a table?

A) Format property
B) Lookup property
C) Required property
D) Caption property

Question 26

Which of the following number data types stores numbers from -32,768 to 32,767?

A) Byte
B) Integer
C) Long Integer
D) Decimal

Question 27

Which of the following number data types stores numbers from -10< sup >28< / sup > to 10< sup >28< / sup > with a precision of 28 significant digits?

A) Byte
B) Integer
C) Long Integer
D) Decimal

Question 28

When using validation rules it is important that the rules are tested.

Question 29

Which of the following characters causes characters to display in lowercase in a short text and long text field?

A) <
B) >
C) @
D) [color]

Question 30

Which of the following contains a unique value for each record?

A) primary key
B) lookup field
C) input mask
D) metadata

Question 31

An input mask forces a user to enter data using a specific format.

Question 32

Lookup fields allow the user to type a value into a field.

Question 33

One-to-many is the only type of relationship that may exist between tables in a database.

Question 34

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

Question 35

Which of the following should you use to create a table from scratch?

A) Datasheet view
B) Design view
C) Lookup view
D) Validation view

Question 36

Which of the following is used to enter records into a table?

A) Datasheet view
B) Design view
C) Lookup view
D) Validation view

Question 37

An input mask only displays when a user clicks into that field.

Question 38

Access tables can be printed in a portrait orientation,but not in a landscape orientation.

Question 39

The notation 1:1 is used to describe the one-to-many relationship.

Question 40

Which of the following characters causes characters to display in uppercase in a short text and long text field?

A) <
B) >
C) @
D) [color]

Question 41

Which of the following record validation rules requires the user to enter a value into either Field1 or Field2,but not into both fields?

A) ([Field1] is Null)XOR ([Field2] is Null)
B) [Field1] < > [Field2]
C) (([Field1] > [Field2])AND [Field2] >10))
D) none of the above

Question 42

Which of the following field validation rules requires the user to enter a value that is less than 5?

A) < 5
B) < > 0
C) "M" or "F"
D) Not Null

Question 43

Which of the following field validation rules requires the user to fill in a field?

A) < 5
B) < > 0
C) "M" or "F"
D) Not Null

Question 44

In Access,what are field validation rules called?

A) input masks
B) expressions
C) metadata
D) foreign keys

Question 45

What does Access do when data is entered that violates a validation rule?

A) displays the Lookup tab
B) zooms in on the error
C) switches to datasheet view
D) displays a message box

Question 46

Which of the following wildcard characters does Access use in validation rules to match any single numeric digit?

A) ?
B) *
C) #
D) $

Question 47

Which of the following wildcard characters does Access use in validation rules to match any single character,which also includes numbers?

A) ?
B) *
C) #
D) $

Question 48

Which of the following forces a user to enter data using a specific format?

A) Lookup field
B) text box
C) input mask
D) combo box

Question 49

Which of the following properties contains the text that displays in the column header to identify a field in Datasheet view?

A) Format property
B) Lookup property
C) Default Value property
D) Caption property

Question 50

Which of the following displays a list of data values from which the user can choose?

A) Lookup field
B) text box
C) input mask
D) combo box

Question 51

Which of the following displays the contents of a field and also allows the user to type in a value into that field?

A) Lookup field
B) text box
C) input mask
D) combo box

Question 52

Which of the following displays a drop-down list in both table view and form view when the field's arrow is clicked?

A) Lookup field
B) text box
C) input mask
D) combo box

Question 53

Which of the following record validation rules requires the user to enter a value into Field1 that is greater than Field2,and Field2 must have a value greater than 10?

A) ([Field1] is Null)XOR ([Field2] is Null)
B) [Field1] < > [Field2]
C) (([Field1] > [Field2])AND [Field2] >10))
D) none of the above

Question 54

Which of the following wildcard characters does Access use in validation rules to match any number of characters?

A) ?
B) *
C) #
D) $

Question 55

Which of the following record validation rules prevents the user from entering the same value into both Field1 and Field2?

A) ([Field1] is Null)XOR ([Field2] is Null)
B) [Field1] < > [Field2]
C) (([Field1] > [Field2])AND [Field2] >10))
D) none of the above

Question 56

Which of the following refers to the process of verifying the accuracy,or integrity,of data?

A) data validation
B) metadata testing
C) data integrity testing
D) relationship testing

Question 57

Which of the following properties automatically inserts a specified value into a new record in a table?

A) Format property
B) Lookup property
C) Default Value property
D) Caption property

Question 58

How does Access store a Yes response for the Yes/ No data type?

A) -2
B) -1
C) 0
D) 1

Question 59

When using wildcards in validation rules,which of the following must surround the criteria of your expression?

A) &
B) ( )
C) " "
D) !

Question 60

Which of the following field validation rules prevents the user from typing 0 into a field?

A) < 5
B) < > 0
C) "M" or "F"
D) Not Null

Question 61

What is a primary key called that is made up of more than one field?

A) primary key
B) foreign key
C) concatenated key
D) combined key

Question 62

Which of the following input mask characters requires a user to enter a letter?

A) 0
B) L
C) A
D) a

Question 63

In Access,which of the following indicates the many sides of a relationship?

A) foreign key
B) infinity symbol
C) metadata
D) many symbol

Question 64

Which of the following ensures that records in associated tables have consistent data?

A) referential integrity
B) primary key
C) foreign key
D) Compact & Repair utility

Question 65

In what is data in a relational database system organized?

A) fields
B) records
C) tables
D) Design view

Question 66

What must you do if you create a relationship in error?

A) print it
B) save it
C) copy it
D) delete it

Question 67

Which of the following relationships describes one row of data in Table A being associated with only one row of data in Table B?

A) one-to-one
B) one-to-many
C) many-to-many
D) none of the above
In a one-to-one relationship,one row of data in Table A is associated with only one row of data in Table

Question 68

How many parts are there in an input mask?

A) 1
B) 3
C) 5
D) 7

Question 69

What can you do if the data records that you want to use in Access are stored in another file?

A) copy them
B) cut them
C) paste them
D) import them

Question 70

Which of the following characters separates the parts of an input mask?

A) #
B) $
C) ;
D) [ ]

Question 71

Which of the following print options allows you to select different print options before sending the contents of the current object immediately to the printer?

A) Quick Print
B) Print
C) Print Preview
D) none of the above

Question 72

In Access,which of the following is used to relate,or connect,tables?

A) field
B) record
C) table
D) metadata

Question 73

What is a table called that matches up the records across two other tables?

A) foreign table
B) joining table
C) infinity table
D) junction table

Question 74

Which of the following input mask characters requires a user to enter a number?

A) 0
B) L
C) A
D) a

Question 75

Which of the following input mask characters requires a user to enter a letter or a number?

A) 0
B) L
C) A
D) a

Question 76

Which of the following print options should you use to check that the formatting of a table is appropriate and to make changes to any settings before printing?

A) Quick Print
B) Print
C) Print Preview
D) none of the above

Question 77

Which of the following relationships describes many rows of data in Table A associated with many rows of data in Table B?

A) one-to-one
B) one-to-many
C) many-to-many
D) none of the above
In a many-to-many relationship,many rows of data in Table A are associated with many rows of data in Table

Question 78

Which of the following print options sends the contents of the current object immediately to the printer?

A) Quick Print
B) Print
C) Print Preview
D) none of the above

Question 79

What must you do if you make any changes to the relationships between tables?

A) print them
B) save them
C) copy them
D) delete them

Question 80

Which of the following relationships describes one row of data in Table A associated with many rows of data in Table B?

A) one-to-one
B) one-to-many
C) many-to-many
D) none of the above
In a one-to-many relationship,one row of data in Table A is associated with many rows of data in Table