Full file at

Chapter 2: Relational Databases and Multi-Table Queries

Multiple Choice:

1.Which does NOT describe the concerns about Y2K?

  1. Computers only stored the last two-digits of a year.
  2. This would impactpoorly designed databases.
  3. The functionality of computers wouldbe minimal or not at all.
  4. This was a program that contained a serious virus.

1

Copyright © 2008 Pearson Prentice Hall. All rights reserved.

Chapter 2: Relational Databases and Multi-Table Queries

Answer: DDifficulty:ModerateObjective:1

Reference:Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

2.Which of the following would NOT be a field used on a customer table?

  1. Address
  2. AcctNo
  3. Employees
  4. LName

Answer: CDifficulty:ModerateObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

3.Which of the following is NOT considered one of the essential guidelines when designing a database?

  1. Design for a 100-year usage
  2. Use calculated fields
  3. Store data in its smallest parts
  4. Design compliant with PNPI regulations

Answer: BDifficulty:ModerateObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

4.When planning to build a database it is best to:

  1. determine the output, next design the tables.
  2. input the data, next design the reports.
  3. create and input the design of the table and reports at the same time.
  4. determine the input, then design the table

Answer: ADifficulty:DifficultObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

5.Reserve space for a field with:

  1. PNPI regulations.
  2. the Sarbanes Oxley Act.
  3. field size property.
  4. validation rule.

Answer: ADifficulty:EasyObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

6.Which of the following would ensure that a value of 15 or greater is entered in a field?

  1. Field type
  2. Sarbanes Oxley Act
  3. Field size
  4. Validation rule

Answer: DDifficulty:DifficultObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

7.Which is NOT true of validation rules?

  1. They enforce a size limit.
  2. They check authenticity of data entered in a field.
  3. An error message will appear if a rule is violated.
  4. They protect from fraudulent practices.

Answer: DDifficulty:ModerateObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

8.Which protects the general public and the shareholders of a company from accounting errors and fraudulent practices?

  1. PNPI Regulation
  2. Sarbanes Oxley Act
  3. Validation rule
  4. Gramm-Leach-Bliley Act

Answer: BDifficulty:ModerateObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

9.Which is NOT true of personal, nonpublic information laws?

  1. They protect social security numbers, credit card and bank account numbers.
  2. They protect medical, educational and other personal data.
  3. Sensitive data must be stored in a computer.
  4. Local laws govern the safeguarding of information.

Answer: DDifficulty:ModerateObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

10.Which is NOT a reason to save the first and last name as separate fields?

  1. You can sort on last name.
  2. The first name could be used in salutation of a letter.
  3. It uses fewer fields.
  4. You can use ONLY the first or last name with a salutation.

Answer: CDifficulty:ModerateObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

11.Which is NOT true of a calculated field?

  1. Calculated fields should be stored in a table.
  2. The value of a calculated field is produced from an expression.
  3. A calculated field references other field(s).
  4. The result is useful at the moment the calculation is made.

Answer: ADifficulty:ModerateObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

12.Which is NOT true of a birth date field?

  1. A birth date is considered a constant.
  2. A birth date would be defined as a date/time field.
  3. Using an Age field, which shows how old a person may be, is the same as a birth date field.
  4. Date arithmetic can be applied to a birth date field.

Answer: CDifficulty:DifficultObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

13.Which of the following is a special definition setting used on a field containing an employee’s date of hire?

  1. Date arithmetic
  2. Constant
  3. Date/time field
  4. Calculated field

Answer: CDifficulty:DifficultObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

14.Which does NOT describe the term data redundancy?

  1. The same data exists in two tables.
  2. The data is always in linked tables.
  3. It requires updating in two locations.
  4. Output could be incorrect if the first and second location of same data is not updated.

Answer: BDifficulty:DifficultObjective:1

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

15.Which is the correct format of CamelCase notation?

  1. Years Of Svc
  2. Yearsofsvc
  3. YearsOfSvc
  4. YEARSOFSERVICE

Answer: CDifficulty:DifficultObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

16.Access recognizes ______data types.

  1. six
  2. nine
  3. five
  4. eight

Answer: BDifficulty:EasyObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

17.A unique field (or combination of fields) that identifies each record in a table is called a:

  1. CamelCase notation.
  2. primary key.
  3. field.
  4. data type.

Answer: BDifficulty:EasyObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

18.All of the following are examples of primary keys EXCEPT:

  1. Student Id.
  2. Social Security Number.
  3. ISBN number on a textbook.
  4. Last Name.

Answer: DDifficulty:DifficultObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

19.Which of the following statements is NOT true of the following example?

