Deck 16: Access: Presentation Development

Question 1

Which field property type should be used to enter a predefined value into a field when most of the records will have the same value?

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

Answer 1

B

Question 2

Which statement accurately describes the function of a query?

A) Queries manipulate data stored in tables, displaying only those records which match the query's criteria
B) Queries delete data stored in tables, displaying only those records which match the query's criteria
C) Queries edit data stored in tables, displaying only those records which match the query's criteria
D) Queries manipulate data stored in tables, hiding only those records which match the query's criteria

Answer 2

A

Question 3

When designing a database, all of the following statements are true EXCEPT:

A) You need to consider the output requirements of the database
B) You need not be concerned with the future requirements of the database
C) You should store data in its smallest parts
D) Begin the design process with identification of the tables in the database

Answer 3

B

Question 4

The ________ field property changes how a field will appear when displayed or printed, but does not change the values stored in the field.

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

Question 5

In a query, which of the following statements is true regarding delimiters in the criterion of a field?

A) Text data types must be enclosed in pound signs
B) Number data types require no delimiters
C) Date / Time data types must be enclosed in quotations
D) Number data types must be enclosed in single quotes

Question 6

Irene is working on a database that stores customer data and order information. The Customer Information Table holds customer information. A unique customer number serves as the primary key for this table. The Order Information Table holds order information. A unique order number serves as the primary key for this table. A customer only has one customer number but may have several order numbers. If Irene wants to establish a one-to-many relationship between the customer information table and the order information table, which of the following steps should she follow?

A) Irene should include the primary key in the customer information table as a foreign key in the order information table.
B) Irene should include the foreign key in the customer information table as a primary key in the order information table.
C) Irene should include the primary key in the customer information table as a primary key in the order information table.
D) Irene cannot establish a relationship between the two tables.

Question 7

Marla is working in a database that stores customer purchases. She needs to find customers in the New York area that have purchased over $5000 worth of goods. Which query operator would Marla use in a query to find this information?

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

Question 8

Which of the following would be the best choice for a primary key?

A) First Name
B) Last Name
C) Social Security Number
D) Street Address

Question 9

All of the following are acceptable field names EXCEPT:

A) Clientnumber
B) ClientNumber
C) ClientID
D) ClientNum

Question 10

Which of the following query criteria would be used to produce results for Date / Time fields containing a date of December 12th, 2010?

A) 12 / 12 / 2010
B) #12 / 12 / 2010#
C) Between #12 / 11 / 2010# and #12 / 14 / 2010#
D) 12 / 11 / 2010

Question 11

Which of the following is true regarding the running of queries and the size of a database?

A) Queries run slower in smaller databases numeric data
B) Queries run at the same speed in large or small databases
C) The size of a database does not affect the speed at which queries run
D) The queries in larger databases may take longer to run than queries in smaller databases

Question 12

Joe is working in a database that stores client data. He needs to design a field that will assign a client ID number each time a user enters a new client. The data type he should apply to this field is:

A) Text
B) Memo
C) Number
D) AutoNumber

Question 13

Ben is working in a database that stores student information. He wants to determine each student's age based on the student's birthday. Which of the following statements accurately describe how the fields should be designed?

A) The birthday should be a stored field and the age should be a calculated field
B) The birthday should be a calculated field and the age should be a stored field
C) Both the birthday and age fields should be calculated fields
D) Both the birthday and age fields should be stored fields

Question 14

Jen is working on a database that stores employee data. In the EmployeeData Table, there is a field that stores the number of years each employee has been with the company. She needs to design a query that shows all employees that have worked for company more than ten years. Which of the following query criteria should Jen use to locate is information and display records of employees with the company more than ten years?

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

Question 15

When defining a field, the field ________ property determines how much physical storage space the field requires.

A) size
B) input mask
C) caption
D) format

Question 16

Jose is working on a database that stores stock information. He needs to design a field that will allow a user to connect to a graph created in Excel. The data type he should apply to this field is:

A) OLE
B) Number
C) Text
D) Memo

Question 17

Ryan needs to organize the data in a table so that it displays in a summarized format. He should use the ________ view for this purpose.

A) Datasheet
B) PivotTable
C) PivotChart
D) Design

Question 18

The ________ is a special character that is used to represent one or more characters in the criterion of a query.

A) wildcard
B) operator
C) operand
D) delimiter

Question 19

Sarah is working in a database that stores resort vacation information. She needs to design a field that will allow a user to link to an external website. The data type she should apply to this field is:

A) Memo
B) OLE
C) Hyperlink
D) Attachment

Question 20

In Access, a query criterion use to locate a blank field is:

A) Empty
B) Void
C) Null
D) Invalid

Question 21

The ________ group on the External Data Tab has options that you can use to send a portion of a database to other application

A) Import & Link
B) Export
C) Collect Data
D) Web Linked Lists

Question 22

Two or more tables which contain duplicate data is an example of ________.

A) one-to-many relationships
B) data redundancy
C) many-to-many relationships
D) data backup

Question 23

Which of the following is true about the NOT operator?

A) The NOT operator returns records meeting any of the specified criteria
B) The NOT operator returns records meeting all of the specified criteria
C) The NOT operator does return any records
D) The NOT operator returns all records except those that meet the specified criteria

Question 24

Which field property type should be applied to fields that should not remain empty?

A) Required
B) Format
C) Indexed
D) Caption

Question 25

It is more efficient to copy and use an existing query for a new query when

A) the query criteria needed will be similar to the original query
B) the query will be deleted after it is run
C) the query criteria needed will be unique to the original query
D) the query will be sorted alphabetically

Question 26

The ________ determines what field values are allowed and what other properties the field will have.

