Deck 10: Creating a Database

Question 1

In Design view, you use a grid to enter fields and specify field data types.

Answer 1

True

Question 2

Short Text is a(n) data type

Answer 2

True

Question 3

Tables, forms, queries, and reports are program components called objects

Answer 3

True

Question 4

It is easier to add fields to new or existing tables in Datasheet view.

Question 5

A database is an organized collection of unrelated information.

Question 6

Creating a database from a(n) template saves time since it contains many ready-made database objects

Question 7

A relational database contains only one table.

Question 8

Access is a database management system

Question 9

A query extracts data from one or more database tables according to criteria that you set.

Question 10

Each row in a database table is called a(n) record

Question 11

When you start working in a new database, a blank form opens in Datasheet view

Question 12

When you save a database, all of the database objects within it are automatically saved too.

Question 13

Every new table in Access includes a blank ID field which is automatically designated as the primary key field

Question 14

A(n) form extracts data from one or more database tables

Question 15

You can save a table in Datasheet view by clicking the Save button on the Quick Access toolbar.

Question 16

A form is a summary of database information specifically designed for printing.

Question 17

Each text box in a(n) form corresponds with a field in a table. 

Question 18

To add a field to a table, you need to specify its data type.

Question 19

Every table in a database must contain one field that is designated as the ID key field

Question 20

The column headings in a database table are called field names.

Question 21

In the accompanying figure, item 2 points to the ____.

A) record
B) report
C) ID field
D) ID

Question 22

In the accompanying figure, item 2 points to the ____.

A) Office Default template
B) Access 2010 template
C) available template categories
D) Blank desktop database

Question 23

In the accompanying figure, item 1 points to the____.

A) featured templates
B) recently opened databases
C) available template categories
D) Blank Database icon

Question 24

In the accompanying figure, item 3 points to the ____.

A) featured templates
B) recently opened databases
C) saved template categories
D) Blank templates

Question 25

A(n) ____ extracts data from one or more database tables according to criteria that you set.

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

Question 26

In the accompanying figure, item 1 is the name of the only ____ in the database.

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

Question 27

A(n) ____ is a user-friendly window that contains text boxes and labels that let users easily input data, usually one record at a time.

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

Question 28

A database stores data in one or more spreadsheet-like lists called ____.

A) cells
B) records
C) tables
D) sheets

Question 29

In the accompanying figure, the words Short Text refer to a ____.

A) record
B) data type
C) field name
D) set of tables

Question 30

Field ____ are data characteristics that dictate how Access stores, handles, and displays field data.

A) descriptions
B) names
C) properties
D) descriptors

Question 31

In the accompanying figure, item 3 points to ____.

A) the fields in the table
B) field properties
C) all of the table types you can add to a datasheet
D) all of the data types you can apply to a field

Question 32

In Datasheet view, the left pane below the Ribbon is called the ____ pane. It is where all database objects for the open database are listed.

A) Navigation
B) Database
C) Objects
D) Data

Question 33

To insert a new field, click an existing field and then click the Insert ____ button in the Tools group.

A) Rows
B) Fields
C) New Field
D) Columns

Question 34

You can create a database in Access by starting with a ____.

A) blank database
B) template
C) Both a and b.
D) None of the above.

Question 35

If the ____ for Manager Last Name is Last Name, that means that only Last Name will be displayed as the field name for this field in Datasheet view.

A) property
B) ID
C) nickname
D) caption

Question 36

Records consist of  ____, which contain information about one aspect of a record.

A) objects
B) reports
C) queries
D) fields

Question 37

As a ____ database management system, Access is particularly powerful because you can enter data once and then retrieve information from all or several tables as you need it.

A) relational
B) simple
C) complex
D) manipulative

Question 38

A database containing just one table is called a ____ database.

A) simple
B) relational
C) query
D) report

Question 39

A(n) ____ is a summary of information pulled from a database, specifically designed for printing.

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

Question 40

A database containing two or more tables of related information is called a ____ database.

A) simple
B) relational
C) complex
D) related

Question 41

Describe the difference between a simple and a relational database.

Question 42

The border between field names is called the ____.

A) border separator
B) border divider
C) column separator
D) column divider

Question 43

You can use _____________________ to create a database to help you manage and track a large collection of related data.

Question 44

The ____ data type assigns a unique number for each record in the table.

A) AutoNumber
B) UniqueNumber
C) AutoSet
D) AutoList

Question 45

Describe the operations you can perform when a table is in Design view.

Question 46

_____ controls are devices for inputting data such as text boxes, list arrows, or check boxes.

A) Input
B) Form
C) Data
D) Text

Question 47

The data you enter in each field is called a field ____.

A) object
B) name
C) value
D) pane

Question 48

The Caption property appears in a form or in Datasheet view in place of the field ____.

A) icon
B) group
C) name
D) property

Question 49

To view different records you use buttons on the _____________________ bar.

Question 50

You can edit text in fields by selecting it and typing new text or using the [____] key.

A) Data
B) Edit
C) Tab
D) Backspace

Question 51

Split view is a(n) _____________________ that displays the data entry form above the underlying datasheet.

Question 52

Describe how a database stores data.

Question 53

The field description appears in the ____ bar and helps users understand what type of data should be entered for the field.

A) properties
B) status
C) address
D) navigation

Question 54

The simplest way to create a form is to click the Form button on the _______________ tab.

Question 55

Text boxes, check boxes and list arrows are all ___________________ controls.

Question 56

In  _____________________ view, you can view records but cannot add, delete or edit records.

Question 57

To close Access, click Close on the _________________ tab.

Question 58

Field Size is an example of a field ____.

A) property
B) name
C) ID
D) caption

Question 59

A(n) ____ selector to the left of each record lets you select a record or records.

A) row
B) record
C) object
D) key

Question 60

When you click a field name to add a new record, the field ____ appears in the status bar.

A) description
B) type
C) size
D) category

Question 61

You work in the human resources department of a large company that uses Microsoft Access to track information before and after entering it into the company's administrative system.
Your boss asks you for specific field values. What are field values?

Question 63

You work in the human resources department of a large company that uses Microsoft Access to track information before and after entering it into the company's administrative system.
Your supervisor has asked you to add a field description to a field in the table. How can you do this?

Question 64

You work for a small pet shop and the store manager asks you to convert some of his paper records to an online system. A simple database exists and the owner wants to add to the existing database.
Your supervisor wants a list of all the customers who purchased something recently from the store.  Can you do this with the current database design?

Question 65

You work for a small pet shop and the store manager asks you to convert some of his paper records to an online system. A simple database exists and the owner wants to add to the existing database.
Assuming that the existing database does not contain information related to sales in the table, how can you extend the database to track the purchases for each customer?

Question 66

You work for a small pet shop and the store manager asks you to convert some of his paper records to an online system. A simple database exists and the owner wants to add to the existing database.
Assuming you can extend the database with every possible need for the store, what objects must be included in addition to the table(s) that make up the database?