<br<br<img src="images/EA2Fig03b.gif">

  1. The numbering is assigned randomly to records.
  2. No natural identifier is available in the fields shown.
  3. The table contains a unique identifier assigned by AutoNumber.
  4. The field SpeakerID contains the unique identifier.

Answer: ADifficulty:DifficultObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

20.Which of the following is used to create a relationship between two tables?

  1. Primary key
  2. AutoNumber field
  3. Identification number
  4. Foreign key

Answer: DDifficulty:EasyObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

21.Data that is organized and summarized in an easy to read view is known as a:

  1. table.
  2. PivotTable .
  3. design.
  4. report.

Answer: BDifficulty:EasyObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

22.Which is NOT true of a property?

  1. A property is an object’s characteristic or attribute.
  2. Tables, forms, queries, and reports have a set of properties.
  3. A property sheet is used to make changes.
  4. Design properties are displayed in Datasheet View.

Answer: DDifficulty:ModerateObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

23.Which does NOT describe a caption property?

  1. A label can substitute for a field name in Datasheet View.
  2. The label can be used in place of a field name in an expression.
  3. The caption appears in Datasheet View, report, and form.
  4. The label allows spaces between words.

Answer: BDifficulty:ModerateObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

24.Which is NOT true of locating and opening an existing database?

  1. Clicking the Cancel button will then display the option to open an existing or recently visited database.
  2. Existing databases can be viewed under the Browse folder.
  3. Existing database files found in the Browse folder cannot be opened if Blank Database is displayed above.
  4. Existing files can only be opened from the File button, under Open.

Answer: DDifficulty:DifficultObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

25.From the following example, which does NOT apply to this view?

<br<br<img src="images/EA2Fig07.gif">

  1. The pencil indicates the row is being edited.
  2. The default name is used for the table name.
  3. TheDesign View of the table is displayed.
  4. The default field names are used for field1, field2, field3.

Answer: CDifficulty:ModerateObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

26.From the following example, which does NOT apply tothis view?

<br<br<img src="images/EA2Fig08.gif">

  1. A primary key has been selected.
  2. Duplicates of data will be accepted on the BID field.
  3. Unique numbers will be assigned to the ID field.
  4. The Design View of the table called Branch is displayed.

Answer: BDifficulty:DifficultObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

27.Which statement is NOT true of the following image display?

<br<br<img src="images/EA2Fig10.gif">

  1. The field Start Date type is set to a date field.
  2. The field name Start Date will display Manager’s Start Date in Datasheet View.
  3. This display shows that data will definitely be lost when the ‘Yes’ button is clicked.
  4. The primary key field is not Start Date.

Answer: CDifficulty:ModerateObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

28.Which statement is NOT true of working with tables?

  1. Backups of the table occur automatically.
  2. People do not spend time formatting the table.
  3. Most people do not even print a table.
  4. Tables are rarely used as output.

Answer: ADifficulty:ModerateObjective:2

Reference: Table Design, Properties, Views, and Wizards

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

29.Which statement is NOT true when referential integrity is enforced?

  1. Access will reject changes that update or delete if in violation of the referential integrity.
  2. Access checks the accuracy of spelling in the tables.
  3. You can trust that the data is reliable.
  4. A record will not be added to the table if an ID that is referenced does not exist.

Answer: BDifficulty:DifficultObjective:3

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

30.What does the term cascadingmean?

  1. Queries can retrieve data at a faster rate.
  2. Changes in the data travel from one table to another.
  3. Data is put in sequential order
  4. Records are arranged in order.

Answer: BDifficulty:ModerateObjective:3

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

31.Based on the following join relationship of a one-to-many relationship, which statement is TRUE?

<br<br<img src="images/cascading.gif">

  1. An order id can be changed in the Orders table.
  2. A change or update cannot be made in either table.
  3. An order id can be changed in the Order Details.
  4. An update or change can be made in both tables.

Answer: BDifficulty:DifficultObjective:3

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

32.Which statement is NOT true of indexed property?

  1. An example of a setting is Yes (no duplicates).
  2. Indexing a table speeds the retrieval time.
  3. Primary keys must be indexed.
  4. Setting the index requires each record to be scanned sequentially.

Answer: DDifficulty:ModerateObjective:3

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

33.Which statement is NOT true about Access sharing data with Excel?

  1. Data can be moved easily between the two applications with cut and paste.
  2. A wizard can help facilitate the sharing of data.
  3. Tables of data can be imported and exported.
  4. The Get External Data command is used to do the importing.

Answer: ADifficulty:ModerateObjective:4

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

34.Which statement is NOT true about the following image?