A) identity
B) attribute
C) record type
D) data type

Question 27

Which of the following statements best describes a one-to-many relationship between two tables?

A) A primary key in the first table matches several foreign keys in the second table.
B) A foreign key in the first table matches several primary keys in the second table.
C) A primary key in the first table matches exactly one foreign key in the second table.
D) Primary and foreign keys have multiple cross matches between a first and second table.

Question 28

The ________ data type is used to hold sentences or paragraphs of descriptive data.

A) Text
B) OLE
C) Memo
D) Hyperlink

Question 29

Steven is working on a database that stores student data. He needs to find students majoring in either one of two majors. He is looking for students majoring in Economics. He also is looking for students majoring in History. Which operator would Steven use to find this information?

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

Question 30

Which of the following statements is true about how Access and Excel share data:

A) Access can import data from Excel, but cannot export data to Excel
B) Access can export data to Excel, but cannot import data from Excel
C) Access can import data from Excel, and export data to Excel
D) Access cannot import data from Excel and cannot export data to Excel

Question 31

Referential integrity should be enforced in a database with related tables because it

A) makes the database easier to back up.
B) helps ensure invalid data is not entered into a table.
C) makes the database easier to repair.
D) helps ensure data is automatically updated.

Question 32

A(n) ________ operator, such as the greater than or less than symbol, can can be used in a query ciriterion to limits the results produced by the query.

A) operand
B) wildcard
C) comparison
D) delimiter

Question 33

A(n) ________ field is used to produce a value from an expression or function.

A) AutoNumber
B) Number
C) Date
D) calculated

Question 34

The result of a query, which appears similar to a table, is called a ________.

A) recordset
B) report
C) form
D) datasheet

Question 35

The value in a field with the ________ data type will be automatically increased each time a new record is entered.

A) Currency
B) Date / Time
C) Number
D) AutoNumber

Question 36

A field name can begin with a(n) ________.

A) space
B) accent grave
C) period
D) number

Question 37

The ________ data type can store text, numerals, and symbols.

A) Text
B) Number
C) Date / Time
D) Currency

Question 38

Which of the following statements is true regarding multi-table queries?

A) Skill is required in choosing the right tables and managing table relationships
B) If join lines do not appear between tables, the multi-table query results will not be affected
C) Creating a multi-table query is different from creating a single table query
D) You should add all the tables in a database to your multi-table query

Question 39

Which of the following statements is true about data types and delimiters?

A) Numeric fields require quotation marks as delimiters
B) Text fields require pound signs as delimiters
C) Different data types require different delimiters
D) Different data types use the same delimiters

Question 40

The maximum size of the Text data type is ________ characters.

A) 25
B) 50
C) 200
D) 255

Question 41

Good database design begins with designing forms.

Question 42

Access can import data from different a database or Excel spreadsheet.

Question 43

The Collect Data group on the External Data Tab allows a user to import data into a database.

Question 44

Data redundancy may result in errors.

Question 45

In most cases, it is advisable to enforce referential integrity in databases with related tables.

Question 46

A field containing the AutoNumber data type must be manually incremented for each record entered.

Question 47

It is best to design fields to hold large amounts of data.

Question 48

Access requires a primary key for every table.

Question 49

Spaces should be included in field names.

Question 50

The data type of a field determines the type of operations than can be performed on that field.

Question 51

Once a table is created, you cannot change an existing field in that table.

Question 52

Field names should help identify the data held in the field.

Question 53

You cannot add a missing field to a table once the table has been designed.

Question 54

When designing a database, it is important to consider future data needs.

Question 55

By establishing a relationship, you can efficiently combine data from related tables.

Question 56

A one-to-many relationship is established when the foreign key in the first table matches multiple primary key values in the second table.

Question 57

All Excel spreadsheets are ready to import into an Access database.

Question 58

A query is a question asked about the data in a database.

Question 59

A text field may contain numbers, text, and special characters.

Question 60

When defining a field, the field ________ property determines how much physical storage space the field requires.

A) size
B) format
C) caption
D) input mask

Question 61

The simple query wizard displays a series of dialog boxes that guide users through the query design process.

Question 62

________ are used in the Relationships window to establish a relationship between two tables.

Question 63

You cannot modify a multi-table query using the same methods used to modify a single table query.

Question 64

Multi-table queries take advantage of table relationships in a database.

Question 65

A question you ask about the data stored in a database is called a ________.

Question 66

The ________ property can be applied to change the way a field is displayed or printed.

Question 67

________ queries contain two or more tables and allow users to take advantage of relationships that have been set between these tables.

Question 68

The ________ data type should be applied to fields that contain a combination of characters.

Question 69

A ________ relationship consists of a primary key value in a primary table many foreign key values in a related table.

Question 70

The ________ view organizes and displays data in a summary view.

Question 71

A(n) ________ is a dynamic subset of a table that selects, sorts, and calculates records as specified in a query.

Question 72

An operand is a mathematical symbol.

Question 73

For fields containing social security numbers or dates, a(n) ________ can automatically provide characters such as hyphens or slashes.

Question 74

The run command appears as a red exclamation point in Query design view.

Question 75

The ________ data type is used for fields that will be used in mathematical calculations except those involving money.

Question 76

Sheila is creating a database that will store student data. The database will contain a Field named DeansList. This field identifies whether or not a student appears on the dean's list. Sheila should use the ________ data type to this field.

Question 77

A blank field is also known as Null.

Question 78

A mathematical symbol such as an addition or subtraction sign is called a(n) ________.

Question 79

A relationship cannot be established between two tables unless a primary key has been set in the first table.

Question 80

________ is the value used to describe a blank field in an Access table.