Deck 2: Access: Introduction to Powerpoint

Question 1

How many records do most forms display?

A) 0 (Forms don't display records)
B) 1
C) 2
D) All the records at the same time

Answer 1

B

Question 2

What are the two ways you can view a table?

A) Design and Layout views
B) Design and Datasheet views
C) Datasheet and Form views
D) Datasheet and Layout views

Answer 2

B

Question 3

A customer's cell phone would be an example of a ________.

A) table
B) record
C) field
D) primary key

Answer 3

C

Question 4

What is not true about modules?

A) It is considered an advanced object.
B) It is required for intermediate users.
C) It uses the VBA programming language.
D) It provides more functionality than macros.

Question 5

When you click the Enable Content warning, the database is now ________.

A) trusted on this computer
B) trusted for this session
C) trusted for any computer
D) unlocked

Question 6

In datasheet view, what do the rows indicate?

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

Question 7

To assign a field size of 12 to a field in a table you would ________.

A) pick Short Text from the Data Type list
B) pick Long Text from the Data Type list
C) type 12 in the Description area of that field
D) enter 12 in the Field Size property of that field

Question 8

How can you toggle viewing the Navigation Pane?

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

Question 9

What is not true about field properties?

A) They define a field's characteristics.
B) They vary by field type.
C) They can allow data entry to be required for a field.
D) The categories are the same for all field types.

Question 10

What allows you to add components to an existing database, rather than creating an entire new database?

A) Objects
B) Filters
C) Application parts
D) Templates

Question 11

What database object organizes your data by rows and columns?

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

Question 12

Which of the following views would you use to view or modify a table's structure?

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

Question 13

What view normally appears when you double-click a table?

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

Question 14

What interface element shows you the various objects in your database?

A) The Database Tools menu
B) The Database Properties pane
C) The Home menu
D) The Navigation pane

Question 15

Access is a ________ product.

A) Microsoft
B) Google
C) Yahoo
D) Corel

Question 16

In Datasheet view, what does a pencil symbol to the left of a record indicate?

A) Data in that record has not been saved yet.
B) Data in that record has recently been modified and saved.
C) Data in that record has a data integrity violation and needs to be changed.
D) Data in that record is about to be deleted.

Question 17

What is not true about the Compact and Repair Database utility?

A) It can help when the data becomes corrupt.
B) It can be set up to run automatically when a database is closed.
C) It is used when the database gets too many records in it.
D) It can reduce the size of a database.

Question 18

Most users enter information into a database through the use of a ________.

A) form
B) table in datasheet view
C) query
D) macro

Question 19

Which of the following produces a subset of your data?

A) Macro
B) Field
C) Table
D) Query

Question 20

A module uses what programming language?

A) SQL
B) VBA
C) VBL
D) HTML

Question 21

How would you sort records in a field so that the oldest birthday is listed first?

A) Sort by form
B) Selection sort
C) Sort descending
D) Sort ascending

Question 22

To create a database from a template you would use which view?

A) Design
B) Layout
C) Create database
D) Backstage

Question 23

What type of filter displays records based on a criterion you choose?

A) Selection filter
B) Filter by Report
C) Exact Match filter
D) Toggle filter

Question 24

Every time you open a database you will receive a security warning.

Question 25

Microsoft SSL Server is an example of an advanced DBMS.

Question 26

Which method of creating a database demands the least amount of expertise in Access?

A) Creating a blank desktop database
B) Creating a custom web app
C) Importing an Excel spreadsheet
D) Using a template

Question 27

What is not true about database relationships?

A) They are connections between two tables.
B) They join tables on a common field.
C) They allow for efficient database design.
D) They tend to increase the overall file size of a database.

Question 28

Searching a website to help you find just the right product involves database technology.

Question 29

Which of the following is not a valid criteria in a filter?

A) ="Fred"
B) =>14
C) <>125
D) Is Null

Question 30

Which of the following is not one of the three methods for creating a database?

A) Create a blank desktop database
B) Create a blank cloud database
C) Create a custom web app
D) Create a database from a template

Question 31

When you close a table after using a selection filter and then reopen it, what happens to the filter?

A) The filter is still operating.
B) The filter is not saved.
C) The filter is removed, but Toggle Filter will bring it back.
D) The filter is removed permanently.