<br<br<img src="images/EA2Fig14.gif">

  1. There are two worksheets from which to select..
  2. There are four columns that will be put into four fields.
  3. Both tables can be selected at the same time.
  4. The first row of the sample data will become the field names.

Answer: CDifficulty:DifficultObjective:4

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

35.Which statement is NOT true about importing Excel worksheets?

  1. Access uses Excel labels for field names.
  2. Imported data can be imported into a new table, appended to an existing table, or linked to an Access table.
  3. A preview of the data to be imported is displayed in a dialog box.
  4. There are always labels that are imported to fields.

Answer: DDifficulty:DifficultObjective:4

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

36.Which process is NOT an example of sharing data?

  1. Get External Data
  2. Collect and Update
  3. Cut and Paste
  4. Export data

Answer: CDifficulty:ModerateObjective:4

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

37.Which is NOT a task when using the Import Wizard?

  1. Selecting a primary key
  2. Changing field types of fields
  3. Selecting the first row as column headings
  4. Deleting columns of data

Answer: DDifficulty:DifficultObjective:4

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

38.Which is NOT true of the following example of a one-to-many relationship?

<br<br<img src="images/one_to_many002.gif">

  1. It is the least used type of relationship.
  2. ID is a unique identification number that would be used in the Agents table and SellingAgent in the Properties table.
  3. Each record in the Agents table may match one, more than one, or no records in the Properties table.
  4. Each record in a Properties table matches only one record in the Agents table.

Answer: ADifficulty:DifficultObjective:5

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

39.Which does NOT describe the following one-to-one relationship?

<br<br<img src="images/one_to_one.gif">

  1. All the data in both tables can be used by all people accessing the database.
  2. Author and AuthorNew tables use the same primary key.
  3. More tables can be joined to either table.
  4. It may be used for security reasons to protect data availability.

Answer: ADifficulty:DifficultObjective:5

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

40.Which does NOT describe a many-to-many relationship?

  1. There are many matching records in each direction between tables.
  2. There must be at least two tables.
  3. It uses a juncture table.
  4. It may be used to connect to Oracle and other databases.

Answer: BDifficulty:DifficultObjective:5

Reference: Multiple Table Database

Chapter: 2

Application: Access

Textbook: Exploring Microsoft Office Access 2007

41.Which does NOT apply to the following relationship image?

<br<br<img src="images/EA2Fig22.gif">

  1. A one-to-many relationship is applied.
  2. The display is showing the Design View of relationships.
  3. One table is not joined to the other two tables.
  4. A join exists on two primary keys.

Answer: DDifficulty:DifficultObjective:5

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

42.Troubleshooting a relationship requires doing all of the following EXCEPT:

  1. creatinga relationship between like data types.
  2. checking the size of fields to be used in therelationship.
  3. checking that the correct type of relationship is established.
  4. deletingthe relationship and field and then rebuilding.

Answer: DDifficulty:DifficultObjective:5

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

43.Which does NOT describe queries?

  1. They perform calculations.
  2. They are run from a table Datasheet View.
  3. They display specific records from table(s).
  4. They ask questions about data in a database and return answers in a specified order.

Answer: BDifficulty:ModerateObjective:6

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

44.Which does NOT describe the Query Wizard?

  1. The Wizard only allows fields to be selected from tables.
  2. Fields can be selected in a different order than in the original table.
  3. It automates your work.
  4. A query name can be assigned when using the Wizard.

Answer: ADifficulty:ModerateObjective:9

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

45.Which is NOT an example of an expression usingan operand?

  1. >25
  2. >43
  3. =15
  4. =23

Answer: DDifficulty:ModerateObjective:7

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

46.Which is an example of an expression using a wildcard?

  1. Date()
  2. Chapt???
  3. *west
  4. #02/05/2005#

Answer: CDifficulty:ModerateObjective:7

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

47.Which is an example of an expression that will return records that are fromeither of two states?

  1. New YorkORCalifornia
  2. New York AND California
  3. New York NOT California
  4. Is Not Null

Answer: ADifficulty:ModerateObjective:7

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

48.Which is an example of an expression that will return records that are more than 15 days older than the current date?

  1. Date()+15
  2. <Date()-15
  3. =Date()=15
  4. >Date()-15

Answer: BDifficulty:ModerateObjective:7

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007

49.Which would be used to return a field display result of missing or no value?

  1. Not #01/01/2008#
  2. Is Null
  3. Is Not Null

Answer: BDifficulty:ModerateObjective:7

Reference: Multiple Table Database

Chapter: 2

Application: Access2007

Textbook: Exploring Microsoft Office Access 2007