Deck 1: Create Database Tables

Question 1

The first column of a new table is named ________.

A) AutoNumber
B) Name
C) ID
D) SS#

Answer 1

C

Question 2

Use the ________ button to adjust the entire datasheet's column widths at once.

A) Select All
B) Row Selector
C) Column Border
D) Select Records

Answer 2

A

Question 3

Each column in a datasheet is a(n) ________ such as city, state, or postal code.

A) field
B) record
C) query
D) abstract

Answer 3

A

Question 4

The blank row of a table where new data is entered is called the ________ row.

A) add
B) new
C) insert
D) append

Question 5

A field that automatically enters a unique, numeric value when a record is created is a(n) ________.

A) primary key
B) AutoNumber
C) Best Fit
D) Short Text

Question 6

When you save a table that has been added or changed, its name displays in the ________.

A) title bar
B) Navigation Pane
C) status bar
D) database file

Question 7

The ________ menu allows you to select records with the values you choose.

A) Filter
B) Context
C) Tools
D) Start

Question 8

The Date/Time data type stores data as ________.

A) numeric values
B) text
C) serial numbers
D) monetary values

Question 9

The Enforce Referential Integrity option is available from the ________ dialog box.

A) File
B) Get External Data
C) Edit Relationships
D) List

Question 10

Records in two tables can be related by placing the same ________ in both tables.

A) record
B) field
C) query
D) property

Question 11

________ can be used to view a report before it is sent to the printer.

A) Live Preview
B) Design view
C) Print Preview
D) Datasheet view

Question 12

A(n) ________ displays related records from a table on the one side of the relationship.

A) entity relationship
B) macro
C) subdatasheet
D) design grid

Question 13

In a ________, the user can edit the primary key value in a table and all the related records in the other table will update accordingly.

A) cascading update
B) datasheet
C) relationship report
D) cascading delete

Question 14

Database ________ store the data in rows and columns.

A) forms
B) tables
C) reports
D) objects

Question 15

An alternate method for creating a table is to create it in ________ view.

A) Design
B) Datasheet
C) Layout
D) Property

Question 16

________ limits the number of characters that can be typed into a text or number field.

A) Caption
B) Column width
C) Field size
D) Field name

Question 17

You can add tables to the Relationships tab by ________ them from the Navigation Pane.

A) dragging
B) pasting
C) cutting
D) duplicating

Question 18

A(n) ________ is a collection of related information that displays in a single row of a database table.

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

Question 19

If you will often import data from the same Excel workbook to Access, you can ________ the import steps.

A) save
B) delete
C) overwrite
D) export

Question 20

When creating a table, the ________ indicates what kind of information will be stored in a field.

A) criteria
B) layout
C) Data Type
D) caption

Question 21

You can ________ data from an Excel spreadsheet into an Access table by using the appropriate wizard.

A) export
B) import
C) link
D) embed

Question 22

To change the row color in a datasheet, click the ________ arrow from the Datasheet Formatting dialog box.

A) Gridline Color
B) Border and Line Styles
C) Alternate Background Color
D) Color Banding

Question 23

Access draws a relationship ________ between two tables.

A) line
B) column
C) pie
D) bar

Question 24

A table's page layout settings cannot be ________.

A) saved
B) changed
C) opened
D) previewed

Question 25

The default file format for Access 2013 is Microsoft Access 2007-2013.

Question 26

To filter records with the values you choose, your first step is to ________.

A) clear the (Select All) check box
B) uncheck each check box individually
C) click the Erase button
D) select Remove Filter

Question 27

Field names and captions must be the same.

Question 28

Ascending order means records have been sorted by ________.

A) the last-applied sort order
B) default sort order
C) smallest to largest value
D) largest to smallest value

Question 29

A table's page layout settings can be saved so they are applied the next time the table is opened.

Question 30

A layout that is taller than it is wide is ________.

A) Portrait
B) Custom
C) Landscape
D) Vintage

Question 31

Reuse a database is an option on the Access start page.

Question 32

The ________ command prints the object without letting you make adjustments.

