Deck 1: Access: Introduction to Access

Question 1

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

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

Answer 1

A

Question 2

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

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

Answer 2

C

Question 3

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.

Answer 3

C

Question 4

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

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

Question 5

The ACCDE format allows users to ________.

A)view data, but make no changes to the structure or to enter data
B)do anything to the structure and data because it is just a format for compressing data
C)enter data, but not add, modify, or delete objects
D)run the Access database without Access installed

Question 6

How would you sort or filter records in a field that begins with both numbers and letters so that the records which begin with numbers appear before the records that begin with letters?

A)Filter by form
B)Selection filter
C)Sort descending
D)Sort ascending

Question 7

If you want fewer records to display, you should use which operator in your filter?

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

Question 8

You only need to save an object when ________.

A)you make changes to its data
B)you make changes to its structure
C)you add or delete fields
D)you want to rename the object

Question 9

What produces a subset of your data?

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

Question 10

To assign a field size of 12 to a field 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 11

When does Access save a record?

A)When you press the Save icon
B)When you move to a different field
C)When you move to a different record
D)When you close the form or table

Question 12

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

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

Question 13

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 14

Backstage view gives you access to which command?

A)Relationships
B)Clipboard
C)Save As
D)Form Design

Question 15

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 16

What database object organizes your data by rows and columns?

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

Question 17

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 18

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

Question 19

A module uses what programming language?

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

Question 20

What does opening a database in exclusive mode assure?

A)That a password has been set previously
B)That no changes can be made to the structure of the database
C)There is no such thing as exclusive mode.
D)That you are the only person with that database open

Question 21

One reason to begin with a template is that you do not have to ________.

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

Question 22

To move a field you ________.

A)left-click the column heading, then drag the field to where you want it
B)right-click the column heading, then drag the field to where you want it
C)right-click the column heading and select Move Column
D)do nothing. You can't move a field

Question 23

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 24

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

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

Question 25

To view or modify a table's structure you would go to what view?

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

Question 26

Which of the following is not a property of a number data type?

A)Allow zero length
B)Caption
C)Validation
D)Required

Question 27

What is the most important thing you need if you are going to create a Web app?

A)Access Professional
B)A host server
C)The latest version of your favorite Web browser
D)The latest version of Internet Explorer or Microsoft Edge

Question 28

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 29

Only the ________ versions of Microsoft Office include Access.

Question 30

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 31

DBMS stands for ________.

Question 32

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 33

What two tabs are unique to Access?

A)External Data and Mailings
B)Mailings and Database Tools
C)Developer and Data
D)External Data and Database Tools

Question 34

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 35

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

Question 36

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 37

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

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

Question 38

Which of the following is not a valid comparison operator?

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

Question 39

In datasheet view, what do the rows indicate?

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

Question 40

What is SharePoint?

A)A host server
B)An Access alternative
C)A PowerPoint alternative
D)An application that lets others in your office share your computer's database

Question 41

A web app is a ________-based database.

Question 42

The ________ command helps you locate specific records.

Question 43

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

Question 44

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

Question 45

Reports cannot change ________, they only display it.

Question 46

An ________ enables you to add a set of common Access components to an existing
database.

Question 47

ACCDE is an acronym for ________.

Question 48

The AND operator includes records only if ________ the criteria are met.

Question 49

If you want fewer records in your filter you should use the ________ operator.

Question 50

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

Question 51

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

Question 52

In Datasheet view, ________ represent fields.

Question 53

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

Question 54

Pressing the ________ key when you are in the last field in the last record will enter a new record.

Question 55

The ________ comparison operator indicates "not equal."

Question 56

Before you can password protect a database you must open it in ________ mode.

Question 57

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

Question 58

A ________ is a stored series of steps or commands.

Question 59

Unlike other Office applications, Access works mostly from ________.

Question 60

Normally Access uses a(n)________ Documents interface.

Question 61

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

Question 62

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

Question 63

A primary key can be a combination of several fields.

Question 64

You always know when you are using a database.

Question 65

Only the most complex databases have more than one table.

Question 66

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

Question 67

Be careful before you delete a record from a table.

Question 68

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

Question 69

You can only sort records by one field.

Question 70

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

Question 71

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

Question 72

Filters do not delete data or records.

Question 73

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

Question 74

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

Question 75

Reports can draw data from tables or queries.

Question 76

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

Question 77

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

Question 78

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

Question 79

Microsoft SSL Server is an example of an advanced DBMS.

Question 80

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