EXAM 3 Flashcards
Access
Access (AC 1): A computer program that is used to enter, maintain, and retrieve related data in a database.
Access Window
Access window (AC 3): The program window that appears when you create a new database or open an existing database.
Add & Delete group
Add & Delete group (AC 2): Contains options for adding different types of fields, including text and currency, to a table.
All Access Objects
The default category in the navigation pane which lists all the database objects in the pane.
Autonumber
An Access data type that automatically assigns a unique number to a record
Backing
Backing up a database is the process of making a copy of the database file to protects your database against loss or damage.
Click to Add Column
Provides another way for you to add new fields to a table.
Column Selector
AKA field selector; selects the entire row which you then can manipulate
Common Field
What is used to connect the records in the separate tables that appear in both tables.
Compacting
Compacting a database rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly.
Create Tab
Provides options for creating various database objects, including tables, forms, and reports.
Current Record Box
displays the number of the current record as well as the total number of records in the table.
Data type
determines what field values you can enter for the field
Database
A collection of related tables
database management system (DBMS)
database management system (DBMS) (AC 6): A software program that lets you create databases and then manipulate data in them.
Datasheet
Displays the table’s content in rows and columns, similar to a table that you create in a Word document or an Excel spreadsheet. Each row will be a separate record in the table, and each column will contain the field values for one field in the table.
Datasheet Selector
Click this to select all the records in the table
Fields Tab
Provides options for adding, removing, and formatting the fields in a table.
Foreign Key
A primary key field from one table that you include as a field in a second table to form a relationship between the two tables.
Form
A database object you use to enter, edit, and view records in a database.
Form Tool
quickly creates a form containing all the fields in the table, or query, on which you’re basing the form.
ID Column
The default primary key field for all new tables.
Layout View
In layout view, you can make design changes to the form while it is displaying data, so that you can see the effects of the changes you make immediately.
Pencil Symbol
indicates that the record is being edited
Primary Key
A field, or collection of fields, whose valise uniquely identify each record in a table.
Query
A question you ask about the data stores in a database. In response to a query, Access displays the specific records and fields that answer your question.
Record
Set of field values
Record Selector
selects the entire column or row, which you then can manipulate..
relational database management system
relational database management system (AC 6) data is organized as a collection of tables
Report
A formatted printout of the contents of one or more tables or queries in a database.
Report Tool
Places all the fields from a selected table, or query, on a report, making it the quickest way to create a report.
Shutter Bar Open/Close Button
Allows you to close and open the Navigation Panes; you might want to close the pane so that you have more room on the screen to view the objects contents.
Simple Query Wizard
Allows you to select records and fields quickly to display in the query results.
Star Symbol
Identifies the second row as the next row available for a new record
Template
A predesigned database that includes professionally designed tables, reports, and other database objects that can make it quick and easy for you to create a database.
Text
Data type in Acces which allows field values containing letters, digits, and other characters, and which is appropriate for identifying numbers that are never used in calculations
Aggregate Function
a function that performs an arithmetic operation on selected records in a database
Aggregate Function
a function that performs an arithmetic operation on selected records in a database
And logical operator
The logical operator you use in a query when you want a record selected only if two or more conditions are met
And logical operator
The logical operator you use in a query when you want a record selected only if two or more conditions are met
Autofilter
An Access feature, available by clicking the arrow to the right of a field name in Datasheet view for a table or query, that enables you to quickly sort and display the field’s values in various ways
Autofilter
An Access feature, available by clicking the arrow to the right of a field name in Datasheet view for a table or query, that enables you to quickly sort and display the field’s values in various ways
Calculated field
A field that you create with an expression that displays the results of the expression in a datasheet, form, or report, but does not exist as a field in the database.
Calculated field
A field that you create with an expression that displays the results of the expression in a datasheet, form, or report, but does not exist as a field in the database.
Comparison
)- In a query, an operator that asks Access to compare the value in a database field to the condition value and to select all the records for which the relationship is true
Comparison
)- In a query, an operator that asks Access to compare the value in a database field to the condition value and to select all the records for which the relationship is true
Condition
A criterion, or rule, that determines which records are selected in a query
Condition
A criterion, or rule, that determines which records are selected in a query
Design grid
The portion of the Query window in Design view in which you specify the fields and record selection criteria for the query you are creating
Design grid
The portion of the Query window in Design view in which you specify the fields and record selection criteria for the query you are creating
Editing mode
The mode in which you can insert or delete characters in a field value based on the location of the insertion point.
Editing mode
The mode in which you can insert or delete characters in a field value based on the location of the insertion point.
Exact match
A type of query in which the value in the specified field must match the condition exactly in order for the record to be included in the query results
Exact match
A type of query in which the value in the specified field must match the condition exactly in order for the record to be included in the query results
Expand indicator
In a datasheet, the plus sign that lets you display the related records in the sub datasheet
Expand indicator
In a datasheet, the plus sign that lets you display the related records in the sub datasheet
Expression
)- A statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation
Expression
)- A statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation
Expression Builder
An Access tool that makes it easy to create and expression by providing boxes for entering the expression, options for displaying and selecting common operators, and one or more lists of expression elements, such as table and field names.
Expression Builder
An Access tool that makes it easy to create and expression by providing boxes for entering the expression, options for displaying and selecting common operators, and one or more lists of expression elements, such as table and field names.
F2 key
The function key you press to switch between navigation mode and editing mode in a datasheet
F2 key
The function key you press to switch between navigation mode and editing mode in a datasheet
Filter
A set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of the records
Filter
A set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of the records
Filter by form
A filtering technique that changes a datasheet or form to display blank fields, allowing you to select a value from a list in any blank field to apply a filter that selects only those records containing that value
Filter by form
A filtering technique that changes a datasheet or form to display blank fields, allowing you to select a value from a list in any blank field to apply a filter that selects only those records containing that value
Filter by selection
A filtering technique that lets you select all or part of a field value in a datasheet or form, and then display only those records that contain the selected value in the field
Filter by selection
A filtering technique that lets you select all or part of a field value in a datasheet or form, and then display only those records that contain the selected value in the field
Find command
A command you use to search for data in a form or a table or query datasheet so that you can locate a specific field value or part of a field value
Find command
A command you use to search for data in a form or a table or query datasheet so that you can locate a specific field value or part of a field value
Group by operator
In a query, an operator that divided the selected records into groups cased on the values in the specified field
Group by operator
In a query, an operator that divided the selected records into groups cased on the values in the specified field
Logical operator
In a query, an operator that allows you to combine two or more conditions
Logical operator
In a query, an operator that allows you to combine two or more conditions
Navigation mode
The mode in which Access selects and entire field value, and your typed entry replaces the highlighted field value
Navigation mode
The mode in which Access selects and entire field value, and your typed entry replaces the highlighted field value