Deck 17: Creating a Database

Question 1

Each table in a database is stored as a separate file.

Answer 1

False

Question 2

An empty table does not contain any fields.

Answer 2

False

Question 3

Elements that make up the database include tables, requests , forms, and queries.

Answer 3

False

Question 4

Each row in a database table represents a field.

Question 5

Use the AutoNumber data type for fields that contain numeric data.

Question 6

When editing the data use the Delete key to delete text to the left of the insertion point.

Question 7

Access provides several tools you can use to manipulate the database, and they are contained in the Navigation Pane on the right side of the database window.

Question 8

After a query is saved, you can run it repeatedly to display all the records that match the criteria you've specified.

Question 9

A(n) record contains a single unit of information.

Question 10

The way databases appear on the screen is similar to the way they will look when printed.

Question 11

Microsoft Excel is the component of the Microsoft Office suite best suited for working with large collections of data.

Question 12

Use the Short Text data type for fields that contain variable length data, such as comments, notes, and reviews.

Question 13

A new database is an empty shell.

Question 14

Data import options are listed on Access's IMPORT/EXPORT DATA tab.

Question 15

Creating a new database simply makes a file that becomes the container for all database elements.

Question 16

Access saves each record as you enter it.

Question 17

When you create a new database, Access creates an empty table called Table1.

Question 18

An ID field's data type is IntNumber .

Question 19

Fields names cannot contain spaces.

Question 20

To open a table the next time you start Access, open the database and then right-click the table name in the Navigation Pane.

Question 21

You should use the _____ data type for fields that contain words and symbols of up to 255 characters in length.

A) Short Text
B) Long Text
C) Number
D) AutoNumber

Question 22

A _____ contains one record.

A) cell
B) column
C) row
D) table

Question 23

What is the maximum length for a field name?

A) 32 characters
B) 64 characters
C) 16 characters
D) 20 characters

Question 24

When you start Access, which of the following options are available?

A) create a new database only
B) save a database
C) open an existing database only
D) create a new database or open an existing one

Question 25

Which of the following contains information about a single entity in the database?

A) a form
B) a field
C) a query
D) a record

Question 26

Access provides tools you can use to manipulate data in the database and they are contained in the _____.

A) Navigation Pane
B) Manipulation Pane
C) Navigation Toolbar
D) HOME tab

Question 27

Which of the following buttons should you click to open the File New Database dialog box?

A)
B)
C)
D)

Question 28

Which of the following contains a single fact that describes an entity?

A) a report
B) a field
C) a form
D) a record

Question 29

A _____ is composed of fields and records.

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

Question 30

Which of the following buttons is a Create button?

A)
B)
C)
D)

Question 31

Creating a new database simply makes a(n) _____ that becomes the container for the tables, data, queries, and reports.

A) object
B) document
C) file
D) spreadsheet

Question 32

The Short Text data type is used for fields that contain words and symbols of up to _____ characters in length.

A) 128
B) 256
C) 255
D) 64

Question 33

Each category of data is stored in a database _____.

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

Question 34

You should use the _____ data type for fields that contain True/False values.

A) Short Text
B) AutoNumber
C) Number
D) Yes/No

Question 35

All of the following are elements that make up the database, except _____.

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

Question 36

When you create a new database, Access creates an empty table called _____.

A) Access Table1
B) Database Table1
C) New Table
D) Table1

Question 37

You should use the _____ data type for fields that contain variable length data, such as comments, notes, and reviews.

A) Short Text
B) Long Text
C) Number
D) AutoNumber

Question 38

The data type for telephone numbers should be defined as _____.

A) Short Text
B) Long Text
C) Number
D) AutoNumber

Question 39

When a database is open, it is displayed in the Access _____ window.

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

Question 40

Microsoft Access is designed for creating and accessing _____ databases.

A) dynamic
B) relational
C) distributed
D) personal

Question 41

New records are added _____.

A) at the beginning of the table
B) at a random location in the table
C) at the location specified by user
D) at the end of the table

Question 42

Import options are listed on Access's _____ tab.

A) EXTERNAL DATA
B) EXPORT DATA
C) IMPORT DATA
D) DATABASE TOOLS

Question 43

To open a table that was created peviously, you have to start Access, open the database, and then _____ the table name in the Navigation Pane.

A) double-click
B) left-click
C) click
D) right-click

Question 44

You can modify data within a field using Backspace, Delete, and typing keys. To complete the modification you should press the _____ key.

A) Ctrl + Shift
B) Esc
C) Enter
D) Shift + Enter

Question 45

