EXAM 3 Flashcards
1
Q
Access
A
Access (AC 1): A computer program that is used to enter, maintain, and retrieve related data in a database.
2
Q
Access Window
A
Access window (AC 3): The program window that appears when you create a new database or open an existing database.
3
Q
Add & Delete group
A
Add & Delete group (AC 2): Contains options for adding different types of fields, including text and currency, to a table.
4
Q
All Access Objects
A
The default category in the navigation pane which lists all the database objects in the pane.
5
Q
Autonumber
A
An Access data type that automatically assigns a unique number to a record
6
Q
Backing
A
Backing up a database is the process of making a copy of the database file to protects your database against loss or damage.
7
Q
Click to Add Column
A
Provides another way for you to add new fields to a table.
8
Q
Column Selector
A
AKA field selector; selects the entire row which you then can manipulate
9
Q
Common Field
A
What is used to connect the records in the separate tables that appear in both tables.
10
Q
Compacting
A
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.
11
Q
Create Tab
A
Provides options for creating various database objects, including tables, forms, and reports.
12
Q
Current Record Box
A
displays the number of the current record as well as the total number of records in the table.
13
Q
Data type
A
determines what field values you can enter for the field
14
Q
Database
A
A collection of related tables
15
Q
database management system (DBMS)
A
database management system (DBMS) (AC 6): A software program that lets you create databases and then manipulate data in them.
16
Q
Datasheet
A
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.
17
Q
Datasheet Selector
A
Click this to select all the records in the table
18
Q
Fields Tab
A
Provides options for adding, removing, and formatting the fields in a table.
19
Q
Foreign Key
A
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.
20
Q
Form
A
A database object you use to enter, edit, and view records in a database.
21
Q
Form Tool
A
quickly creates a form containing all the fields in the table, or query, on which you’re basing the form.
22
Q
ID Column
A
The default primary key field for all new tables.
23
Q
Layout View
A
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.
24
Q
Pencil Symbol
A
indicates that the record is being edited
25
Primary Key
A field, or collection of fields, whose valise uniquely identify each record in a table.
26
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.
27
Record
Set of field values
28
Record Selector
selects the entire column or row, which you then can manipulate..
29
relational database management system
relational database management system (AC 6) data is organized as a collection of tables
30
Report
A formatted printout of the contents of one or more tables or queries in a database.
31
Report Tool
Places all the fields from a selected table, or query, on a report, making it the quickest way to create a report.
32
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.
33
Simple Query Wizard
Allows you to select records and fields quickly to display in the query results.
34
Star Symbol
Identifies the second row as the next row available for a new record
35
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.
36
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
37
Aggregate Function
a function that performs an arithmetic operation on selected records in a database
37
Aggregate Function
a function that performs an arithmetic operation on selected records in a database
38
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
38
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
39
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
39
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
40
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.
40
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.
41
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
41
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
42
Condition
A criterion, or rule, that determines which records are selected in a query
42
Condition
A criterion, or rule, that determines which records are selected in a query
43
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
43
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
44
Editing mode
The mode in which you can insert or delete characters in a field value based on the location of the insertion point.
44
Editing mode
The mode in which you can insert or delete characters in a field value based on the location of the insertion point.
45
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
45
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
46
Expand indicator
In a datasheet, the plus sign that lets you display the related records in the sub datasheet
46
Expand indicator
In a datasheet, the plus sign that lets you display the related records in the sub datasheet
47
Expression
)- A statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation
47
Expression
)- A statement containing a combination of database fields, constants, and operators that you define in a query to perform a calculation
48
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.
48
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.
49
F2 key
The function key you press to switch between navigation mode and editing mode in a datasheet
49
F2 key
The function key you press to switch between navigation mode and editing mode in a datasheet
50
Filter
A set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of the records
50
Filter
A set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of the records
51
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
51
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
52
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
52
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
53
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
53
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
54
Group by operator
In a query, an operator that divided the selected records into groups cased on the values in the specified field
54
Group by operator
In a query, an operator that divided the selected records into groups cased on the values in the specified field
55
Logical operator
In a query, an operator that allows you to combine two or more conditions
55
Logical operator
In a query, an operator that allows you to combine two or more conditions
56
Navigation mode
The mode in which Access selects and entire field value, and your typed entry replaces the highlighted field value
56
Navigation mode
The mode in which Access selects and entire field value, and your typed entry replaces the highlighted field value
57
Nonunique (sort field)
A sort field for which more tan one record can have the same value
57
Nonunique (sort field)
A sort field for which more tan one record can have the same value
58
Object type
The default category in the navigation pane; it arranges objects by type
58
Object type
The default category in the navigation pane; it arranges objects by type
59
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
59
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
60
Plus sign (+)
In a datasheet, a symbol indicating that records have related records in another table
60
Plus sign (+)
In a datasheet, a symbol indicating that records have related records in another table
61
Primary sort field
The first sort field specified that determines the order of records in an object
61
Primary sort field
The first sort field specified that determines the order of records in an object
62
Query by Example
An example of the information you are requesting from Access in a query
62
Query by Example
An example of the information you are requesting from Access in a query
63
Recordset
The set of records that result from running a query
63
Recordset
The set of records that result from running a query
64
Run (a query)
To answer a query and display the results
64
Run (a query)
To answer a query and display the results
65
Secondary sort field
A second field that determines the order of record in an object that are already sorted by the primary sort field
65
Secondary sort field
A second field that determines the order of record in an object that are already sorted by the primary sort field
66
Select
A query in which you specify the fields and records in an object that are already sorted by the primary sort field
66
Select
A query in which you specify the fields and records in an object that are already sorted by the primary sort field
67
Sort
To rearrange records in a specified order or sequence
67
Sort
To rearrange records in a specified order or sequence
68
Sort Field
The field used to determine the order of records in a datasheet
68
Sort Field
The field used to determine the order of records in a datasheet
69
Subdatasheet
A datasheet that displays the records related to the current record
69
Subdatasheet
A datasheet that displays the records related to the current record
70
Theme
A predefined set of formats including colors, fonts, and other effects that enhance a database object’s appearance and usability
70
Theme
A predefined set of formats including colors, fonts, and other effects that enhance a database object’s appearance and usability
71
unique (sort field)
A sort field whose value is different for each record
71
unique (sort field)
A sort field whose value is different for each record
72
Unique (a database)
To add, change, and delete records in database tables to keep them current and accurate
72
Unique (a database)
To add, change, and delete records in database tables to keep them current and accurate
73
Zoom box
A dialog box you can use to enter text, expressions, or other values
73
Zoom box
A dialog box you can use to enter text, expressions, or other values
74
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
74
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
75
Byte
)- stores whole numbers from 0 to 225 in on byte
75
Byte
)- stores whole numbers from 0 to 225 in on byte
76
Caption property
specifies how the field name is displayed in database objects, including table and query datasheets, forms, and reports
76
Caption property
specifies how the field name is displayed in database objects, including table and query datasheets, forms, and reports
77
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.
77
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.
78
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.
78
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.
79
Composition key
the primary key that consists of two or more fields
79
Composition key
the primary key that consists of two or more fields
80
Ctril+'
Allows you to quickly insert the value from the same column in the previous record
80
Ctril+'
Allows you to quickly insert the value from the same column in the previous record
81
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
81
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
82
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.
82
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.
83
Decimal
stores positive and negative numbers to precisely 28 decimal places and uses 12 bytes
83
Decimal
stores positive and negative numbers to precisely 28 decimal places and uses 12 bytes
84
Decimal Places property
the property that specifies the number of decimal places that will be displayed to the right of the decimal point
84
Decimal Places property
the property that specifies the number of decimal places that will be displayed to the right of the decimal point
85
Delimited
A type of text file in which fields of data are separated by a character such as a comma or tab
85
Delimited
A type of text file in which fields of data are separated by a character such as a comma or tab
86
Description property
optional property you can use to enter a description for a field to explain its purpose or usage
86
Description property
optional property you can use to enter a description for a field to explain its purpose or usage
87
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
87
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
88
Double
stores positive and negative numbers to precisely 15 decimal places and uses eight bytes.
88
Double
stores positive and negative numbers to precisely 15 decimal places and uses eight bytes.
89
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
89
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
90
F1 Key
The function key you press to display Help information, such as the current property in Table Design view
90
F1 Key
The function key you press to display Help information, such as the current property in Table Design view
91
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
91
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
92
Field List
A window listing the fields contained in a table in the order in which they appear
92
Field List
A window listing the fields contained in a table in the order in which they appear
93
Field Properties pane
)- The part of the table window in design view that contains the properties for the selected field
93
Field Properties pane
)- The part of the table window in design view that contains the properties for the selected field
94
Field Size Property
The property that defines a field’s maximum storage size for Text, Number, and AutoNumber fields
94
Field Size Property
The property that defines a field’s maximum storage size for Text, Number, and AutoNumber fields
95
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
95
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
96
Integer
Stores whole numbers from -32,768 to 32,767 in two bytes
96
Integer
Stores whole numbers from -32,768 to 32,767 in two bytes
97
Join
The process of relating tables using a common field
97
Join
The process of relating tables using a common field
98
Join Line
In the Relationships window, the line that connects the common field that joins two tables
98
Join Line
In the Relationships window, the line that connects the common field that joins two tables
99
Long integer
(default) stores whole numbers from -2,147,483,648 to 2,147,483,647 in four bytes.
99
Long integer
(default) stores whole numbers from -2,147,483,648 to 2,147,483,647 in four bytes.
100
Null value
The value that results from not entering a value for a field; a null value is not permitted for a primary key
100
Null value
The value that results from not entering a value for a field; a null value is not permitted for a primary key
101
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
101
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
102
Orphaned record
)- A record whose matching record in either the primary or related table has been deleted
102
Orphaned record
)- A record whose matching record in either the primary or related table has been deleted
103
Primary table
the "one" table in a one-to-many relationship
103
Primary table
the "one" table in a one-to-many relationship
104
Propagate
To update field property changes made in Table Design view to the corresponding property on forms and reports that include the modified field
104
Propagate
To update field property changes made in Table Design view to the corresponding property on forms and reports that include the modified field
105
Properties
The characteristics of each field in a table
105
Properties
The characteristics of each field in a table
106
Quick Start Selection
The name given to the group of fields you add to a table at the same time using Data Type gallery
106
Quick Start Selection
The name given to the group of fields you add to a table at the same time using Data Type gallery
107
Referential Integrity
A set of rules that Access enforce to maintain consistency between related tables when you update data in a database
107
Referential Integrity
A set of rules that Access enforce to maintain consistency between related tables when you update data in a database
108
Related table
The "many" table in a one-to-many relationship
108
Related table
The "many" table in a one-to-many relationship
109
Relationships window
The Access window in which you define and view the relationships among a database’s tables
109
Relationships window
The Access window in which you define and view the relationships among a database’s tables
110
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
110
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
111
Set (a property)
To select or enter a property for a field
111
Set (a property)
To select or enter a property for a field
112
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
112
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
113
Single
Stores positive and negative numbers to precisely seven decimals places and uses four bytes
113
Single
Stores positive and negative numbers to precisely seven decimals places and uses four bytes
114
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
114
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
