Study sets matching "access chapter 3"

Study sets
Classes
Users

Study sets matching "access chapter 3"

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.
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…
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…
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
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…
28 terms
Access Chapter 3
aggregate function
argument
constant
expression
performs calculations on an entire column of data and returns…
a variable, constant, or expression that is needed to produce…
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
a variable, constant, or expression that is needed to produce…
10 terms
Chapter 3 Access
Form Wizard
Layout
Title
Input Mask
A tool used to create a form that provides a way to select ta…
The arrangement of data and labels in a form or report—column…
A form control that displays the name of a form by default; t…
A set of special characters that control what can and cannot…
Form Wizard
A tool used to create a form that provides a way to select ta…
Layout
The arrangement of data and labels in a form or report—column…
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
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
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…
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…
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
6 terms
Access chapter 3 terms
aggregate function
expression
grouping
property sheet
performs calculations on an entire column of data and returns…
a formula used to calculate new fields from the values in exi…
allows you to summarize your data by the values of a field
enables you to change settings such as number format, number…
aggregate function
performs calculations on an entire column of data and returns…
expression
a formula used to calculate new fields from the values in exi…
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
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
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
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, 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…
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
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
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…
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…
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 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…
10 terms
access chapter 3
ascending
composite key
descending
filter
order that sorts data from beginning to end, such as from A t…
two or more primary keys in a table.
order that sorts data from the end to the beginning, such as…
a set of rules for determining which records will be displayed.
ascending
order that sorts data from beginning to end, such as from A t…
composite key
two or more primary keys in a table.
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
Access Chapter 3 Vocabulary
look up field
input mask
form
split form
A list of values from which to choose when entering informati…
A pattern to follow for entering data in a field.
An alternative view of a table or query displaying the fields…
A form that shows a related table in a separate pane below th…
look up field
A list of values from which to choose when entering informati…
input mask
A pattern to follow for entering data in a field.
Chapter 3 Access
Action argument
Columnar layout
Control
Edit mode
An additional instruction that determines how the macro actio…
A layout that places labels in the first column and data in t…
An object on a form or in a report such as a label or a text…
A mode that selects the text inside a control, not the contro…
Action argument
An additional instruction that determines how the macro actio…
Columnar layout
A layout that places labels in the first column and data in t…
31 terms
Access Chapter 3
Action Query
Allowable Values
Append Query
Calculated Field
adds, deletes, or changes data in a table.
for the Customer Type of field are HS, COM, and UNI.
you can add 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 of field are HS, COM, and UNI.
Access Chapter 3
Split Form
Filter
Common Filters
Lookup Field
The screen splits: the top half is the form view, the bottom…
Changing the criteria to view all the records that meet the c…
Filters that Access allows you to type in to see the records…
Allows you to choose options that you want to appear in a fie…
Split Form
The screen splits: the top half is the form view, the bottom…
Filter
Changing the criteria to view all the records that meet the c…
31 terms
Access Chapter 3 Vocabulary
action query
allowable values
append query
calculated field
adds, deletes, or changes data in a table.
the following step creates a validation rule to specify these…
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
the following step creates a validation rule to specify these…
23 terms
Access Chapter 3
Hands-On Exercise #1
Order of Operations (pg.186)
Expression (pg.187)
Constant (pg.187)
...
Determines the sequence by which operations are calculated in…
A formula used to calculate new fields form the values in exi…
Refers to a value that does not change.
Hands-On Exercise #1
...
Order of Operations (pg.186)
Determines the sequence by which operations are calculated in…
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…
adds the records in a query's result set to the end of an exi…
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…
27 terms
Access Chapter 3
maintaining the database
restructure the database
split form
searching
modifying the data to keep it up to date by adding new record…
changing the database structure; can include adding new field…
form that allows you to simultaneously view both simple form…
looking for records that satisfy some criteria
maintaining the database
modifying the data to keep it up to date by adding new record…
restructure the database
changing the database structure; can include adding new field…
1 of 10