Midterm Microsoft Access 2016 Flashcards


Set Details Share
created 4 years ago by Ash4249
3,410 views
updated 4 years ago by Ash4249
show moreless
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
Show:

1

To view or modify every part of a table's structure you would go to what view?
Datasheet
Layout
Design
Form

Design

2

What two tabs are unique to Access?
Mailings and Database Tools
Developer and Data
External Data and Database Tools
External Data and Mailings

External Data and Database Tools

3

Which of the following is not one of the three methods for creating a database?
Create a blank cloud database
Create a blank desktop database
Create a database from a template
Create a custom web app

Create a blank cloud database

4

Backstage view gives you access to which command?
Relationships
Form Design
Clipboard
Save As

Save As

5

What is SharePoint?
An Access alternative
A host server
An application that lets others in your office share your computer's database
A PowerPoint alternative

A host server

6

When does Access save a record?
When you press the Save icon
When you move to a different field
When you close the form or table
When you move to a different record

When you move to a different record

7

What two tabs are unique to Access?
Mailings and Database Tools
Developer and Data
External Data and Database Tools
External Data and Mailings

External Data and Database Tools

8

A customer's cell phone would be an example of a ________.
primary key
field
table
record

field

9

What are the two ways you can view a table?
Design and Datasheet views
Datasheet and Form views
Design and Layout views
Datasheet and Layout views

Design and Datasheet views

10

When you click the Enable Content warning, the database is now ________.
trusted for any computer
trusted on this computer
trusted for this session
unlocked

trusted on this computer

11

Which method of creating a database demands the least amount of expertise in Access?
Importing unstructured content from an Excel spreadsheet
Creating a custom web app
Using a template
Creating a blank desktop database

Using a template

12

Most users enter information into a database through the use of a ________.
query
form
macro
table in datasheet view

form

13

Which of the following is not a valid comparison operator?
=
<=
<>
=>

=>

14

When you close a table after using a selection filter and then reopen it, what happens to the filter?
The filter is not saved.
The filter is removed, but Toggle Filter will bring it back.
The filter is still operating.
The filter is removed permanently.

The filter is removed, but Toggle Filter will bring it back.

15

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

AND

16

What produces a subset of your data?
Field
Table
Macro
Query

Query

17

In order to program a custom application module, you have the option to build with code using which programming language? (This is not to be confused with the language used for coding queries)
VBA (Visual Basic for Applications)
VBL (Visual Basic Language)
SQL (Structured Query language)
HTML (HyperText Markup Language)

VBA (Visual Basic for Applications)

18

If you sorted a table which had 53 records by two fields, one ascending and the other descending, how many records would display?
53
It depends on how many of the fields contain exactly the same information.
It depends on how many of the fields are blank.
106

53

19

Which of the following is not a valid criteria in a filter?
<>125
="Fred"
Is Null
=>14

=>14

20

In datasheet view, what do the rows indicate?
Fields
Records
Information
Tables

Records

21

What is the most important thing you need if you are going to create a Web app?
A host server
Access Professional
The latest version of your favorite Web browser
The latest version of Internet Explorer or Microsoft Edge

A host server

22

The ACCDE format allows users to ________.
view data, but make no changes to the structure or to enter data
run the Access database without Access installed
enter data, but not add, modify, or delete objects
do anything to the structure and data because it is just a format for compressing data

enter data, but not add, modify, or delete objects

23

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?
Sort descending
Selection filter
Sort ascending
Filter by form

Sort ascending

24

In Datasheet view, what does a pencil symbol to the left of a record indicate?
Data in that record has a data integrity violation and needs to be changed.
Data in that record is about to be deleted.
A record has recently been modified and saved.
Data in that record has not been saved yet.

Data in that record has not been saved yet.

25

What interface element shows you the various objects in your database?
The Home menu
The Navigation pane
The Database Tools menu
The Database Properties pane

The Navigation pane

26

Which of the following is not one of the three methods for creating a database?
Create a blank cloud database
Create a blank desktop database
Create a database from a template
Create a custom web app

Create a blank cloud database