Question 32

Which of the following is not a valid comparison operator?

A) <>
B) =
C) =>
D) <=

Question 33

What is not true about records?

A) They are displayed as rows in datasheet view.
B) They represent categories of information that is stored in a database.
C) They are a complete set of fields for a person, place, etc.
D) They are stored in tables.

Question 34

You always know when you are using a database.

Question 35

Which of the following operators will give you the fewest number of hits?

A) AND
B) OR
C) NOT
D) NOR

Question 36

When you type Smith in a person's last name field you are entering information.

Question 37

What database object is an electronic version of the paperwork you fill out at the doctor's office?

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

Question 38

When you split a database, what object type is put in the back end?

A) Tables
B) Forms
C) Reports
D) Macros and Modules

Question 39

One of the reasons someone may choose to start a database with a template is to save time by not having to ________.

A) enter so much data
B) know anything about Access
C) create as many objects
D) create the table relationships

Question 40

If you sorted a table which had 53 records by two fields, one ascending and the other descending, how many records would display?

A) It depends on how many of the fields are blank.
B) 53
C) 106
D) It depends on how many of the fields contain exactly the same information.

Question 41

You can only sort records by one field.

Question 42

Your birthday would be a good candidate for a primary key.

Question 43

A primary key can be a combination of several fields.

Question 44

A good practice is to make backups of your databases on different storage devices.

Question 45

Using the Back Up Database utility only saves the structure of the database, not the content.

Question 46

Using a template to create a database is not an effective use of time because of all the modifications you need to make so the database will fit your needs.

Question 47

A(n) ________ allows you to poll the data in your database.

Question 48

Be careful before you delete a record from a table.

Question 49

As long as your data is accurate there is no real need to print preview your reports.

Question 50

When first designing a database, it is not important what data type you assign each field because you can easily change it later.

Question 51

Reports can draw data from tables or queries.

Question 52

Databases only work with data, not information.

Question 53

Only the most complex databases have more than one table.

Question 54

Naming a table carefully is very important because it is the only way to describe what data that table contains.

Question 55

Creating a database from a template can help you get started more quickly.

Question 56

Using the Compact and Repair Database utility on a regular basis is good practice.

Question 57

If you see plus signs (+) next to records in Datasheet view, then you know that two or more tables are related.

Question 58

Using Filter by Form enables you to filter on multiple criteria.

Question 59

DBMS stands for ________.

Question 60

Filters do not delete data or records.

Question 61

A(n) ________ enables you to add a set of common Access components to an existing
database.

Question 62

By default, Access uses a(n) ________ Documents interface.

Question 63

The ________ command helps you locate specific records.

Question 64

Using Filter by Form allows you to filter on ________ criteria.

Question 65

Match the following terms with their description:
I. Compact and Repair Database
II. Database
III. Datasheet view
IV. Design view
V. Module
A. A view which displays an object's structure
B. An advanced object within VBA
C. A utility that makes a database smaller and fixes errors
D. A way of displaying data in a row / column grid
E. A collection of data organized as useful information

Question 66

The ________ icon indicates that a field is the primary key.

Question 67

When you double-click a query, the interface looks like a(n) ________.

Question 68

A ________ allows you to select only the records you want.

Question 69

Tables, queries, forms, and reports are all considered to be ________.

Question 70

The ________ data type is generated by Access whenever a new record is created.

Question 71

When you enter a field into a database, you are entering ________.

Question 72

You cannot change ________ in a report; reports only display it.

Question 73

Match the following terms with their description:
I. Form
II. Report
III. Macro
IV. Sort
V. Filter
A. A way of displaying data in which the data cannot be changed
B. Changes the order of how records are displayed
C. Using this is the one way of entering data
D. Limits the amount of data displayed
E. A stored set of commands

Question 74

When you format a date to display a certain way, you have changed the field's ________.

Question 75

In Datasheet view, ________ represent columns.

Question 76

The ________ filter operator will give you the smallest number hits.

Question 77

A ________ is a stored series of steps or commands.

Question 78

If you find yourself performing the same exact actions over and over, you might consider creating a (n) ________.

Question 79

You can create a(n) ________ from your own database so that you can reuse its structure whenever you need.

Question 80

Access is a ________ Management System.