Deck 1: Getting Started With Access 2.0

Question 1

In the figure above, use item number 1 to:

A) Create a database from a template
B) Open an existing database
C) Search Microsoft online templates
D) Exit Access

Answer 1

B

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

Values in an AutoNumber field are automatically created by Access.

Question 7

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

Question 8

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

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

Question 9

Field names appear in the top row of a datasheet.

Question 10

Tables contain all of the data in the database.

Question 11

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

Question 12

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

Question 13

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

Question 14

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 15

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

Question 16

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

Question 17

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 18

A primary key field uniquely identifies each record.

Question 19

Microsoft Access can best be described as ____ software.

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

Question 20

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

Question 21

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

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

Question 22

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 23

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 24

Which data type stores Web addresses?

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

Question 25

Item 5 in the figure above is:

A) The date/time
B) A record
C) A field name
D) The focus

Question 26

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 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

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 29

Which data type stores only one of two values?

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

Question 30

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 31

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

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

Question 32

Item 7 in the figure above is the:

A) Record selector box
B) Customers table tab
C) Navigation pane
D) Focus

Question 33

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 34

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 35

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

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

Question 36

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 37

In the figure above, use item number 2 to:

A) Create a database from scratch
B) Open an existing database
C) Search Microsoft online templates
D) Exit Access

Question 38

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 39

Which of the following is not a data type?

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

Question 40

Item 8 in the figure above is:

A) Where a new record would be entered
B) Where a new field would be entered
C) A field name
D) The navigation pane

Question 41

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

Question 42

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

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

Question 43

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

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

Question 44

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 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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 53

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

Question 54

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

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

Question 55

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

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

Question 56

In Access, data entry screens are called forms .

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 spreadsheet-like grid that displays a table's fields and records.

Question 59

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

Question 60

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 61

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

Question 63

Lauren wants to create an Access database of the musical instruments she owns.She has written a paragraph describing the use for each inventory item.Which data type should she use to define the field that will store this information?

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

Question 64

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

Question 65

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

Question 66

Lauren wants to create an Access database of the musical instruments she owns.A Purchase Price field should be which data type?

A)Text
B)Number
C)Monetary
D)Currency

Question 67

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

Question 68

Hannah wants to create a record keeping system to track the inventory needed to efficiently run her lawn and landscape business, such as spare parts, gas cans, string trimmers, etc.Her crew manager will also be using the system.Hannah is considering whether to use Excel or Access.Which one of the following is NOT a benefit of using Access?

A)More data storage
B)Multiuser capability
C)It's easier to set up a relational database than a spreadsheet
D)More reporting features