Deck 2: Getting Started With Access 2.0

Question 1

Tables contain all of the data in the database.

Answer 1

True

Question 2

Pressing [Ctrl][;] will insert the current date in a Date field.

Answer 2

True

Question 3

Press [Esc] once to undo a change to the current field.

Answer 3

True

Question 4

A primary key field uniquely identifies each record.

Question 5

You can move datasheet columns by dragging the field name left or right.

Question 6

More than one person can be entering, updating, and using an Access database at the same time.

Question 7

The Navigation buttons on a datasheet display the total number of fields in the datasheet.

Question 8

An Access database is limited to a size of 1 gigabyte.

Question 9

Which is NOT a feature of Access reports?

A) Headers
B) Footers
C) Calculations on groups of records
D) Easy-to-use data entry screen

Question 10

No two records can have the same value in the primary key field.

Question 11

Once you have created and named a field, you cannot resize the width of the field in a datasheet.

Question 12

Microsoft Access can best be described as ____ software.

A) Spreadsheet
B) Presentation
C) Database
D) Systems

Question 13

The [F2] key switches between Edit and Navigation modes.

Question 14

Field names appear in the top row of a datasheet.

Question 15

Values in an AutoNumber field are automatically created by Access.

Question 16

This Access object provides an easy-to-use data entry screen.

A) Macro
B) Form
C) Table
D) Module

Question 17

Field properties change depending on the data type of the field.

Question 18

Which of the following is NOT a way to open Access?

A) From the Start menu
B) From Internet Explorer
C) From a pinned program on the taskbar
D) From a shortcut on the desktop

Question 19

Which is NOT true about Access?

A) It can be used to arrange data in a variety of ways.
B) It relates lists of information in a relational database.
C) Reporting is limited to 20 saved reports.
D) Multiple users can simultaneously enter and update data within Access.

Question 20

"Focus" refers to which data you would edit if you started typing.

Question 21

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

A) Object
B) Record
C) Field
D) Table

Question 22

Which data type stores only one of two values?

A) Attachment
B) Hyperlink
C) Yes/No
D) Null

Question 23

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

A) Record
B) Table
C) Database
D) Object

Question 24

Which shortcut key moves focus to the first field of the current record?

A) [Home]
B) [End]
C) [F4]
D) [F5]

Question 25

Press this keystroke combination to move focus to the last field of the last record.

A) [Alt][Ctrl][Up Arrow]
B) [Ctrl][Up Arrow]
C) [Ctrl][End]
D) [Ctrl][Page Up]

Question 26

Which two properties are required for every field?

A) Field Name and Data Type
B) Field Name and Field Size
C) Data Type and Format
D) Field Size and Format

Question 27

The term ____ database comes from the fact that two or more tables are linked by a common field.

A) Hierarchical
B) Network
C) Schematic
D) Relational

Question 28

Which of the following is not a data type?

A) Number
B) Formula
C) Date/Time
D) Text

Question 29

While editing a record, pressing [Esc] a second time ____.

A) Deletes the current field
B) Deletes the current datasheet
C) Removes all data from the current record
D) Removes all changes made to the record you are currently editing

Question 30

Which data type stores Web addresses?

A) Lookup Wizard
B) Hyperlink
C) www address
D) HTML

Question 31

A collection of records for a single subject, such as all of the customer records, is called a(n) ____.

A) Table
B) Control
C) Element
D) Object

Question 32

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

A) Edit mode
B) Navigation mode
C) Update mode
D) Form mode

Question 33

Which data type is used to sequentially order each record added to a table?

A) Hyperlink
B) Web
C) Lookup Wizard
D) AutoNumber

Question 34

This Access object contains all of the raw data within the database.

A) Query
B) Form
C) Table
D) Module

Question 35

Which shortcut key moves focus to the previous field of the current record?

A) [Home]
B) [Shift][Tab]
C) [Up Arrow]
D) [F5]

Question 36

A(n) ____ is a collection of tables associated with a general topic such as sales of products to customers.

A) Relational database
B) Field
C) Record
D) Object

Question 37

Which data type links files created in other programs such as pictures, sound clips, or documents?

A) Lookup
B) Attachment
C) Yes/No
D) Link Wizard

Question 38

Tables, queries, and forms are examples of Access ____.

A) Entities
B) Objects
C) Values
D) Controls

Question 39

In Navigation mode, press [Tab] or this keystroke to move to the next field within the same record.

A) [End]
B) [Page Down]
C) [Down Arrow]
D) [Enter]

Question 40

Which of the following keys will help you delete unwanted data in Edit mode?

A) [Insert]
B) [Home]
C) [Ctrl]
D) [Backspace]

Question 41

In Access, data entry screens are called forms .

Question 42

A(n) ____________________  is a fundamental building block of a relational database because this object stores all of the data.

Question 43

A(n) ____________________ object provides an easy-to-use data entry screen.

Question 44

You can use the Calendar Box to enter dates in a Date/Time field.

Question 45

A(n) ____________________ key field contains unique data for each record.

Question 46

When creating a database using an Access template, you must remember that the database cannot be altered later.

Question 47

Relational ____________________ software is used to manage data that can be organized into lists of related information such as customers, products, vendors, employees, projects, or sales.

Question 48

____________________ View is a spreadsheet-like grid that displays a table's fields and records.

Question 49

A(n) ____________________ field automatically assigns a new number each time you add a record.

Question 50

The navigation buttons are found at the top of the datasheet.

Question 51

Which editing keystroke deletes one character to the right of the insertion point?

A) [Backspace]
B) [Delete]
C) [F2]
D) [F7]

Question 52

A foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Question 53

The Database window displays the Tables, Queries, Forms, and Reports. Describe what these four objects represent.

Question 55

What are the advantages of database software such as Access over spreadsheet software such as Excel?

Question 56

A(n) ____________________ object allows a user to select a subset of fields or records from one or more tables.

Question 57

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

Question 58

____________________ View is a view in which you create and manipulate the structure of an object.

Question 59

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode.

Question 60

The ____________________ refers to which data you would edit if you started typing.

Question 62

Deleting a field from a query also deletes it from the underlying table.

Question 68

Discuss the guidelines that you should use for planning a chart.

Question 69

Filters are used to select a subset of records in a datasheet.

Question 70

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

Question 71

Describe some of the changes that you can make to a chart using the Chart Tools Design tab.

Question 72

The question mark (?) is the wildcard character which stands for any single character in criteria.

Question 73

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

Question 74

To add, delete, or change fields in a query, you use Query Design View.

Question 75

Describe four commonly used Excel chart types.

Question 76

A query is commonly used as the source of data for a form or report.

Question 77

____ lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid.

A) SmartArt
B) WordArt
C) ClipArt
D) 3-DArt

Question 78

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.

A) inner
B) embedded
C) sub
D) interactive

Question 79

You can add a text box using the Chart Tools ____ tab.

A) Design
B) Layout
C) Format
D) Text

Question 80

To filter for comparative data and to specify more complex criteria, use the Filter By Selection feature.