27

What database object organizes your data by rows and columns?
Macro
Report
Table
Form

Table

28

Which of the following is not a property of a number data type?
Validation
Required
Caption
Allow zero length

Allow zero length

29

What does opening a database in exclusive mode assure?
That you are the only person with that database open
There is no such thing as exclusive mode
That a password has been set previously
That no changes can be made to the structure of the database

That you are the only person with that database open

30

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

left-click the column heading, then drag the field to where you want it

31

How many records do most forms display?
0 (Forms don't display records)
1
2
All the records at the same time

1

32

You only need to save an object when ________.
you want to avoid renaming the object
you make changes to its structure
you add or delete fields
you make changes to its data

you make changes to its structure

33

What type of filter displays records based on a criterion you choose?
Selection filter
Toggle filter
Exact Match filter
Filter by Report

Selection filter

34

To create a database from a template you would use which view?
Backstage
Create database
Design
Layout

Backstage

35

To assign a field size of 12 to a field you would ________.
type 12 in the Description area of that field
enter 12 in the Field Size property of that field
pick Short Text from the Data Type list
pick Long Text from the Data Type list

enter 12 in the Field Size property of that field

36

When you split a database (separating the stored data into what's called the 'backend', from the user interface in the 'frontend'), what object type is put in the back end?
Reports
Forms
Tables
Macros and Modules

Tables

37

The ACCDE format allows users to ________.
view data, but make no changes to the structure or to enter data
run the Access database without Access installed
enter data, but not add, modify, or delete objects
do anything to the structure and data because it is just a format for compressing data

enter data, but not add, modify, or delete objects

38

What can you not import from one Access database into another Access database?
Sheets
Reports
Tables
Forms

Sheets

39

Which field property helps a user know why an entry error was generated?
Expression
Validation Text
Error Code
Validation Rule

Validation Text

40

What is not one of the six guidelines for creating fields?
Determine the primary keys
Think of what needs you might have in the future
Link the tables on related fields
Store data in as large of number of parts as possible

Store data in as large of number of parts as possible

41

When does the validation rule check the entered data?
When the table of form is closed
As soon as it is typed into the field
When the table or form is saved
When the user exits the field

When the user exits the field

42

Enforcing referential integrity assures that ________.
you cannot enter a value in the foreign key if there is no corresponding value in the primary key
you cannot enter invalid or incorrect information
you cannot leave that field empty
you cannot enter the same value in the foreign key of the same table

you cannot enter a value in the foreign key if there is no corresponding value in the primary key

43

How many characters can be stored in a field with a Long Text data type?
1,000
Unlimited
12,256
64,000

64,000

44

What field property would you use to automatically enter "PA" in a state field?
Caption
Format
Default Value
Start Value

Default Value

45

What field property would you use to ensure all PhoneNumber values are stored with consistent appearance?
Format
Input Mask
Default Value
Caption

Input Mask

46

If you wanted to add January 16, 1957 as text criteria, how would you enter it?

*remember that a date criteria makes use of # as the surrounding character(bookends) for the criteria value, while plain text gets surrounded with (using bookends of) quotation marks

"January 16, 1957"
=January 16, 1957
#January 16, 1957#
January 16, 1957

"January 16, 1957"

47

What is not true about field names?
They can be up to 64 characters in length.
They can begin with a space.
They should describe the data they will store.
They can contain numbers.

They can begin with a space.

48

When you run a query, it displays in what view?
Print Preview
Layout
Datasheet
Design

Datasheet

49

When you purchase from a store several times this would be an example of what kind of table relationship?
Many-to-many (many items purchased - many times)
One-to-one (one customer - one store)
One-to-many (one customer - many purchases)
Many-to-one (many purchases - one customer)

One-to-many (one customer - many purchases)

50

What field property would allow the user to enter "" into a field with a Short Text data type?
Allow Zero Length
Allow Null Length
Indexed
Required

Allow Zero Length

51

When you import data, where can you not store it?
New form
Linked table
Existing table
New table

New form

52

Which of the following is not a way to create a multitable query?
Modifying an existing query
Just adding tables in the Relationship window
Creating a query from scratch
Using the Query Wizard

Just adding tables in the Relationship window

53

If you add a table with 10 records to a query and add an unrelated table with 4 records to the same query, since this performs a positive match for each of the 10 records multiplied by the number of records in the unrelated table, how many records will display when you run the query?
4
10
40
0 (since the tables are not related)

40

54

The query wizard is best used to create what kind of query?
Simple queries
Zero table queries
Advanced queries
Multifaced queries

Simple queries

55

What is the suggested data type for a street address?
Short Text
OLE Object
Long Text
Number

Short Text

56

Which option would this wildcard, "H[!oe]" not display?
His
Humming
House
Hat

House

57

What is not critical when you are first designing a database?
What tables you will need
What the field names will be
What fields you will need
What type of data will be stored in each field

What the field names will be

58

What is not true about the hyperlink data type?
It can store the path to a file
It can store the URL for a web page
It can store the path to a folder
It lists the hyperlink, but you must press the Ctrl key while you click the hyperlink for it to work

It lists the hyperlink, but you must press the Ctrl key while you click the hyperlink for it to work

59

What view offers the most flexibility in setting the properties of a field?
SQL view
Design View
Datasheet view
Page Layout view

Design View

60

How many characters can be stored in a field with a Short Text data type?
1256
100
500
255

255

61

What field property increases the speed at which searches can be performed?
Result Type
Indexed
Required
Allow Zero Length

Indexed

62

If you wanted the user to pick from a particular list generated by looking into your existing data, what would you pick from the data type drop down list for that field?
Short Text
Long Text
Lookup Wizard
List

Lookup Wizard

63

Which logical operator would return the fewest records?
NOR
AND
NOT
OR

AND

64

Which of the following comparison operators is not valid?
<>
<
=>
>=

=>

65

Which of the following would make a consistently reliable primary key?
Number data type
Customer number
AutoNumber data type
Birthday

AutoNumber data type

66

"lastName" is an example of ________.

camelCase (camel case)
a naming convention that is not recommended because of possible compatibility issues
a typing error
PascalCase (pascal case)

camelCase (camel case)

67

What field property forces data to follow certain rules of data entry?
Format
Validation Text (the error message)
Required
Validation Rule (the logical test)

Validation Rule (the logical test)

68

The first step to resizing a column in datasheet view is to move the pointer until it looks like a ________.
four-headed arrow and then click
thick black line and then click
two-headed arrow and then click
thick green line and then click

two-headed arrow and then click

69

Checking the Cascade Delete Related Records checkbox assures that ________.
you cannot delete a primary key record if it has related records
you cannot delete related records if they have more than one foreign key records
all records will be deleted in related tables if you delete the primary key in the primary table
all primary keys will be deleted if you delete related records

all records will be deleted in related tables if you delete the primary key in the primary table

70

What field property makes up for the limitation of the field naming rules or common practices?
Caption
Validation Rule
Input Mask
Format

Caption

71

What table property always necessitates an entry?

(hint: different than allowing zero length)

AutoNumber
Date/Time
Number
Requirements

AutoNumber

72

To limit the number of records displayed when a query is run you add ________.
less fields
sorting
criteria
less tables

criteria

73

Which wildcard character matches a single character in the same position as the wildcard?
[]
?
*
[!]

?

74

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?
Order of operations
Naming convention for cell ranges
The various printing options available in Excel
How to do date calculations

Order of operations

75

What error will you get if there is something wrong with the formula in a calculated field?
#NAME!
non-valid expression
Invalid syntax
#FORMULA!

Invalid syntax

76

What punctuation do you use to separate the arguments in a function?
.
,
:
;

,

77

According to the order of operations, what is not calculated after exponentiation?
Division
Multiplication
Parenthesis
Addition

Parenthesis

78

Which element will you never find in a calculated field?
Function
Macro
Constant
Arithmetic operator

Macro

79

When you want to add a condition to a Totals query, which option do you select from the Totals row list?
Condition
Group
Where
When

Where

80

What type of query will allow you to see statistics by category?
Update query
Delete query
Totals query
Statisticized query

Totals query

81

What result would be generated by the formula =10*2-3*2?
-2
14
34
-20

14

82

For a 15-year loan paid monthly, which of the following would not be correct for the num_periods argument in the Pmt function?
180
15
12*15
15*12

15

83

Where does the Total row of an aggregate function display its results?
First row in Datasheet view
Only row in Datasheet view
Last row in Datasheet view
It does not display in Datasheet view.

Last row in Datasheet view

84

As what does Access refer to aggregate functions?
Totals
Sums
Whole Column functions
Complex functions

Totals

85

When you run a query, what is the default view?
Design
Datasheet
Form
Layout

Datasheet

86

Which of these is an advantage of using the Expression Builder(rather than zoom, or the criteria field for entry of query criteria)?
It will guarantee that you do not mis-type field names.
Queries built this way run faster
Zoom limits the statements to simple comparison
There is no advantage to using Builder, zoom is superior in every way

It will guarantee that you do not mis-type field names.

87

Which of the following is not an argument used in the Pmt function?
Type
Future_value
Total_due
Rate

Total_due

88

What are predefined computations that perform complex calculations?
Formulated
predefined Functions
Expression fusion
Arguments

predefined Functions

89

Which of the following is not an arithmetic operator? (hint: another type of operator is a comparison operator)
+
-
>
*

>

90

What symbol does Access use to express exponentiation?
^
()
<>
*

^

91

What symbols does Access use to indicate a field name?
[]
""
{}
()

[]

92

What value will Access calculate from the following formula: =1+(2-3)+5/6-6^2?
-35.2
16
-.17
26.69

-35.2

93

What is not an example of a function?
=PV
=15*21
=PMT
=RATE

=15*21

94

What can help you build more complex expressions in calculated fields?
Expressive Creator
Property sheet
Expression Builder
Design view

Expression Builder

95

What button do you click to see the results of a query?
Query
View
Go
Run

Run

96

What is a type of field that displays the result of an expression rather than the data stored in a field?
AutoNumber
Lookup
Hyperlink
Calculated

Calculated

97

In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate first?
1+
(2-3)
6^2
5/6

(2-3)

98

In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate second?
6^2
(2-3)
1+
5/6

6^2

99

When you are prompted to enter a value when you run a query which includes a calculated field, you probably ________.
forgot to name the new, calculated field
used the wrong arithmetic operator in your formula
typed a field name incorrectly
entered too many arguments in the formula

typed a field name incorrectly

100

What allows you to summarize data by the values of a field?
Adding a sumarian field
Adding an update field
Adding the proper calculated field
Adding grouping to a query

Adding grouping to a query

101

What is not a necessary piece of data needed for the Pmt function?
Interest rate
Amount of the loan
Amount already paid on the loan
Number of periods required to pay off the loan

Amount already paid on the loan

102

When creating a calculated field in a query, what common error will not give you a direct indication that there is a problem?
Misspelling the name of a field within the calculated field
Forgetting the order of operations
Misspelling the field name
Forgetting the colon

Forgetting the order of operations

103

What is a popular label producing company?
Okidata
Easy Labels
Avery
MakeIt Labels

Avery

104

What is not an option in the Layout Options for Grouped Data in the Report Wizard?
Multi-level
Block
Outline
Stepped

Multi-level

105

Which of the following cannot be included on a form?
Drop-down list
Subliminal report
Button
Check box

Subliminal report

106

Each of the following are compelling reasons for data entry by using a form, except one which is not true:
Less likely to edit the wrong record.
Data you enter in a form must then be transferred to the table.
Forms can created to resemble paper forms.
You can show data from more than one table at a time.

Data you enter in a form must then be transferred to the table.

107

Which of the following is not a report view?
Report view
SQL view
Design view
Layout view

SQL view

108

Which of the following is not a primary consideration when designing a report?
How many pages of results the report generates
What information will be needed in the report
The purpose of the report
Expectations of the intended user of the report

How many pages of results the report generates

109

What is the portability advantage of saving a report as a PDF file?
It compresses more tightly.
It opens more quickly for other Microsoft Office users.
It is always a smaller file size.
More people can open the file, for example users of a device, or other operating system

More people can open the file, for example users of a device, or other operating system

110

How many other forms does the More Forms list (found under the Create Tab) provide?
2
3
4
5

4

111

What is not a group on the Report Layout Tools Format tab?
Font
Number
Background
Fields

Fields

112

What can you not easily do using a form?
Move data
Delete data
Enter data
Edit data

Move data

113

What type of form control is normally used to display data?
Text box
Button
Data check
Label

Text box

114

Which of the following is not a form view?
Form view
SQL view
Design view
Layout view

SQL view

115

Pressing the Ctrl key plus what other key enables you to select all the controls on a form?
Y
A
C
X

A

116

What is not a valid reason to edit a form's layout?
Unused fields need to be deleted.
New fields need to be added.
The user's needs have changed.
Extra fields need to be added (just in case they will be needed later).

Extra fields need to be added (just in case they will be needed later).

117

What is not found on the Data Group on Print Preview tab?
Text File
Excel
Portrait
Email

Portrait

118

What is not true about a report?
It is capable of displaying only one record at a time.
It can be sorted independently of its data source.
It can be previewed before it is printed.
Its record sources include one or more tables, or a query.

It is capable of displaying only one record at a time.

119

Normally when you Print Preview a report it will generate a report with how many pages?
Only the first two pages
Only the first page
All the pages are shown in print preview
All the pages only if they will all fit on the screen at one time

All the pages are shown in print preview

120

Which form tools creates a box asking for user input?
Navigation
Modal Dialog
Datasheet
Form Wizard

Modal Dialog

121

What does PDF in Adobe's portable document format stand for?
Public Document Format
Portable Document File
Portable Document Format
Public Document File

Portable Document Format

122

Which tab is not available for modifying a report, when working in Design View?
Design
Arrange
Format
Grouped

Grouped

123

Which of the following is not true of a form?
It can contain background images.
It can ONLY display ONE record at a time.
It is the most common method of entering data.
It can be sorted independently of its data source.

It can ONLY display ONE record at a time.

124

Which of the following is not recommended as a professional way of styling a form?
Separate the primary key from the rest of the form
Right-align the labels
Use several fonts to indicate different types of data
Left-align the text boxes

Use several fonts to indicate different types of data

125

What is not a common format for a number control?
Currency
Percent
Accounted format
Comma

Accounted format

126

When running a report, which sort order takes precedence?
Underlying table
Underlying query
Report
Underlying form

Report

127

What can you not do with an Access report?
View report on screen
Print report
Save report as a Word document
Edit data

Edit data

128

When modifying a report, on which tab would you find the commands for changing what fields appear on the report?
Design
Arrange
Format
Group

Design

129

When modifying a report, on which tab would you find the commands for changing the margins of the report?
Design
Arrange
Format
Group

Arrange

130

Which view of a form is used for data entry?
Form view
SQL view
Design view
Layout view

Form view

131

What is not found on the Report Layout Tools Arrange tab?
Insert Left
Insert Existing Field
Move Up
Insert Right

Insert Existing Field

132

Which form view enables you to make changes to how the form looks at the same time that you are looking at actual data?
Layout view
Form view
Design view
SQL view

Layout view

133

Which form (which will include the existing fields from the data source) can be created with just one click?
Tabulary layout
Formed Wizard
Stacked layout
Blank Form

Stacked layout

134

What does PDF in Adobe's portable document format stand for?
Public Document Format
Portable Document File
Portable Document Format
Public Document File

Portable Document Format

135

Which form view enables you to make changes to how the form looks at the same time that you are looking at actual data?
Layout view
Form view
Design view
SQL view

Layout view

136

Which of the following is not true of a form?
It can contain background images.
It can ONLY display ONE record at a time.
It is the most common method of entering data.
It can be sorted independently of its data source.

It can ONLY display ONE record at a time.