Deck 2: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Question 1

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

A) creates a primary key in every table of a database.
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.

Answer 1

B

Question 2

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.

Answer 2

C

Question 3

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.

Answer 3

A

Question 4

If data from an Excel worksheet is imported into Access and no column headings exist, the data will import using:

A) Import1, Import2, Import3, etc.
B) Access1, Access2, Access3, etc.
C) Field1, Field2, Field3, etc.
D) FieldA, FieldB, FieldC, etc.

Question 5

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 6

Which of the following is NOT a way to create a table in Access?

A) Typing a field name in a column in Datasheet view
B) Typing a field name in a row in Design view
C) Entering table data into a new row in Datasheet view
D) Importing data from another database or application

Question 7

An example of a ________ field is a field for sales associates' bonus--.05 multiplied by quarterly sales.

A) multitable
B) logical
C) numeric
D) calculated

Question 8

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. Jose should apply a(n) ________ data type.

A) OLE Object
B) Number
C) Attachment
D) Calculated

Question 9

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

A) Queries run slower in smaller databases of 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 10

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 a Web page. Sarah should apply a(n) ________ type.

A) Short Text
B) OLE Object
C) Hyperlink
D) Lookup Wizard

Question 11

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

A) Short Text; 25
B) Long Text; 1,024
C) Long Text; 255
D) Short Text; 255

Question 12

Which of the following is NOT a guideline for adding fields to a database table?

A) Consider the future use of the database.
B) Store data in their smallest parts.
C) Design to accommodate date arithmetic.
D) Link tables using foreign keys

Question 13

Storing the date of birth of clinic patients should be a ________ field.

A) constant
B) numeric
C) text
D) calculated

Question 14

Which statement accurately describes the function of a query?

A) Queries allow a user to ask questions about data and then provide answers by providing subsets or summaries of data.
B) Queries delete data stored in tables, displaying only those records that match the query's criteria.
C) Queries edit data stored in tables, displaying only those records that match the query's criteria.
D) Queries manipulate data stored in tables, hiding only those records that match the subsets or summaries of the query's criteria.

Question 15

Which of the following is FALSE about CamelCase notation?

A) Use uppercase letters to distinguish the first letter of each new word.
B) Field name can be up to 64 characters.
C) Field names should include spaces when the name is more than one word.
D) Field names can include letters and numbers.

Question 16

Which of the following is NOT a type of relationship available in Access 2013?

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

Question 17

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

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

Question 18

Two or more tables that contain duplicate data are an example of:

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

Question 19

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

Question 20

A ________ query is a type of query that displays on records that match criteria entered in Query Design view.

A) select
B) simple
C) one-to-one
D) multitable

Question 21

Spaces should be included in field names.

Question 22

When designing a database, an important guideline is to store data in their largest parts.

Question 23

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

Question 24

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

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

Question 25

Creation of the order of fields within a table and specific field names given are significant because it's very difficult to change these after the database has been created.

Question 26

Data redundancy may result in errors.

Question 27

Which of the following statements is TRUE regarding multitable queries?

A) Related tables never need to be previously established when you create a multitable query.
B) If join lines do not appear between tables, the multitable query results will not be affected.
C) Creating a multitable query is significantly different from creating a single-table query.
D) Skill is required in choosing the right tables and managing table relationships.

Question 28

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

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

Question 29

Linking tables using common fields is a suggested guideline for successfully adding fields to a database.

Question 30

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 31

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

A) Numeric fields require quotation marks as delimiters.
B) Date fields are enclosed in quotation marks.
C) Different data types require different delimiters.
D) All data types use the same delimiters.

Question 32

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

Question 33

Good database design begins with the forms of the database.

Question 34

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 that use plain digits require no delimiter.
C) Date/Time data types must be enclosed in quotations.
D) Number data types must be enclosed in single quotes.

Question 35

Which of the following is FALSE about changes in multitable queries?

A) Deleting a join line affects all relationships in all tables of the database.
B) Join lines can be deleted in a query with no impact on the relationships.
C) When you add two tables to a query, join lines appear automatically.
D) The Relationship window displays join lines.

Question 36

Freezing fields disallows any user from changing the field name or any data within the field.

Question 37

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 38

Which of the following is FALSE about multitable queries?

A) You can add tables of a multitable query using the Show Table dialog box.
B) You can delete tables of a multitable query by clicking the unwanted table and pressing Delete.
C) You can add fields by clicking a field selector and clicking Add.
D) The Relationship window displays join lines.

Question 39

Fields can be renamed either in Design view or in Datasheet view.

Question 40

Where do you change the order of query fields to change the order of query results?

A) In the design grid of a query's Datasheet view
B) In the Criteria row of the Query Design view
C) In the Show row of the Query Design view
D) In the Relationship window of the Design view

Question 41

A(n) ________ produces a value from an expression or function that uses one or more fields in a database.

Question 42

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 43

The Run command appears as a red exclamation point in Design view.

Question 44

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

Question 45

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

Question 46

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

Question 47

Using a field that contains a year of birth and a field that contains the current year to determine the age of a person listed in a database is called ________.

Question 48

Comparison operators include *, ?, and [ ].

Question 49

When you add two or more tables to a query, you must manually create new join lines.

Question 50

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

Question 51

An unchanging value is called a(n) ________.

Question 52

Calculated fields are frequently created with ________ data.

Question 53

In field names, object names, and filenames, uppercase letters are used to distinguish the first letter of a new word in ________ notation.

Question 54

If you choose Append a copy of the records to the table as an option for incoming data, the data will be added to an existing table.

Question 55

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

Question 56

If a worksheet in an Excel workbook was named, Access uses the worksheet name as the database name.

Question 57

Access requires a primary key for every table.

Question 58

The Is Null expression is used to find blank fields.

Question 59

The Simple Query Wizard displays a series of dialog boxes that guide users through the query design process.

Question 60

Multitable queries take advantage of table relationships in a database.

Question 61

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

Question 62

The ________ Wizard guides you through the query design process in Access.

Question 63

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

Question 64

A(n) ________ relationship requires a table called a junction table.

Question 65

You can set a(n) ________ to create a label more readable than a field.

Question 66

A(n) ________ relationship consists of a primary key value in a primary table and numerous foreign key values in a related table.

Question 67

The ________ data type can be used for fields that contain monetary values.

Question 68

A(n) ________ verifies data entered into a field and ensures that the data is of the correct type for the field.

Question 69

Use the ________ tab to begin the process of importing an Excel worksheet.

Question 70

You use the ________ view to create queries.

Question 71

If a user selects the ________ Related Fields option while creating a relationship, Access will automatically modify all foreign key values in a related table to match any modifications made to the primary key.

Question 72

When referential integrity is enforced, you cannot enter a(n) ________ key in a related table unless the primary key exists in the primary table.

Question 73

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

Question 74

If you want to modify a saved query, open the query in ________ view.

Question 75

The ________ data type should be applied to fields that contain a combination of characters and will be 255 characters or less.

Question 76

________ tables are tables that are joined from one table to another through a common field.

Question 77

A(n) ________ query is a type of query that displays only the records that match criteria that you enter in Query Design view.

Question 78

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

Question 79

The ________ of the query design grid is used to set the rules that determine which records of a table will be selected.

Question 80

Quotation marks before and after text in a text field and pound signs before and after a date in a date field are example of ________.