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
Nonunique (sort field)
A sort field for which more tan one record can have the same value
Nonunique (sort field)
A sort field for which more tan one record can have the same value
Object type
The default category in the navigation pane; it arranges objects by type
Object type
The default category in the navigation pane; it arranges objects by type
Or logical operator
)- The logical operator you use in a query when you want a record selected if at least one the specified conditions in met
Or logical operator
)- The logical operator you use in a query when you want a record selected if at least one the specified conditions in met
Plus sign (+)
In a datasheet, a symbol indicating that records have related records in another table
Plus sign (+)
In a datasheet, a symbol indicating that records have related records in another table
Primary sort field
The first sort field specified that determines the order of records in an object
Primary sort field
The first sort field specified that determines the order of records in an object
Query by Example
An example of the information you are requesting from Access in a query
Query by Example
An example of the information you are requesting from Access in a query
Recordset
The set of records that result from running a query
Recordset
The set of records that result from running a query
Run (a query)
To answer a query and display the results
Run (a query)
To answer a query and display the results
Secondary sort field
A second field that determines the order of record in an object that are already sorted by the primary sort field
Secondary sort field
A second field that determines the order of record in an object that are already sorted by the primary sort field
Select
A query in which you specify the fields and records in an object that are already sorted by the primary sort field
Select
A query in which you specify the fields and records in an object that are already sorted by the primary sort field
Sort
To rearrange records in a specified order or sequence
Sort
To rearrange records in a specified order or sequence
Sort Field
The field used to determine the order of records in a datasheet
Sort Field
The field used to determine the order of records in a datasheet
Subdatasheet
A datasheet that displays the records related to the current record
Subdatasheet
A datasheet that displays the records related to the current record
Theme
A predefined set of formats including colors, fonts, and other effects that enhance a database object’s appearance and usability
Theme
A predefined set of formats including colors, fonts, and other effects that enhance a database object’s appearance and usability
unique (sort field)
A sort field whose value is different for each record
unique (sort field)
A sort field whose value is different for each record
Unique (a database)
To add, change, and delete records in database tables to keep them current and accurate
Unique (a database)
To add, change, and delete records in database tables to keep them current and accurate
Zoom box
A dialog box you can use to enter text, expressions, or other values
Zoom box
A dialog box you can use to enter text, expressions, or other values
Best fit
When you double-click the pointer on the column dividing line, you’re sizing them to its best fit, so the column is just wide enough to display the longest visible in the column, including the field name
Best fit
When you double-click the pointer on the column dividing line, you’re sizing them to its best fit, so the column is just wide enough to display the longest visible in the column, including the field name
Byte
)- stores whole numbers from 0 to 225 in on byte
Byte
)- stores whole numbers from 0 to 225 in on byte
Caption property
specifies how the field name is displayed in database objects, including table and query datasheets, forms, and reports
Caption property
specifies how the field name is displayed in database objects, including table and query datasheets, forms, and reports
Cascade Delete Related Records options
An option you can set to enforce the referential integrity rule that permits a record in the primary table to be deleted and also deletes all records in related tables that having matching foreign key values.
Cascade Delete Related Records options
An option you can set to enforce the referential integrity rule that permits a record in the primary table to be deleted and also deletes all records in related tables that having matching foreign key values.
Cascade Update Related Fields option
An option you can set to enforce the referential integrity rule that permits a change in value to the primary key and changes the appropriate foreign key value in related tables.
Cascade Update Related Fields option
An option you can set to enforce the referential integrity rule that permits a change in value to the primary key and changes the appropriate foreign key value in related tables.
Composition key
the primary key that consists of two or more fields
Composition key
the primary key that consists of two or more fields
Ctril+’
Allows you to quickly insert the value from the same column in the previous record
Ctril+’
Allows you to quickly insert the value from the same column in the previous record
Data redundancy
)- A condition that occurs when you store the same data in more than one place; it wastes storage space and can cause inconsistencies
Data redundancy
)- A condition that occurs when you store the same data in more than one place; it wastes storage space and can cause inconsistencies
Data type gallery
Available in the add and delete group on the fields tab, allows you to add a group of related fields to a table at the same time, rather than adding each field to the table individually.
Data type gallery
Available in the add and delete group on the fields tab, allows you to add a group of related fields to a table at the same time, rather than adding each field to the table individually.
Decimal
stores positive and negative numbers to precisely 28 decimal places and uses 12 bytes
Decimal
stores positive and negative numbers to precisely 28 decimal places and uses 12 bytes
Decimal Places property
the property that specifies the number of decimal places that will be displayed to the right of the decimal point
Decimal Places property
the property that specifies the number of decimal places that will be displayed to the right of the decimal point
Delimited
A type of text file in which fields of data are separated by a character such as a comma or tab
Delimited
A type of text file in which fields of data are separated by a character such as a comma or tab
Description property
optional property you can use to enter a description for a field to explain its purpose or usage
Description property
optional property you can use to enter a description for a field to explain its purpose or usage
Design view (for a table)
)- The Access view you use to define or modify a table structure or the properties of the fields in a table
Design view (for a table)
)- The Access view you use to define or modify a table structure or the properties of the fields in a table
Double
stores positive and negative numbers to precisely 15 decimal places and uses eight bytes.
Double
stores positive and negative numbers to precisely 15 decimal places and uses eight bytes.
Entity Integrity
The condition that exists when a primary key has been specified for a table, whereby Access forces you to enter a value for the primary key field in to every record in the table
Entity Integrity
The condition that exists when a primary key has been specified for a table, whereby Access forces you to enter a value for the primary key field in to every record in the table
F1 Key
The function key you press to display Help information, such as the current property in Table Design view
F1 Key
The function key you press to display Help information, such as the current property in Table Design view
F6 Key
The function key you press to move from the Table Design grid to the Field Properties pane of the Table window in Design view
F6 Key
The function key you press to move from the Table Design grid to the Field Properties pane of the Table window in Design view
Field List
A window listing the fields contained in a table in the order in which they appear
Field List
A window listing the fields contained in a table in the order in which they appear
Field Properties pane
)- The part of the table window in design view that contains the properties for the selected field
Field Properties pane
)- The part of the table window in design view that contains the properties for the selected field
Field Size Property
The property that defines a field’s maximum storage size for Text, Number, and AutoNumber fields
Field Size Property
The property that defines a field’s maximum storage size for Text, Number, and AutoNumber fields
Import
A process that allows you to copy the data from a source, without having to open the source file, and to add the imported date in and Access table
Import
A process that allows you to copy the data from a source, without having to open the source file, and to add the imported date in and Access table
Integer
Stores whole numbers from -32,768 to 32,767 in two bytes
Integer
Stores whole numbers from -32,768 to 32,767 in two bytes
Join
The process of relating tables using a common field
Join
The process of relating tables using a common field
Join Line
In the Relationships window, the line that connects the common field that joins two tables
Join Line
In the Relationships window, the line that connects the common field that joins two tables
Long integer
(default) stores whole numbers from -2,147,483,648 to 2,147,483,647 in four bytes.
Long integer
(default) stores whole numbers from -2,147,483,648 to 2,147,483,647 in four bytes.
Null value
The value that results from not entering a value for a field; a null value is not permitted for a primary key
Null value
The value that results from not entering a value for a field; a null value is not permitted for a primary key
One-to-many relationship
The type of database relationships that exists between two tables when one record in the first table matches zero, one, or many records in the second table, and when one record in the second table matches at most one record in the first table
One-to-many relationship
The type of database relationships that exists between two tables when one record in the first table matches zero, one, or many records in the second table, and when one record in the second table matches at most one record in the first table
Orphaned record
)- A record whose matching record in either the primary or related table has been deleted
Orphaned record
)- A record whose matching record in either the primary or related table has been deleted
Primary table
the “one” table in a one-to-many relationship
Primary table
the “one” table in a one-to-many relationship
Propagate
To update field property changes made in Table Design view to the corresponding property on forms and reports that include the modified field
Propagate
To update field property changes made in Table Design view to the corresponding property on forms and reports that include the modified field
Properties
The characteristics of each field in a table
Properties
The characteristics of each field in a table
Quick Start Selection
The name given to the group of fields you add to a table at the same time using Data Type gallery
Quick Start Selection
The name given to the group of fields you add to a table at the same time using Data Type gallery
Referential Integrity
A set of rules that Access enforce to maintain consistency between related tables when you update data in a database
Referential Integrity
A set of rules that Access enforce to maintain consistency between related tables when you update data in a database
Related table
The “many” table in a one-to-many relationship
Related table
The “many” table in a one-to-many relationship
Relationships window
The Access window in which you define and view the relationships among a database’s tables
Relationships window
The Access window in which you define and view the relationships among a database’s tables
Replication ID
Establishes a unique identifier for replication of tables, records, and other objects in databases created using Access 2003 and earlier versions and uses 16 bytes
Replication ID
Establishes a unique identifier for replication of tables, records, and other objects in databases created using Access 2003 and earlier versions and uses 16 bytes
Set (a property)
To select or enter a property for a field
Set (a property)
To select or enter a property for a field
Show Table button
A button on the relationship tools design tab that you click to open the show table dialog box, from where you can add tables to the relationships window
Show Table button
A button on the relationship tools design tab that you click to open the show table dialog box, from where you can add tables to the relationships window
Single
Stores positive and negative numbers to precisely seven decimals places and uses four bytes
Single
Stores positive and negative numbers to precisely seven decimals places and uses four bytes
Table Design grid
The part of the table window in design view that contains the vales for the field name, Data Type, and Description field properties
Table Design grid
The part of the table window in design view that contains the vales for the field name, Data Type, and Description field properties