After opening a New Query window, which of the following would you usually select?

A) Crosstab Query Wizard
B) Simple Query Wizard
C) Find Duplicates Query Wizard
D) Find Unmatched Query Wizard

Question 46

When a table is open, the ribbon includes the _____ contextual tab for working with individual fields and records.

A) DATA TOOLS
B) TABLE TOOLS
C) DATABASE TOOLS
D) FIELD TOOLS

Question 47

Referring to the accompanying figure, which callout points to the button you can click to create simple queries quickly?

A) E
B) B
C) C
D) H

Question 48

All of the following are controls for operations that can be performed on a table, except _____.

A) Delete a record
B) Sort records
C) Move a record
D) Search

Question 49

Which of the following fields is designed to be used as the primary key in an empty table?

A) AutoNumber
B) Primary Key
C) ID
D) Identifier

Question 50

The field that uniquely identifies records in a table is called a(n) _____.

A) secondary key
B) primary key
C) search key
D) identifier

Question 51

The _____ key is used to delete text to the left of the insertion point.

A) Delete
B) Shift + Delete
C) Backspace
D) Shift + Backspace

Question 52

To identify the table you should give it a(n) _____ name.

A) unique and short
B) numeric
C) unique and descriptive
D) automatically generated

Question 53

A comma-delimited file is simply data separated by commas, and it is referred as a _____ file.

A) CDF
B) CSV
C) CSD
D) CDD

Question 54

When entering data, you can use the _____ key(s) to move from one field to the next without having to move your hand to the mouse.

A) Ctrl+Tab
B) Ctrl+Alt
C) Esc
D) Tab

Question 55

The field you use for the primary key should have a checkmark in the _____ box.

A) Required
B) Indexed
C) Validated
D) Unique

Question 56

By default, the data type for the primary key is _____.

A) Number
B) AutoNumeric
C) AutoNumber
D) UniqueNumber

Question 57

Which of the following icons should you click to save the table?

A)
B)
C)
D)

Question 58

To delete an entire record, _____ the row header containing the record, click Delete Record, then click the Yes button.

A) right-click
B) click
C) left-click
D) double-click

Question 59

Referring to the accompanying figure, which callout points to the tab that should be clicked first to build a query?

A) A
B) B
C) D
D) H

Question 60

Which of the following buttons should you click to add all fields to the query?

A)
B)
C)
D)

Question 61

To define a field for a table, you begin by selecting a(n) ____________________.

Question 62

Case Based Critical Thinking Questions Case 17-1 Maxwell has developed a Movies database. He presented his design to his class, and some of his listeners had questions. Here is one of the tables Maxwell showed to the audience. Kyra asks how to select all movies that received an award between 1940 and 1955. Maxwell tells her that the query criteria for the Award Year field should be: _____.

A) >= 1940 AND <= 1955
B) >= 1940 OR <= 1955
C) = 1940 AND = 1955
D) HIGHER THAN 1940 AND LOWER THAN 1955

Question 63

To open a table, double-click the name of the table in the ____________________.

Question 64

The primary key is an important field in an Access table. Please describe a primary key. Does Access create the primary key or can you create it yourself?

Question 65

Case Based Critical Thinking Questions Case 17-1 Maxwell has developed a Movies database. He presented his design to his class, and some of his listeners had questions. Here is one of the tables Maxwell showed to the audience. Referring to the accompanying figure, James asks which of the columns is a primary key. Maxwell points to _____.

A) A
B) B
C) C
D) D

Question 66

Each category of data is stored in a database ____________________.

Question 67

Case Based Critical Thinking Questions Case 17-1 Maxwell has developed a Movies database. He presented his design to his class, and some of his listeners had questions. Here is one of the tables Maxwell showed to the audience. Referring to the accompanying figure, Leon asks which of the following fields uses a Number data type. What field does Maxwell point to?

A) Film Title
B) Director
C) MPAA
D) Nominations

Question 68

To enter the field name, simply type it, then press the ____________________ key.

Question 69

A(n) ____________________ file is simply data separated by commas.

Question 70

A(n) ____________________ database is very flexible because it can store data for several different but related categories.

Question 71

The quickest way to save a table is to click the Save button on the ____________________ toolbar.

Question 72

When you create a table you must specify a data type for each field. Please describe each of these data types: Date & Time, Number, AutoNumber, Yes/No.

Question 73

A primary key is a field that ____________________ identifies each record.

Question 74

New records are always added at the ____________________ of the table.

Question 75

A(n) ____________________ contains criteria that specify what you would like to find.