Deck 3: Tables and Queries in Relational Databases

Question 1

How many characters can be stored in a field with a Short Text data type?

A)100
B)255
C)500
D)256

Answer 1

B

Question 2

What data type assigns the next consecutive number to new records?

A)Number
B)AutoNumber
C)IncreaseNumber
D)Integer

Answer 2

B

Question 3

What field property increases the speed at which searches can be performed?

A)Indexed
B)Allow Zero Length
C)Required
D)Result Type

Answer 3

A

Question 4

What field property forces data to follow certain rules of data entry?

A)Validation Rule
B)Validation Text
C)Format
D)Required

Question 5

When does the validation rule check the entered data?

A)As soon as it is typed into the field
B)When the user exits the field
C)When the table or form is saved
D)When the table of form is closed

Question 6

What field property would allow the user to enter two quote marks with nothing between them ("")into a field with a Short Text data type?

A)Required
B)Indexed
C)Allow Zero Length
D)Allow Null Length

Question 7

What field property makes up for the limitation of the field naming rules or common practices?

A)Validation Rule
B)Input Mask
C)Format
D)Caption

Question 8

What is not true about the hyperlink data type?

A)It can store the URL for a web page.
B)It can store the path to a file.
C)The hyperlink becomes active anytime you hover over it.
D)It can store the path to a folder.

Question 9

What is not true about data types?

A)It is best to choose Short Text for all fields at first,because they can easily be changed later.
B)Every field is assigned a data type.
C)They determine what operations can be performed on the data.
D)They can be changed after the table has been created.

Question 10

What is the suggested data type for a street address?

A)Long Text
B)Number
C)OLE Object
D)Short Text

Question 11

What option automatically deletes records in related tables that match the primary key?

A)Autodelete Related Records
B)Cascade Update Related Fields
C)Cascade Delete Related Records
D)Delete and Update Related Records

Question 12

If you want the results of a query to display only those records that meet all criteria,you would use the ________ operator.

A)OR
B)NOT
C)AND
D)NOR

Question 13

What field property insures that all phone numbers have a consistent look?

A)Caption
B)Format
C)Default Value
D)Input Mask

Question 14

What is not true about field names?

A)They can be up to 64 characters in length.
B)They should describe the data they will store.
C)They can contain numbers.
D)They can begin with a space.

Question 15

Storing a book's title in more than one table within a database is considered data ________.

A)backup
B)redundancy
C)duplication
D)consistency

Question 16

What field property would you use to automatically enter "PA" in a state field?

A)Format
B)Caption
C)Default Value
D)Start Value

Question 17

How many characters can be stored in a field with a Long Text data type?

A)1,000
B)12,256
C)Unlimited
D)64,000

Question 18

What is not true about the Caption property?

A)It allows labels to be more readable than field names.
B)It displays at the column head instead of the field name.
C)It is used in both forms and reports.
D)The Pascal case is preferred in this property.

Question 19

"lastName" is an example of ________.

A)Camel case
B)Pascal case
C)a typing error
D)a naming convention that is not recommended because of possible compatibility issues

Question 20

What is not one of the six guidelines for designing tables?

A)Store data in as large of number of parts as possible
B)Determine the primary keys
C)Link the tables on related fields
D)Think of what needs you might have in the future

Question 21

When you import data,where can you not store it?

A)New form
B)New table
C)Existing table
D)Linked table

Question 22

If you wanted the user to pick from a particular list,what would you pick from the data type drop down list for that field?

A)List
B)Short Text
C)Lookup Wizard
D)Long Text

Question 23

A good way to know what fields you will need is to think of what reports you might need later.

Question 24

Which wildcard character matches a single character in the same position as the wildcard?

A)?
B)*
C)[]
D)[!]

Question 25

Which of the following cannot be imported from one Access database into another Access database?

A)Tables
B)Sheets
C)Forms
D)Reports

Question 26

Which field property helps a user know why an entry error was generated?

A)Validation Text
B)Validation Rule
C)Expression
D)Error Code

Question 27

Enforcing referential integrity assures that ________.

A)you cannot enter a value in the foreign key if there is no corresponding value in the primary key
B)you cannot enter the same value in the foreign key of the same table
C)you cannot leave that field empty
D)you cannot enter invalid or incorrect information

Question 28

What is the most common relationship type?

A)Many-to-many
B)One-to-many
C)One-to-one
D)None-to-none (finds records with no matching primary and foreign keys)

Question 29

When you purchase from a store several times this would be an example of what kind of table relationship?

