Deck 2: Databases and Database Objects: an Introduction

Question 1

Database ____ refers to the arrangement of data into tables and fields.

A) language
B) relations
C) design
D) management

Answer 1

C

Question 2

In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a ____ .

A) container
B) repository
C) placeholder
D) database

Answer 2

D

Question 3

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 25
5)

A) Unlimited
B) Memo
C) Variable
D) Character

Answer 3

B

Question 4

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

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

Question 5

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

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

Question 6

One way to create a table, is to click ____ on the Ribbon and then click the Table button.

A) New
B) Create
C) Add
D) Insert Table

Question 7

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

A) Picture
B) Image
C) OLE Object
D) Bitmap

Question 8

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

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

Question 9

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) AutoNumber
C) Incremental
D) AutoSequence

Question 10

In the accompanying figure, the key symbol that appears in the row selector for the Business Analyst Number field indicates that Business Analyst Number is the ____ for the table.

A) principal key
B) foreign key
C) primary key
D) main key

Question 11

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

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

Question 12

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

A) Alpha
B) Text
C) Normal
D) Lookup

Question 13

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

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

Question 14

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) Caption
C) Format
D) Description

Question 15

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

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

Question 16

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

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

Question 17

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.

A) Field1
B) ID
C) AutoCode
D) TableCode

Question 18

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

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

Question 19

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

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

Question 20

Access is a ____.

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

Question 21

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

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

Question 22

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

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

Question 23

In the accompanying figure, the small box or bar to left of each field is called the ____.

A) row selector
B) field selector
C) field bar
D) current field bar

Question 24

To import data to a table, click the ____ tab on the Ribbon.

A) Database Tools
B) File
C) Import
D) External Data

Question 25

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

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

Question 26

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

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

Question 27

To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu

A) Table Design
B) Design View
C) Structure View
D) Layout View

Question 28

To delete a record, 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 29

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

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

Question 30

To save the changes to the layout of a table, click the Save button on the _____.

A) Status bar
B) Table Tools tab
C) Navigation Pane
D) Quick Access Toolbar

Question 31

To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab.

A) Portrait/Landscape
B) Orientation
C) Landscape
D) Switch Orientation

Question 32

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

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

Question 33

To create an initial report that can be modified in Layout view, click ____ on the Create tab.

A) Layout
B) Report
C) Report Layout
D) Simple Report

Question 34

To back up a database, use the Back Up Database command on the ____ tab in the Backstage view.

A) Save Object As
B) Save & Publish
C) Tools
D) Options

Question 35

To open the Navigation Pane, click the ____ Button.

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

Question 36

To create a query using the Query Wizard, click ____ on the Ribbon and then click the Query Wizard button.

A) Insert
B) New Object
C) Create
D) Report

Question 37

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

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

Question 38

In the accompanying figure, the Business Analyst Table displays in ____.

A) Structure view
B) Layout view
C) Design view
D) Table view

Question 39

To quit Access, click the ____ button on the right side of the title bar.

A) Quit
B) Stop
C) End
D) Close

Question 40

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

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

Question 41

A unique identifier also is called a record key.

Question 42

Modified Multiple Choice You can create a table in ____.

A) Design view
B) Blank view
C) Datasheet view
D) Layout view

Question 43

The Status bar contains a list of all the objects in the database.

Question 44

One way to undo changes to a field is to click the Undo button on the Quick Access Toolbar.

Question 45

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

Question 46

Redundancy is the storing of a piece of data in more than one place.

Question 47

Modified Multiple Choice Table names cannot contain _____.

A) square brackets [ ]
B) periods (.)
C) hyphens (-)
D) accent graves (')

Question 48

Modified Multiple Choice 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 49

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

Question 50

Modified Multiple Choice File names cannot contain a(n) ____.

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

Question 51

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

Question 52

In Access, table names cannot contain digits.

Question 53

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

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

Question 54

As shown in the accompanying figure, you can use the End record button to move to the last record in the table.

Question 55

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

Question 56

In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.

Question 57

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

Question 58

As shown in the accompanying figure, you can move to the end of a table to a position for entering a new record by clicking the Add record Navigation button.

Question 59

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

Question 60

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 25
5.

Question 61

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

Question 62

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

Question 63

The rows in the tables are called ____________________.

Question 64

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

Question 65

As shown in the accompanying figure, you can move to the first record in a table by clicking the First record Navigation button.

Question 66

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

Question 67

The TextCheck feature of Access corrects common mistakes when entering text in a cell.

Question 68

A field that has an AutoIncrement data type can store a unique sequential number that Access assigns to a record.

Question 69

The Database Tools tab provides commands to compact and repair a database.

Question 70

Form view displays a single record at a time.

Question 71

A unique identifier also is called a(n) ____________________.

Question 72

____________________ is the storing of a piece of data in more than one place.

Question 73

A soft copy is information that exists on a physical medium such as paper.

Question 74

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

Question 75

Green computing involves reducing the environmental waste generated when using a computer.

Question 76

To move a field, click the row selector for the field to be moved to select the field, and then drag the field to the desired position.

Question 77

A(n)____________________ is a software tool 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 in the database.

Question 78

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

Question 79

To rename a field, right-click the column heading for the field, and then click Rename Field on the shortcut menu.

Question 80

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