A) Print
B) Quick Print
C) Print Preview
D) Print Properties

Question 33

Primary key field names often include ID to help identify them.

Question 34

The sort order and filter that a user creates in a datasheet are saved as a part of the table's design.

Question 35

You can hide a field in a datasheet.

Question 36

While importing an Excel spreadsheet into Access, if the user chooses Append a copy of the records to the table but the table does not exist, Access will ________.

A) create the table
B) indicate an error
C) create a link to the data
D) erase the data

Question 37

In Print Preview, if your document is more than one page, use the ________ to view the other pages.

A) title bar
B) status bar
C) scroll bar
D) navigation bar

Question 38

An Excel worksheet CANNOT be imported into a new table.

Question 39

The Currency data type stores numbers formatted as monetary values.

Question 40

Referential integrity rules allow you to enter a Contractor ID that does not exist in the related Contractors table.

Question 41

When you close a database table, the database closes.

Question 42

In the Import Spreadsheet Wizard, it is not necessary to view sample data or verify that the field names in the header row match.

Question 43

You can assign a name and location for the database file any time after entering data.

Question 44

When you create a blank database, a new table is automatically started for you.

Question 45

In Design view, the Field Name, Data Type, and Description data are entered in rows.

Question 46

An Excel worksheet that organizes data into rows and columns can be imported into an existing table.

Question 47

Once an AutoNumber value has been assigned, it CANNOT be changed.

Question 48

When a table is on the many side of a relationship, a subdatasheet is available that displays related records from the one side of the relationship.

Question 49

A relationship where a record in the first table can have many associated records in the second table is called a many-to-many relationship.

Question 50

The Date Picker feature allows the user to enter dates by clicking on a calendar.

Question 51

You do not need to save new or changed data before navigating to a new record.

Question 52

Table Design view is a view that features table fields and their properties.

Question 53

A foreign key is often the second table's primary key.

Question 54

While importing an Excel spreadsheet into Access, if the user chooses Append a copy of the records to the table and the table exists, Access will add the records to the table.

Question 55

One-to-many relationships enforce referential integrity.

Question 56

If an Excel workbook contains multiple worksheets, it will automatically import Sheet1.

Question 57

When you import data from Excel, it is best practice to insert the table's field names in the spreadsheet's header row.

Question 58

Column widths CANNOT be changed to match the width of their contents.

Question 59

With a cascading update, the user can edit the primary key value in a table, and all the related records in the other table will update.

Question 60

A datasheet displays records in rows and columns similar to an Excel spreadsheet.

Question 61

If you have applied and saved a filter to a datasheet, the filter will be applied each time you open the table.

Question 62

You can ________ data from an Excel spreadsheet into an Access table.

Question 63

The feature that allows a user to enter dates into Date/Time fields by clicking on a calendar is called the Date ________.

Question 64

Landscape is a layout that is wider than it is tall.

Question 65

When a user changes the font or font size in a datasheet, changes are applied only to the column where the insertion point was located when the change was made.

Question 66

If the buttons on the navigation bar are dimmed, the table will print on more than one page.

Question 67

Portrait is the default view that is applied each time a table is opened.

Question 68

________ integrity is a rule that keeps related values synchronized.

Question 69

A(n) ________ key is a field used to relate records in a second table.

Question 70

To print data from a table, a user typically creates a report.

Question 71

________ view lists all the fields with their data types and properties but not actual records.

Question 72

You must save your data and database objects before quitting Access.

Question 73

The name ________ is temporarily assigned to the new table that opens automatically when a blank database is created.

Question 74

A set of fields that can be added to a table with a single click are called ________ Start data types.

Question 75

The column ________ changes to indicate that records have been sorted.

Question 76

The ________ row is a row of a table in which a new record can be entered.

Question 77

The database object that stores the data is a(n) ________.

Question 78

The Print command enables you to select different print options.

Question 79

The direction of the sort arrow at the top of a column indicates whether an ascending or descending sort was performed.

Question 80

Records in a table are sorted by their primary key.