Deck 11: Access_Module_1

Question 1

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

Answer 1

False

Question 2

When Access first creates a database, it automatically creates a table.

Answer 2

True

Question 3

Form view displays a single record at a time.

Answer 3

True

Question 4

Changing the column width in a datasheet changes the structure of a table.

Question 5

In Datasheet view, a table is represented as a collection of rows and columns called a list.

Question 6

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

Question 7

In Access, field names cannot contain digits.

Question 8

One way to undo changes to a field is to click the Undo button on the status bar.

Question 9

Landscape orientation means the printout is across the length (height) of the page.

Question 10

The Currency data type is used for fields that contain only monetary data.

Question 11

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

Question 12

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

Question 13

A unique identifier is also called a primary key.

Question 14

The Navigation Pane contains a list of all the objects in the database.

Question 15

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

Question 16

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

Question 17

Layout view shows a report on the screen and allows the user to make changes to the report.

Question 18

To preview and then print the contents of a table, use Table Preview.

Question 19

In Access, the columns in a table are called records.

Question 20

Redundancy means storing the same fact in more than one place.

Question 21

A field whose data type is ____ can store text that can be used as a hyperlink address.

A)URL
B)Web
C)Placeholder
D)Hyperlink

Question 22

Access is a ____.

A)word processing software tool
B)file management system
C)workbook management system
D)database management system

Question 23

The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________

Question 24

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click Insert Column on the shortcut menu. ____________________

Question 25

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

A)alternate
B)caption
C)abbreviation
D)tag

Question 26

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

A)Memo
B)Long Text
C)Variable
D)Character

Question 27

In Access, table and field names can be up to ____ characters in length.

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

Question 28

A field whose data type is ____ can contain any characters.

A)Alpha
B)Character
C)Normal
D)Short Text

Question 29

To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.

A)Cancel
B)Reverse
C)Back
D)Undo

Question 30

A(n) ____ contains information about a given person, product, or event.

A)attribute
B)record
C)field
D)column

Question 31

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

A)Attachment
B)File
C)Document
D)Extend

Question 32

____ words are words that have a special meaning to Access and cannot be used for the names of fields.

A)Reserved
B)Restricted
C)Significant
D)Tagged

Question 33

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

A)tabular
B)record
C)attribute
D)relational

Question 34

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

A)Sequential
B)ValueIncrement
C)Incremental
D)AutoNumber

Question 35

To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu. ____________________

Question 36

To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.

A)Remove Field
B)Delete Field
C)Delete Column
D)Remove Column

Question 37

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

A)Illustration
B)Image
C)Bitmap
D)OLE object

Question 38

To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu. ____________________

Question 39

A field that has the Calculated data type can store a unique sequential number that Access assigns to a record. ____________________

Question 40

To define an additional field in Datasheet view, tap or click the ____ column heading.

A)New Field
B)Add Field
C)Click to Add
D)Insert Field

Question 41

The Access window consists of a variety of components. These include the ____.

A)Navigation Pane
B)Content pane
C)Object tabs
D)Quick Access Toolbar

Question 42

A field with a Yes/No data type can store only one of two values. The choices are ____.

A)True/False
B)One/Zero
C)Yes/No
D)On/Off

Question 43

File names cannot contain a(n) ____.

A)question mark (?)
B)colon (:)
C)space
D)underscore (_)

Question 44

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

A)Open
B)SQL
C)Query Window
D)Design View

Question 45

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.

A)Insert Column
B)Insert Field
C)Add Column
D)Add Field

Question 46

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

A)Restore
B)Fix
C)Compaction
D)Compact & Repair

Question 47

A(n)____________________ is software that can be used to create a database; add, change, and delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data.

Question 48

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

A)Customize
B)Manage
C)Options
D)Grammar

Question 49

To open the Navigation Pane, tap or click the ____ Button.

A)Open Navigation Pane
B)Open Pane
C)Shutter Bar Open/Close
D)Navigation Bar Show/Hide

Question 50

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

A)Datasheet View
B)Open
C)Results View
D)Run

Question 51

To add a record to a table, tap or click the ____ record button.

A)Add New
B)New (blank)
C)Last
D)Insert (New)

Question 52

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

A)Erase
B)Trash
C)Delete
D)Remove

Question 53

To import data to a table, tap or click the ____ tab on the ribbon.

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

Question 54

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

A)Change Column
B)Rename Column
C)Change Field
D)Rename Field

Question 55

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

A)CTRL+DELETE
B)CTRL+Y
C)DELETE
D)CTRL+K

Question 56

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

A)Field Size
B)Format
C)Caption
D)Description

Question 57

You can place an insertion point by tapping or clicking in the field or by pressing ____.

A)F2
B)F3
C)F4
D)F5

Question 58

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

A)Close and Back Up
B)Back Up Current
C)Save As Back Up
D)Back Up Database

Question 59

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

A)New Name
B)Redefine
C)Rename
D)Save Name

Question 60

To save the changes to the layout of a table, tap or click the Save button on the ____.

A)status bar
B)TABLE TOOLS tab
C)Navigation Pane
D)Quick Access Toolbar

Question 61

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____________________ on the shortcut menu.

Question 62

Critical Thinking Questions
Case 1-2
Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table.
What data type should Joe use for the Completion Date field?

Question 63

Critical Thinking Questions
Case 1-1
Joe has been asked to create a Special Projects database for his company. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables:
Employee (Social Security Number, Last Name, First Name, Street Address, City, State,
Postal Code, Hourly Pay Rate, Project Code)
Project (Project Code, Project Name, Total Hours, Completion Date)
Which field in the Employee table should be the primary key and why?

Question 64

A hard copy or ____________________ is information that exists on a physical medium such as paper.

Question 65

A(n) ____________________ contains a specific piece of information within a record.

Question 66

Designing to omit ____________________ will help to produce good and valid database designs.

Question 67

To define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

Question 68

The ____________________ data type in Access is referred to as Money in SQL Server.

Question 69

The rows in the tables are called ____________________.

Question 70

Critical Thinking Questions
Case 1-2
Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table.
What data type should Joe use for the Social Security Number field? Why?

Question 71

Society encourages users to contribute to ____________________ computing, which involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.

Question 72

____________________ refers to the process of determining the tables and fields that make up the database.

Question 73

____________________ view has more functionality for creating a table than Datasheet view.

Question 74

Critical Thinking Questions
Case 1-1
Joe has been asked to create a Special Projects database for his company. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables:
Employee (Social Security Number, Last Name, First Name, Street Address, City, State,
Postal Code, Hourly Pay Rate, Project Code)
Project (Project Code, Project Name, Total Hours, Completion Date)
Which field in the Project table should be the primary key and why?

Question 75

The determination of database requirements is part of a process known as ____________________.