Deck 67: Database Tables

Question 1

Once a field is created in a table,it cannot be subsequently moved to a new location in the table because this action corrupts the database.

Answer 1

False

Question 2

Before you can enter data into a database,you must create a ____ to hold the data.

A) table
B) query
C) relationship
D) form

Answer 2

A

Question 3

Data separated by commas within an imported text file is interpreted by Access as delimited content.

Answer 3

True

Question 4

Access tables contain individual rows,which are arranged in records.

Question 5

Design view allows you to check data types,field properties,and descriptions in your database table.

Question 6

Access tables can be created in either Datasheet or Design view.

Question 7

A primary key uniquely identifies a given record within the database.

Question 8

Joining fields lets you extract data from two or more tables through a query.

Question 9

Once a field is created in a table,it cannot be renamed.

Question 10

When importing Excel data into Access,the data can be used to create a new table.

Question 11

When you initially open Access,a list of the most recently opened databases appears.

Question 12

When importing an existing Access table into an Access database,if you do not want to import the structure,you can choose to import only its data.

Question 13

A customer's last name is a good example of a primary key.

Question 14

When opening a file from a trusted source,if needed,click the orange "Enable Editing" security warning button to work in the file.

Question 15

When an Excel worksheet containing column headings is imported into Access,they can be used as field names in a new table.

Question 16

In Access,related fields are grouped in the Data Type Gallery for quick and easy access.

Question 17

The Field Size setting specifies the number of characters you can store in a field.

Question 18

To use a database for decision making,you must first create multiple,independent tables.

Question 19

A database field name should contain spaces.

Question 20

Access databases cannot be imported into each other.

Question 21

Rows in a spreadsheet are akin to ____ in a database table.

A) rows
B) records
C) fields
D) data types

Question 22

You need to store the names of your customers in a new database.How should this be accomplished?

A) Create one field to hold both the first and last name of the customer.
B) Create a table for the customer's name.
C) Create a field for the first name and another field for the last name.
D) Create a table for the first name and another table for the last name.

Question 23

When you specify the kind of data to put in the field you want to create,you are selecting the ____ for the field.

A) data type
B) name
C) ID
D) key

Question 24

The default field size for a text field is ____ characters.

A) 25
B) 128
C) 192
D) 255

Question 25

To import only an Access table's structure and not its data,choose the ____ option in the Import Tables box.

A) Import Objects
B) Import & Link
C) Definition Only
D) Quick Access

Question 26

Which of the following is a good example of a primary key?

A) last name
B) bank account number
C) city
D) street address

Question 27

Using the ____ category allows you to add certain groups of fields as a collection rather than adding one field at a time.

A) Primary Key
B) Quick Start
C) Data Type
D) Database

Question 28

To begin importing Excel data into Access,click on the ____ tab.

A) EXTERNAL DATA
B) CREATE
C) DATABASE TOOLS
D) FILE

Question 29

By default,in Access,a ____ named ID appears in every new table.

A) record
B) row
C) field
D) chart

Question 30

In Access,the default table view is ____ view.

A) Design
B) Datasheet
C) Sorter
D) Record

Question 31

When you create a field to hold a customer's name,you should select the ____ data type.

A) Autonumber
B) Memo
C) Short Text
D) PhoneNum

Question 32

Creating a ____ sets up a relationship between tables that share a common field.

A) join
B) table
C) field
D) primary key

Question 33

When you use the Data Type Gallery,____.

A) unrelated fields can be added to a table one at a time
B) unrelated fields can be added to a table simultaneously
C) related fields can be added to a table one at a time
D) related fields can be added to a table simultaneously

Question 34

Columns in a spreadsheet are akin to ____ in a database table.

A) rows
B) records
C) fields
D) data types

Question 35

Before you can enter data into records,you need to create the ____ that will contain this data.

A) rows
B) fields
C) relationships
D) forms

Question 36

A foreign key matches the ____ column of another table that has been cross referenced.

A) input mask
B) short text
C) primary key
D) input

Question 37

You are ready to import a text file containing data into Access.To get started,you need to ____.

A) export the file from Word
B) open the file in Word
C) open Access
D) export the file from a supported text editor

Question 38

You need to create a new field in a database table.Select the best option from the following list for naming a field that will contain a company's name.

A) Company Name
B) Co.Name
C) CoName
D) CompanyName

Question 39

Column headings from a spreadsheet that was imported into Access will become ____ in a new table.

A) data types
B) field names
C) captions
D) primary keys

Question 40

The mask property allows you to create a template for an input field such as a(n)____ that requires a specific format.

A) caption
B) address
C) phone number
D) description