Deck 1: Microsoft Access Basics

Question 1

Access opens in ____ view.

A) Design
B) Datasheet
C) Layout
D) Backstage

Answer 1

D

Question 2

A database management system does not need to be computerized.

Answer 2

True

Question 3

A computerized DBMS is ____ than using file folders.

A) more flexible
B) more accurate
C) much faster
D) all of the above

Answer 3

D

Question 4

To freeze columns, select the field selectors for the columns that you want to freeze, click the More button in the Layout group on the File tab, and then click Freeze Fields.

Question 5

When you open a database, Access assumes that the database might contain something that could damage your computer.

Question 6

When you want to display more of the open object, you can close the Navigation Pane by clicking the Shutter Bar Open/Close Button at the top of the Navigation Pane.

Question 7

A record is an incomplete set of data.

Question 8

After opening a database, the Navigation Pane opens on the left side of the screen.

Question 9

A database is a collection of ____.

A) data
B) fields
C) numbers
D) objects

Question 10

Access combines compacting and repairing into one step.

Question 11

Backing up a database rearranges how the database is stored on the disk and optimizes the performance of the database.

Question 12

____ is a program known as a database management system (DBMS).

A) Excel
B) PowerPoint
C) Word
D) Access

Question 13

To make editing records easier, Access includes navigation buttons on the Ribbon at the bottom of the datasheet.

Question 14

Best of class automatically resizes the column to the best width for the data contained in the column.

Question 15

The database object called query stores all the data in the database in a format called a datasheet.

Question 16

To start Access, click the Start button on the taskbar, click ____, click Microsoft Office, and then click Microsoft Access 2010.

A) All Programs
B) Microsoft Programs
C) Open Database
D) Navigation Pane

Question 17

After you delete a record, you can use the Undo command to restore it.

Question 18

Access is a DBBS program.

Question 19

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

Question 20

The database object called Macro displays data from one or more tables or queries in a format that might be similar in appearance to a paper form.

Question 21

You can print a datasheet by clicking the File tab, clicking Print in the navigation bar, and then clicking ____ to print the datasheet using the default printer and the default print.

A) Quick Access
B) Print Now
C) Office Button
D) Quick Print

Question 22

When you change the row height of a datasheet, the change ____.

A) affects the single row currently selected
B) affects all rows visible on the screen
C) affects all the rows in a datasheet
D) affects all the columns in the datasheet

Question 23

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. The Sales Manager has asked Jonathan to consolidate data from several tables into a format similar to a paper form. In this case, Jonathan would use the ____ object.

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

Question 24

When you enter an improper field value, a(n) ____ message appears and tells you what to do to correct your mistake.

A) ScreenTip
B) Quick Access
C) error
D) security

Question 25

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. Jonathan has information in Excel worksheets that he wants to add to the database. Worksheets are similar to datasheets, so he chooses to transfer this information into ____ objects.

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

Question 26

By default, the rows in a datasheet are displayed with ____.

A) pastel colors
B) rainbow colors
C) alternating light and dark background colors
D) a white background

Question 27

You can close Access by clicking the Close button on the ____.

A) status bar
B) toolbar
C) scroll bar
D) title bar

Question 28

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Chloe needs to move the second column so it becomes the first column. To do this efficiently, Chloe will ____.

A) click the row selector and drag the row to a new location
B) click the field selector and drag the column to a new location
C) copy and append the column into its new location
D) freeze the columns and then transfer the data manually

Question 29

When resizing a column, selecting ____ automatically resizes the column to the best width for the data contained in the column.

A) best fit
B) best column
C) best data
D) best selector

Question 30

If you make changes to the layout of a datasheet and try to close the table, Access will ____.

A) prompt you to save your changes
B) automatically save your changes
C) give you an error message
D) close the table

Question 31

If you copy an entire record and want to paste it into a table as a new record, use the ____ command.

A) Paste End
B) Paste Special
C) Paste Append
D) Paste As

Question 32

The ____ object is similar to a macro, but allows more complex programming of database operations.

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

Question 33

FIGURE AC 1-1 Referring to Figure AC 1-1 above, if you sorted the database on Last Name, you would be sorting on a ____.

A) field selector
B) database selector
C) row selector
D) datasheet selector

Question 34

FIGURE AC 1-1 Referring to Figure AC 1-1 above, the word Denver is an example of a ____.

A) field
B) field value
C) field name
D) field selector

Question 35

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Once Chloe makes the changes in the layout of the datasheet, the edits are saved ____.

A) only if she saves them
B) automatically by Access
C) with a generic name
D) none of the above

Question 36

A(n) ____________________ is a collection of objects.

Question 37

When you are navigating in Datasheet view, pressing Shift+Tab ____.

A) moves to the next field in the current record
B) moves to the first field in the current record
C) moves to the previous field in the current record
D) moves to the last field in the last record

Question 38

Before printing a datasheet, you should view it in ____ so you can check the print settings.