A)Many-to-one (many customers - one purchase)
B)One-to-one (one customer - one store)
C)Many-to-many (many items purchased - many times)
D)One-to-many (one customer - many purchases)

Question 30

Which of the following comparison operators is not valid?

A)<>
B)>=
C)=>
D)<

Question 31

To limit the number of records displayed when a query is run you add ________.

A)sorting
B)criteria
C)less fields
D)less tables

Question 32

Which option would this wildcard,"H[!oe]" not display?

A)House
B)Hat
C)His
D)Humming

Question 33

Which logical operator would return the fewest records?

A)AND
B)OR
C)NOT
D)NOR

Question 34

Which of the following is not a way to create a multitable query?

A)Modifying an existing query
B)Using the Query Wizard
C)Adding a table in the Relationships window
D)Creating a query from scratch

Question 35

What field property helps to make sure that correct data is entered?

A)Validation text
B)Validation rule
C)Format
D)Required

Question 36

The ________ property provides literal characters that are typed for each entry.

A)Validation Rule
B)Default Value
C)Validation text
D)Input Mask

Question 37

Checking the Cascade Delete Related Records checkbox assures that ________.

A)you cannot delete related records if they have more than one foreign key records
B)you cannot delete a primary key record if it has related records
C)all records will be deleted in related tables if you delete the primary key in the primary table
D)all primary keys will be deleted if you delete related records

Question 38

When you run a query,it displays in what view?

A)Design
B)Layout
C)Print Preview
D)Datasheet

Question 39

If you add a table with 10 records to a query and add an unrelated table with 4 records to the same query,how many records will display when you run the query?

A)40
B)10
C)4
D)0 (since the tables are not related)

Question 40

Which of the following would make a good primary key?

A)AutoNumber data type
B)Customer name
C)Number data type
D)Birthday

Question 41

You can only have one primary key in a table,but you can have several foreign keys.

Question 42

Although you can create calculated fields in a query,most prefer to add them the table instead.

Question 43

The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

Question 44

The AND operator will give you the most results in a query.

Question 45

Logical operators only work with text and numbers,not dates.

Question 46

Access does not require that every table has a primary key.

Question 47

Access requires that common fields be named exactly the same.

Question 48

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

Question 49

A database designer needs to be concerned about what fields might be needed rather than file size.

Question 50

For security purposes you want to have data redundancy in your tables.

Question 51

Access provides a wizard for easily importing Excel data into Access.

Question 52

The primary key can only be a single field.

Question 53

In a query,the sort order,when sorting on multiple fields,is determined by the field order from left to right.

Question 54

Although you can link to external data,it is not recommended.

Question 55

It is best to copy a query if you need a similar query,but with different criteria,rather than to start from scratch.

Question 56

The Enforce Referential Integrity box should normally be checked.

Question 57

Data entered in a query is actually stored in the underlying table(s).

Question 58

The first step in creating a query is selecting the fields you need.

Question 59

There might be times when you want to add the same field to a query several times.

Question 60

It is best when designing a query to add all the fields from a table in case you need them later.

Question 61

It is safe to change data in a query since you are only changing a temporary copy of the data,not the underlying data in the table.

Question 62

Use the ________ data type if you need to store a True or False value.

Question 63

You should store data in their ________ parts.

Question 64

Storing duplicate data in more than one table is called data ________.

Question 65

Text you add to the criteria row in a query is case sensitive,so be careful or you may get unexpected results.

Question 66

You can save time and help prevent errors when you ________ data from an external source.

Question 67

When creating a multitable query from scratch only include related tables in your query.

Question 68

When you need a query to return entries based on any of a set of criteria,then you would use the ________ condition.

Question 69

Use the ________ data type when you want to store multiple pictures in your records.

Question 70

Multitable queries inherit their relationships and you cannot change those in the query.You need to open the Relationships window to make any changes.

Question 71

A field's ________ determine how that field functions.

Question 72

In table relationships,the foreign key of one table cannot be joined to the ________ key of another table.

Question 73

The ________ key is what guarantees that a record is unique.

Question 74

You cannot create a relationship between two tables unless there is at least one ________ key.

Question 75

The ________ field type makes a good primary key.

Question 76

Having common fields is important when you begin to build ________ between the tables.

Question 77

To have your table perform mathematical functions automatically you would use a ________ field.

Question 78

Use the ________ data type when you do not know how much text space will be required.

Question 79

Access uses ________ to speed up the sorting or filtering process.

Question 80

The ________ relationship is used when joining two primary keys.