Deck 16: Completing a Database Application

Question 1

One of the best ways to teach yourself advanced database skills is to study a well-developed database.

Answer 1

True

Question 2

Any form can act as a startup switchboard form.

Answer 2

True

Question 3

To move a field list, drag its title bar.

Answer 3

True

Question 4

The Caption property keeps track of the order of the values in an indexed field.

Question 5

A normalized database simplifies overall database maintenance.

Question 6

The Lookup Report is a valuable tool when creating other objects in the database.

Question 7

You should always try to create databases that use 1NF normalization rules. _________________________

Question 8

If you often sort on a field, its Indexed property should be set to Yes.

Question 9

First normal form means that redundant data in the original table is extracted, placed in a new table, and related to the original table. _________________________

Question 10

A table's Property Sheet controls characteristics for the entire table object.

Question 11

Press the [F11] key to open the Navigation Pane.

Question 12

A right outer join is useful in finding orphan records.

Question 13

A subquery is often used when you need to summarize a group of records and use that results in another query.

Question 14

The "one" table in a relationship is also called the parent table.

Question 15

A normalized database increases redundant data.

Question 16

The Allow Multiple Values property is found on the Lookup tab in Table Design View.

Question 17

You query for zero-length strings using Is Null criteria. _________________________

Question 18

A switchboard form can have a a maximum of 100 command buttons, labels, or other controls.

Question 19

The Append Only property of the Long Text field is available for all Access databases, regardless of which version of Access you are using.

Question 20

For full access to all of the properties for a field, work in Table Datasheet View.

Question 21

First normal form refers to ____.

A) redundant data in an original table that is extracted, placed in a new table, and related to the first table
B) derived fields that are removed
C) a 2-dimensional table with rows and columns
D) calculated fields that are removed

Question 22

A ____ relationship cannot be created directly between two tables in Access.

A) one-to-one
B) one-to-many
C) many-to-many
D) all three types can be directly created with two tables in Access

Question 23

You should strive to create databases that use ____ rules for normalization.

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

Question 24

Use Variable Text fields when you need to store more than 256 characters in a field. ____________________

Question 25

A switchback form is a special form used to help users navigate throughout the rest of the database.

Question 26

A normalized database decreases ____.

A) the ability to create reports
B) database performance (speed)
C) the ability to create queries
D) inaccurate data

Question 27

Normalizing data means ____.

A) analyzing database performance
B) structuring it for a relational database
C) creating clear and logical data entry forms
D) repeating data between two tables

Question 28

A right join is the default join between two tables in an Access query. _________________________

Question 29

When you use the LookupWizard, you create both a one-to-many relationship and entity integrity. ____________________

Question 30

The Allow Multiple Values property is found on the _____tab in Table Design View.

A) Lookup
B) Field Properties
C) Data Type
D) List Box

Question 31

Checking the Cascade Delete Related Fields check box means that if you delete a record in the table on the "one" side of a one-to-many relationship, all related records in the "many" table automatically delete as well. ____________________

Question 32

Use the Rich Text field data type when you need to store more than 256 characters in a field. _________________________

Question 33

Press and hold the [ Ctrl ] key while opening a database to bypass the startup options. ____________________

Question 34

Northwind is provided by Microsoft as a(n) ____.

A) Help screen
B) attachment field
C) sample database template
D) online tutorial

Question 35

Use Is Empty criteria in a query to select records where there is no entry in a field. _________________________

Question 36

Two tables have a ____ relationship when they are both related to the same intermediate table with one-to-many relationships.

A) one-to-one
B) one-to-many
C) many-to-one
D) many-to-many

Question 37

With join operations " right " always refers to the "one" table of a one-to-many relationship. ____________________

Question 38

Checking the Automatically Update Related Fields check box means that if you change the primary key field value in the table on the "one" side of a one-to-many relationship, all foreign key values in the "many" table automatically update as well. ____________________

Question 39

Second normal form means ____.

A) calculated fields are removed
B) redundant data is extracted into a new table
C) totals are removed
D) a single table with rows and columns

Question 40

The default join type for a query with two tables in a one-to-many relationship is the outer join. _________________________

Question 41