A) Print Preview
B) Datasheet view
C) black and white
D) Zoom mode

Question 39

In Datasheet view, the table displays its data in rows and columns in a ____.

A) datasheet
B) spreadsheet
C) report
D) query program

Question 40

In ____, you can rearrange the order of the fields in a datasheet by dragging them to a new location.

A) Datasheet view
B) Column view
C) Edit view
D) Freeze view

Question 42

To insert a new field between two existing rows in a table, click the row selector for the row above where you want the new field to appear.

Question 43

After setting the properties for the fields in your table, you can use Datasheet view to enter records in the table.

Question 44

An AutoNumber field automatically adds a unique number to the primary key field for each record in the table.

Question 46

You can select all of the records in a table by clicking the ____________________, which is the box in the upper-left corner of a datasheet.

Question 47

To set a table's primary key, click the Primary Key button in the Tools group on the Home tab.

Question 49

You can only skip saving a table when you make changes to its layout.

Question 50

Each object has a different ____________________ to identify its function.

Question 51

After you have added all of the fields to your table, the last column in the table contains the Click to Add field selector in case you need to add another field later.

Question 52

You can change the colors used in the rows of the datasheet by clicking the arrow on the Alternate Row Color button in the Text Formatting group on the ____________________ tab.

Question 53

The first step in creating a database is to create the file that will store the data.

Question 54

A Text field can store up to 155 characters and is used to store data such as names and addresses.

Question 55

A(n) ____________________ is used to search for and retrieve data from tables using conditions.

Question 56

Imagine that you are a Sales Manager at a Toy Company, and give an example of a business situation where you would use each of these database objects: query, report, and macro.

Question 58

If you have a table with an ID field with the AutoNumber data type, when you enter a new record in the table, you do not need to type a value in this field.

Question 59

You need to save a new record after entering it. Access does not save new records automatically.

Question 61

When you create a table in Datasheet view, clicking the Click to Add field selector opens the list of data queries .

Question 62

After specifying the file name and the location in which to store the database, click the ____ button to create the new database and open it in Access.

A) New
B) Create
C) Table
D) Datasheet

Question 63

Using the ____ data type, open the Expression Builder dialog box, which lets you specify fields and operators to use in calculations.

A) Calculated
B) Math
C) Accounting
D) Monetary

Question 64

In a table, the first key is the field that contains a unique field value for each record in the table.

Question 65

When you use a template to create a database, the template creates the database and one or more table, query, form, and report themes that you use to enter and view data.

Question 66

If a row selector for an ID field has a(n) ____ symbol in it, it indicates that the field is the table's primary key.

A) key
B) lock
C) infinity
D) clasped hands

Question 67

When you need to change the data type for a selected field, you can do so by clicking the Data Type arrow in the ____ group on the Fields tab.

A) Data
B) Views
C) Properties
D) Formatting

Question 68

The ____ Value property enters the same field value in a field every time a new record is added to the table.

A) Default
B) Repeat
C) Redo
D) Sample

Question 69

Use the ____ property to specify how you want Access to display numbers, dates, times, and text.

A) Setup
B) Layout
C) Format
D) Edit

Question 70

You can open a table directly in Design view from the Navigation Pane. ____ the table name in the Navigation Pane, and then click Design View on the shortcut menu.

A) Right-click
B) Single-click
C) Double-click
D) Select

Question 71

When viewing a table in Design view, the field names and data types appear in the ____ in the top half of the Table window.

A) datasheet
B) chart
C) design grid
D) matrix

Question 72

When you create a blank database, Access creates the first table in the database for you and names it ____.

A) Data1
B) Table1
C) Sheet1
D) Datasheet1

Question 73

A combination of numbers and text is also called alphanumeric data.

Question 74

To create a database, start Access. On the ____ tab in Backstage view, click the template you want to use.

A) New
B) Create
C) Print
D) Help

Question 75

After you save a table, the new table name appears ____.

A) on the tab for the table
B) in the Navigation Pane
C) both a. and b.
D) neither a. nor b.

Question 76

Fields with the Memo data type accepts field values containing alphanumeric data, but can store field values containing up to ____ characters.

A) 535
B) 6,535
C) 65,535
D) 165,535

Question 77

All of these values are also good candidates to use as a table's primary key field EXCEPT ____.

A) student identification numbers
B) employee numbers
C) Social security numbers
D) birthdates

Question 78

In Design view, you can add, delete, and make changes to the way that fields store data .

Question 79

You can also use a Quick Start selection to add commonly used fields to an existing table. In the Add & Delete group on the ____ tab, click the More Fields button, scroll down to the Quick Start section, and then click a Quick Start selection to add fields to the table.

A) Tables
B) Records
C) Fields
D) Data

Question 80

When viewing a table in Design view, the bottom half of the Table window is called the Field ____ pane.

A) Queries
B) Forms
C) Properties
D) Data Type