VIEWS: 0 PAGES: 7 POSTED ON: 5/30/2012
Exam 4 - Chapter 4 Designing and Building a Relational Database Question 1 Data that is entered and stored according to its intended use is said to have data ________. Selected Answer: integrity Question 2 To prevent possible problems in creating a dynamic Web site for a database, you should avoid using ________ in the table and field names. Selected Answer: spaces Question 3 The most common type of relation in a relational database is a(n): Selected Answer: one-to-many Question 4 When using a relational database, you can use a single form to enter data from more than one table. Selected Answer: True Question 5 The ________ data type is usually used for values such as True/False or On/Off. Selected Answer: Yes/No Question 6 You can extract information from a database using a ________. Selected Answer: query Question 7 With the Relationships window open, you can create a relationships report by clicking the Relationship Report button in the: Selected Answer: Tools group Question 8 There are how many different Access data types? Selected Answer: 10 Question 9 The default value for a Yes/No field is an unchecked checkbox. Selected Answer: False Question 10 You can retrieve values from another table or a value list by using a: Selected Answer: lookup field. Question 11 To add fields to a new table, you click the Table Design button in the: Selected Answer: Tables group on the Create tab. Question 12 To fit a report on a single page, you click the Size to Fit button in the: Selected Answer: Position group on the Arrange tab. Question 13 When indexing an Access database, the Yes (No Duplicates) option builds an index so that every value in that field in the table is unique. Selected Answer: True Question 14 The ________ Rule property is used to check values for accuracy as they are entered into a table. Selected Answer: Validation Question 15 In the Datasheet view, Yes/No fields are displayed as a(n): Selected Answer: Check box. Question 16 To create a form with a subform, you click the Form button in the: Selected Answer: Forms group on the Create tab. Question 17 A Caption property makes field names more user-friendly by displaying alternate text for database objects. Selected Answer: True Question 18 A relational database that has ________ decreases efficiency and accuracy because data is needlessly repeated. Selected Answer: Data redundancy Question 19 The primary key is the only field in a table in which a user must enter a value. Selected Answer: True Question 20 Which Input Mask replacement character precedes characters and is used to change them to uppercase? Selected Answer: > Question 21 When using the Input Mask Wizard, which of the following is NOT a pre-built mask? Selected Answer: Name Question 22 When using a list box, the user can not enter a value that is not in the list. Selected Answer: True Question 23 A person who enters the data using forms or uses the information found in queries and reports is called a(n): Selected Answer: end-user. Question 24 You can avoid data entry errors by changing the ________. Selected Answer: field properties Question 25 A ________ is a character that cannot be changed by the end user during data entry such as the parentheses that might surround an area code. Selected Answer: literal character Question 26 Once you have created a table, you then plan the field properties that are needed for each field. Selected Answer: False Question 27 The Yes/No data type is used when a field that will hold only one of two values. Selected Answer: True Question 28 To speed up searching and sorting, you use the ________ property to create a second, more efficient table that is quickly searched or sorted. Selected Answer: Indexed Question 29 In a one-to-many relationship, the related field in the second table is called a ________ key. Selected Answer: foreign Question 30 Which Input Mask replacement character is used to indicate a single digit is required? Selected Answer: 0 Question 31 In a relational database, a(n) ________ relationship does not impose referential integrity. Selected Answer: indeterminate Question 32 The ________ data type is the preferred type for storing pictures, Office files, and small executable files. Selected Answer: Attachment Question 33 When using the Password input mask all of the Password's characters are displayed as ________. Selected Answer: asterisks (*) Question 34 Although Word and Excel can store data in tables, the true power of using Access instead of Word or Excel is its ability to ________ tables. Selected Answer: relate Question 35 The Password input mask displays all of the Password's characters as x's, but stores the actual password in the table Selected Answer: False Question 36 A ________ box includes an arrow that when clicked displays a list of user selectable items. Selected Answer: combo Question 37 When using the Input Mask Wizard,________ are the characters that the user modifies during data entry. Selected Answer: Placeholder characters Question 38 What is the special report showing the current layout of the Relationships window called? Selected Answer: Relationships report Question 39 Which Input Mask replacement character specifies that the following character will be a literal character? Selected Answer: \ Question 40 Which Validation Rule specifies that the number that is entered is greater than zero? Selected Answer: >0 Question 41 When using the Relationship window, you can display the Edit Relationships dialog box, by clicking the Edit Relationships button in the: Selected Answer: Tools group on the Design tab. Question 42 You can use a ________ to see more than one column of data from the table that contains the lookup values. Selected Answer: multiple column lookup field Question 43 Indexes should be created for fields that are searched or sorted infrequently. Selected Answer: False Question 44 In a ________ relationship, the common field used to join two tables must have a unique matching record in the other table. Selected Answer: one-to-one Question 45 A ________ box displays several values without having to click an arrow. Selected Answer: list Question 46 To create a query, you click the Query Design button in the: Selected Answer: Other group on the Create tab. Question 47 In a ________, whenever the data in the first table is modified, all the related occurrences of the data in the second table are also modified. Selected Answer: cascading update Question 48 Typically, data is entered directly into tables and not into forms. Selected Answer: False Question 49 The ________ property allows an entry to have no characters. Selected Answer: Allow Zero Length Question 50 To control the structure of data entered into a field, you would use the field's: Selected Answer: Input Mask property.
Pages to are hidden for
"Exam 4 - Chapter 4 Designing and Building a Relational Database"Please download to view full document