A text field allows you to calculate a(n) ____ statistic in the Totals cell.

A) Average
B) Sum
C) Count
D) All of the above

Question 42

The _____ Builder helps you with the syntax to enter complex criterion

A) Expression
B) Criterion
C) Syntax
D) Rules

Question 43

The ____ property, when set to Yes, allows you to add data to a Long Text field, but not change or remove existing data.

A) Paste Structure Only
B) Paste Structure and Data
C) Append Only
D) Append

Question 44

To add a total to a datasheet column, click the Totals button in the _____ group on the Home tab.

A) Record
B) Data
C) Properties
D) Sort & Filter

Question 45

The Lookup Wizard creates a one-to-____________________ relationship.

Question 46

What is positioned in the right side of the Field Properties pane?

A) The field list
B) The last property value choice you made
C) The Lookup Wizard
D) A description of the current property

Question 47

A numeric field allows you to calculate a(n) ____ statistic in the Totals cell.

A) Average
B) Sum
C) Count
D) All of the above

Question 48

A(n) _____ join means that records are selected only if a matching value is present in both tables.

A) default
B) inner
C) right
D) left

Question 49

The "" criteria is used to query for ____ values.

A) Like
B) Null
C) Zero-length string
D) Is Null

Question 50

The Relationships window shows how well the data has been ____________________.

Question 51

When two fields are used in a Validation Rule expression, you should enter the rule in the ____.

A) table's Property Sheet
B) individual field's Property Sheet
C) query Validation box
D) Current Record box

Question 52

In Table Design View, you can view the properties of ____ field(s) at a time.

A) 1
B) 2
C) 4
D) as many as you select at the same time

Question 53

A(n) ____________________ keeps track of the order of the values in the indexed field as data is being entered and edited.

Question 54

Which of the following is NOT a form property?

A) Scroll Bars
B) Record Selectors
C) Control Source
D) Navigation Buttons

Question 55

Which is NOT true of the Caption property?

A) It is an optional property.
B) It is used as the default field name at the top of the field column in datasheets.
C) It is used as the default field name in labels that describe fields on forms and reports.
D) It must match the field name.

Question 56

Tables with a many-to-many relationship must be related to an additional table, called a(n) ____________________ table.

Question 57

A query nested within another query is called a(n) ____.

A) Action
B) Sub report
C) Append query
D) Subquery

Question 58

A validation rule that specifies that the DateHired field value is always greater than the DateBorn field value is a(n) _____ validation rule.

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

Question 59

To move a field list in the Relationship window, drag its ____________________.

Question 60

If an employee does not want his/her phone number listed in a company database, and you want to enter two quotation marks with nothing between them to indicate an intentional nothing entry in the field, the ____________________ field property in the employee table must be set to Yes.

Question 61

A(n) ____________________ table is a table that stores values used in a field of another table.

Question 62

Compare and contrast a zero-length string with a null entry.

Question 63

Describe third normal form.

Question 64

A(n) ____________________  join operation is the default join that applies to one-to-many relationships between two tables in a query.

Question 66

You work in the registrar's office of a large university. You are responsible for creating a student database that contains students' ID numbers, names, addresses, phone numbers, and some medical information.
Suppose the student database includes two tables, one containing information on courses and the other containing information on students. One student can take many courses and one course can be taken by many students. What would be the proper relationship between the tables?

Question 67

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt.
What is the first clue that data is not properly normalized?

Question 68

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt.
Which window shows you how well the data has been normalized?

Question 69

You work in the registrar's office of a large university. You are responsible for creating a student database that contains students' ID numbers, names, addresses, phone numbers, and some medical information.
The student health database contains a Students table. If each student record in the Students table has a unique StudentID, what special designation would the StudentID field be given in the Students table?

Question 70

You work in the registrar's office of a large university. You are responsible for creating a student database that contains students' ID numbers, names, addresses, phone numbers, and some medical information.
Suppose the student health database includes two tables, one table called Students that contains student information such as StudentID, student name, address, and telephone number and the other table called Documentation that contains several records for each student and records the dates and descriptions of various medical documents required by the university. What type of relationship would need to be established between the two tables?

Question 71

List three reasons why data normalization is valuable.