How can we help?

You can also find more resources in our Help Center.

Study sets matching "access chapter 3"

Study sets
Classes
Users

Study sets matching "access chapter 3"

32 terms
Interactions Access Vocabulary Chapter 3
advice
avalanche
blood
boss
an opinion or recommendation offered as a guide to action, co…
a large mass of snow, ice, etc., detached from a mountain slo…
the fluid that circulates in the principal vascular system of…
a person who makes decisions, exercises authority, dominates,…
advice
an opinion or recommendation offered as a guide to action, co…
avalanche
a large mass of snow, ice, etc., detached from a mountain slo…
16 terms
Access 2013 - Chapter 3
Form
Control
Control Margin
Control Padding
An alternative view of a table or query, displaying the field…
A generic term for an object on a form or report.
The spacing on the inside of the control.
The spacing on the outside of the control.
Form
An alternative view of a table or query, displaying the field…
Control
A generic term for an object on a form or report.
24 terms
Chapter 3 Access
Aggregate function
AutoFit
Comparison operator
Expression Builder
Calculations that perform arithmetic operations such as avera…
A method to change the column width of the data to match the…
An operator used in a query to compare the value in a databas…
A tool that helps you format your calculated fields correctly…
Aggregate function
Calculations that perform arithmetic operations such as avera…
AutoFit
A method to change the column width of the data to match the…
9 terms
Access Chapter 3
How does a form simplify data entry (w…
What is the record source of a form?
What is the advantage of creating a fo…
Why is using a layout control to keep…
You are less likely to edit the wrong record by mistake... You…
A RECORD SOURCE (or data source) is the table or query that s…
The SUB-FORM displays records in the related table, generally…
Data is not editable in layout view.
How does a form simplify data entry (w…
You are less likely to edit the wrong record by mistake... You…
What is the record source of a form?
A RECORD SOURCE (or data source) is the table or query that s…
25 terms
Access Chapter 3
Layout view
Bound
Design view
Form header
The Access view in which you can make changes to a form or re…
The term used to describe objects and controls that are based…
An Access view that displays the detailed structure of a quer…
Information, such as a form's title, that displays at the top…
Layout view
The Access view in which you can make changes to a form or re…
Bound
The term used to describe objects and controls that are based…
41 terms
Access Chapter 3
Which of the following statements is t…
The PMT function is best suited to det…
The ___ function measures the amount o…
Consider the table pictured above. The…
Calculated fields can be used as input for other calculated f…
The monthly payment on a car loan.
DateDiff
The value is a result of the Sums Function being applied to t…
Which of the following statements is t…
Calculated fields can be used as input for other calculated f…
The PMT function is best suited to det…
The monthly payment on a car loan.
25 terms
Access Chapter 3
Layout view
Bound
Design view
Form header
The Access view in which you can make changes to a form or re…
The term used to describe objects and controls that are based…
An Access view that displays the detailed structure of a quer…
Information, such as a form's title, that displays at the top…
Layout view
The Access view in which you can make changes to a form or re…
Bound
The term used to describe objects and controls that are based…
45 terms
Access Chapter 3 Vocabulary
AND Condition
Blank Report Tool
Bound
Bound Control
A condition in which only records where both specified values…
An Access feature with which you can create a report from scr…
A term used to describe objects and controls that are based o…
A contro that retrieves its data from an underlying table or…
AND Condition
A condition in which only records where both specified values…
Blank Report Tool
An Access feature with which you can create a report from scr…
90 terms
Access Chapter 3 & 4
Be based on multiple tables.
Index
Losing data
Trust
Access forms can...
A(n) _____ is a special list created in Access to speed up se…
Backing up a database is important and should be done regular…
When you open a database from a location displayed in the ___…
Be based on multiple tables.
Access forms can...
Index
A(n) _____ is a special list created in Access to speed up se…
23 terms
Access Chapter 3
A value that does not change.
A formula used to calculate new fields…
Determines the sequence by which opera…
Dictates the structure and components…
Constant
Expression
Order of Operations
Syntax
A value that does not change.
Constant
A formula used to calculate new fields…
Expression
31 terms
Interactions Access: Chapter 3 Vocabulary
advice
avalanche
blood
boss
(n) ideas offered to help someone with a problem or situation
(n) great mass of falling snow and ice
(n) The red (blue) fluid that flows in your body
(n) person in charge at work
advice
(n) ideas offered to help someone with a problem or situation
avalanche
(n) great mass of falling snow and ice
23 terms
Interactions Access, Chapter 3 - vocabulary
updates
call someone back
come by
get together with someone
updates
call someone back
23 terms
Access Chapter 3
A value that does not change.
A formula used to calculate new fields…
Determines the sequence by which opera…
Dictates the structure and components…
Constant
Expression
Order of Operations
Syntax
A value that does not change.
Constant
A formula used to calculate new fields…
Expression
34 terms
Interactions Access Chapter 3
post (n or v)
social media (n)
text message (n)
updates (n)
news or other information on social media
websites on the Internet where people can talk to each other…
a written message sent on a phone
new information, news, or technology
post (n or v)
news or other information on social media
social media (n)
websites on the Internet where people can talk to each other…
33 terms
Access Chapter 3
Database Structure
Total Row
SubDatasheet
Delete
Assigning names and types to all fields
Special row to include totals and other statistics
Availability is indicated by the plus sign in front of the rows
Remove records from a table
Database Structure
Assigning names and types to all fields
Total Row
Special row to include totals and other statistics
29 terms
Access Quiz Chapter 3
Layout view
Bound
Design view
Form header
The Access view in which you can make changes to a form or re…
Term used to describe objects and controls that are based on…
Access view that displays the detailed structure of a form or…
Information such as a form's title that displays at the top o…
Layout view
The Access view in which you can make changes to a form or re…
Bound
Term used to describe objects and controls that are based on…
90 terms
Access Chapter 3 & 4
Be based on multiple tables.
Index
Losing data
Trust
Access forms can...
A(n) _____ is a special list created in Access to speed up se…
Backing up a database is important and should be done regular…
When you open a database from a location displayed in the ___…
Be based on multiple tables.
Access forms can...
Index
A(n) _____ is a special list created in Access to speed up se…
31 terms
Access Chapter 3 Vocabulary
action query
allowable values
append query
calculated field
is one that makes some adjustments to your database or the data
the value of a function
An action query that adds new records to the end of an existi…
a field that derives its value from a formula that references…
action query
is one that makes some adjustments to your database or the data
allowable values
the value of a function
11 terms
Access Chapter 3 Vocabulary
Split Form
Filter
Common Filters
Lookup Field
A form that allows you to simultaneously view both simple for…
Records that satisfies the criterion
Basic filters that are given by access
Allows the user to select from a list of values when updating…
Split Form
A form that allows you to simultaneously view both simple for…
Filter
Records that satisfies the criterion
11 terms
Access Chapter 3 Vocabulary
Split Form
Filter
Common Filters
Lookup Field
A form that allows you to simultaneously view both simple for…
To have only the record or records that satisfy the criterion…
Filtering individual fields by clicking the arrow to the righ…
This drops down a list of the spicific fields in wich Access…
Split Form
A form that allows you to simultaneously view both simple for…
Filter
To have only the record or records that satisfy the criterion…
31 terms
Access Chapter 3 Vocabulary
action query
allowable values
append query
calculated field
adds, deletes, or changes data in a table
also called legal values for the customer type field are HS,…
you can add the results of a query to an existing table by us…
also called computed field its a field that can be computed f…
action query
adds, deletes, or changes data in a table
allowable values
also called legal values for the customer type field are HS,…
31 terms
access chapter 3 vocabulary
action query
allowable values
append query
calculated field
adds, deletes, or changed in a table
for the customer type field are HS, COM, and UNI. The followi…
you can add the results of a query to an existing table by us…
a field that can be computed from other fields
action query
adds, deletes, or changed in a table
allowable values
for the customer type field are HS, COM, and UNI. The followi…
31 terms
access chapter 3 vocabulary
action query
allowable values
append query
calculated field
adds, deletes, or changes data in a table
HS COM UNI
you can add the results of a query to an existing table
a field that can be computed from other fields
action query
adds, deletes, or changes data in a table
allowable values
HS COM UNI
50 terms
Chapter 3 Access
archive table
database structure
relationship report button
relationships button
A table that contains data that is no longer used in operatio…
you assign names and types to all the fields
To produce a report of the relationship
to print a copy of a relationship click the__
archive table
A table that contains data that is no longer used in operatio…
database structure
you assign names and types to all the fields
11 terms
Access Chapter 3 Vocab
Split Form
Filter
Common Filters
Lookup Field
form that allows you to simultaneously view both simple form…
to have only the record or records that satisfy the criterion…
filters that appear when clicking the arrow to the right of t…
allows the user to select from a list of values when updating…
Split Form
form that allows you to simultaneously view both simple form…
Filter
to have only the record or records that satisfy the criterion…
11 terms
Access Chapter 3 Vocab.
Split Form
Filter
Common Filters
Lookup Field
Gives you one or two views of your data at the same time.
Allows you to have only the record or records that satisfy th…
Allows you to filter using specific criterion. (Looking for d…
Allows the user to select from a list of values when updating…
Split Form
Gives you one or two views of your data at the same time.
Filter
Allows you to have only the record or records that satisfy th…
11 terms
Access Chapter 3
Split Form
Filter
Common Filter
Lookup Field
A form that allows you to simultaneously view both simple for…
Used to only show a record(s) that meets a criterion
Commonly used ways to show specific records
Allows users to select from a list of values when updating th…
Split Form
A form that allows you to simultaneously view both simple for…
Filter
Used to only show a record(s) that meets a criterion
31 terms
Access Chapter 3 Vocabulary
action query
allowable values
append query
calculated field
adds, deletes, or changes data in a table.
for the customer type field are HS, COM, and UNI.
you can add the results of a query to an existing table
a field that can be computed from other fields
action query
adds, deletes, or changes data in a table.
allowable values
for the customer type field are HS, COM, and UNI.
31 terms
access chapter 3 vocabulary
maintaining the database
restructure the database
split form
searching
means modifying the data to keep it up to date by adding new…
to change the database structure.
a form that allows you to simultaneously view both simple for…
means looking for records that satisfy some criteria.
maintaining the database
means modifying the data to keep it up to date by adding new…
restructure the database
to change the database structure.
51 terms
Access Chapter 3 vocab
A form that allows you to simultaneous…
means looking for records that satisfy…
To have only the record or records tha…
allows users to select from a list of…
split form
searching
filter
lookup field
A form that allows you to simultaneous…
split form
means looking for records that satisfy…
searching
31 terms
Access Chapter 3 Vocabulary
action query
allowable values
append query
calculated field
adds, deletes, or changes data in a table.
legal.
add the results of a query to an existing table.
a field that can be computed from other fields.
action query
adds, deletes, or changes data in a table.
allowable values
legal.
31 terms
Access Chapter 3 Vocabulary
action query
allowable values
append query
calculated field
adds, deletes, or changes data in a table
also known as legal values, for the Customer Type field are H…
you can add the results of a query to an existing table
a field that can be computed from other fields
action query
adds, deletes, or changes data in a table
allowable values
also known as legal values, for the Customer Type field are H…
31 terms
Access chapter 3 vocabulary
action query
allowable values
append query
calculated field
adds, delete, or changes data in a table
HS, COM, and UNI
you can add the results of a query to an existing table
a field that can be computed from another field
action query
adds, delete, or changes data in a table
allowable values
HS, COM, and UNI
31 terms
access chapter 3 vocabulary
action query
allowable values
append query
calculated field
Adds, deletes, or changes data in a table.
creates a validation rule to specify HS, COM, and UNI as the…
Adds results of a query to an existing table.
A field that can be computed from other fields. Also known as…
action query
Adds, deletes, or changes data in a table.
allowable values
creates a validation rule to specify HS, COM, and UNI as the…
31 terms
Chapter 3 Access Vocabulary
Action Query
Allowable Values
Append Query
Calculated Field
Action Query adds, deletes, or changes data in a table.
The only legal values, or allowable values, for the Customer…
You can add the results of a query to an existing table by us…
A field that can be computed from other fields called a calcu…
Action Query
Action Query adds, deletes, or changes data in a table.
Allowable Values
The only legal values, or allowable values, for the Customer…
29 terms
Access Chapter 3 Vocabulary
maintaining the database
restructure the database
split form
searching
modifying data to keep it up to date by adding new records, c…
adding new fields to a table, changing characteristics of fie…
form that allows you to simultaneously view both simple form…
looking for records that satisfy some criteria.
maintaining the database
modifying data to keep it up to date by adding new records, c…
restructure the database
adding new fields to a table, changing characteristics of fie…
35 terms
Access chapter 3
maintaining data base
restructure the data base
validation rules
referential integrity
modifying the data to keep it up to date by adding new stuff…
a change to the database structure
ensure validity of the data in the database... and are rules tha…
ensures the validity on the relationship
maintaining data base
modifying the data to keep it up to date by adding new stuff…
restructure the data base
a change to the database structure
15 terms
Access Chapter 3
LAYOUT
COLUMNAR LAYOUT
SINGLE FORM VIEW
LAYOUT VIEW
Determines how data an labels are arranged in a form or report.
Places labels in the first column and data in the second colu…
A view that displays one record at a time with field names in…
Used to format a form or report while you are viewing a sampl…
LAYOUT
Determines how data an labels are arranged in a form or report.
COLUMNAR LAYOUT
Places labels in the first column and data in the second colu…
13 terms
Access Chapter 3
Aggregate Function
Argument
Constant
Expression
Performs calculations on an entire column of data and returns…
Any data needed to produce output for a function
A value that does not change
A formula used to calculate new fields from the values in exi…
Aggregate Function
Performs calculations on an entire column of data and returns…
Argument
Any data needed to produce output for a function
17 terms
Chapter 3 Access Vocab
Advanced Filter/Sort
BETWEEN
common filter
delete
Filters used to find only the records you want or sorted by t…
Criterion involving select values in a given range
...
...
Advanced Filter/Sort
Filters used to find only the records you want or sorted by t…
BETWEEN
Criterion involving select values in a given range
25 terms
Access Chapter 3
Layout view
Bound
Design view
Form header
The Access view in which you can make changes to a form or re…
The term used to describe objects and controls that are based…
An Access view that displays the detailed structure of a quer…
Information, such as a form's title, that displays at the top…
Layout view
The Access view in which you can make changes to a form or re…
Bound
The term used to describe objects and controls that are based…
29 terms
access chapter 3 vocabulary
action query
allowable values
append query
calculated field
adds, deletes, or changes data in a table
creates a validation rule to specify these as the only legal…
add the results of a query to an existing table
a field that can be computed from other fields
action query
adds, deletes, or changes data in a table
allowable values
creates a validation rule to specify these as the only legal…
31 terms
Access Chapter 3 Vocabulary
action query
allowable values
append query
calculated field
adds, deletes, or changes data in a table
Customer Type field are HS,COM, and UNI
add the results of a query to an existing table
a field that can be computed from other fields
action query
adds, deletes, or changes data in a table
allowable values
Customer Type field are HS,COM, and UNI
32 terms
Access Chapter 3
expression
identifiers
arithmetic operators
functions
formula used to calculate new fields from the values in exist…
the names of fields, controls or properties
for example: *, /, +, -
built-in like Date or Pmt
expression
formula used to calculate new fields from the values in exist…
identifiers
the names of fields, controls or properties
31 terms
Access Chapter 3 Vocabulary
action query
allowable values
append query
calculated field
adds, deletes, or changes data in a table
Customer Type field are HS, COM, AND UNI
you can add the results of a query to an existing table
a field that can be computed from other fields
action query
adds, deletes, or changes data in a table
allowable values
Customer Type field are HS, COM, AND UNI
31 terms
Access Chapter 3 Vocabulary
Action Query
Allowable Values
Append Query
Calculated Field
queries that add, change or delete data
Values that satisfy a validation rule, also called a legal va…
Adding the results of a query to an existing table
Field that can be computed from other fields
Action Query
queries that add, change or delete data
Allowable Values
Values that satisfy a validation rule, also called a legal va…
11 terms
Access Chapter 3 Vocab
Split Form
Filter
Common Filters
Lookup Field
Form that simultaneously allows you to view simple and datash…
Makes only records that support the criteria appear
Filter individual fields
Allows you to select form a list when updating field contents
Split Form
Form that simultaneously allows you to view simple and datash…
Filter
Makes only records that support the criteria appear
11 terms
Access chapter 3
Split Form
Filter
Common Filters
Lookup Field
gives you two views of your data at the same time a Form view…
A set of criteria applied to data in order to display a subse…
These circuits are generally designed to remove certain frequ…
display a user friendly value that is bound to another value…
Split Form
gives you two views of your data at the same time a Form view…
Filter
A set of criteria applied to data in order to display a subse…
11 terms
Access Chapter 3 Vocab
Split Form
Filter
Common Filters
Lookup Field
allows you to view both simple form and data sheet views of d…
only displays only the records that satisfy the criterion
the filters available from clicking the arrow next to the fie…
allows users to select from a list of values while updating t…
Split Form
allows you to view both simple form and data sheet views of d…
Filter
only displays only the records that satisfy the criterion
Access Chapter 3 Vocab
Split Form
Filter
Common Filters
Lookup Field
a form that allows you to simultaneously view both simple for…
Show only the record or records that satisfy the criterion ap…
Filters that appear to the right of the field name when you c…
allows the user to select from a list of values when updating…
Split Form
a form that allows you to simultaneously view both simple for…
Filter
Show only the record or records that satisfy the criterion ap…
1 of 10