Deck 2: Introduction to Access

Question 1

Which of the following produces a subset of your data?

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

Answer 1

D

Question 2

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

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

Answer 2

C

Question 3

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 3

B

Question 4

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 5

What database object organizes your data by rows and columns?

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

Question 6

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

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

Question 7

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

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

Question 8

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 9

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

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

Question 10

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 11

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 12

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 13

Access is a ________ product.

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

Question 14

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 15

In datasheet view,what do the rows indicate?

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

Question 16

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 17

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

Question 18

A module uses what programming language?

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

Question 19

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 20

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 21

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

Question 22

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 23

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

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

Question 24

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 25

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 26

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

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

Question 27

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 28

Microsoft SSL Server is an example of an advanced DBMS.

Question 29

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 30

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 31

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 32

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

Question 33

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 34

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 35

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 36

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

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

Question 37

You always know when you are using a database.

Question 38

Which of the following is not a valid comparison operator?

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

Question 39

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

Question 40

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 41

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

Question 42

You can only sort records by one field.

Question 43

Filters do not delete data or records.

Question 44

Reports can draw data from tables or queries.

Question 45

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

Question 46

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

Question 47

Only the most complex databases have more than one table.

Question 48

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

Question 49

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

Question 50

DBMS stands for ________.

Question 51

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

Question 52

Be careful before you delete a record from a table.

Question 53

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

Question 54

Databases only work with data,not information.

Question 55

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

Question 56

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

Question 57

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

Question 58

A primary key can be a combination of several fields.

Question 59

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

Question 60

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 61

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

Question 62

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

Question 63

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

Question 64

The ________ command helps you locate specific records.

Question 65

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

Question 66

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

Question 67

Access is a ________ Management System.

Question 68

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

Question 69

A ________ is a stored series of steps or commands.

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

In Datasheet view,________ represent columns.

Question 75

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

Question 76

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

Question 77

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

Question 78

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