Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
122 Cards in this Set
- Front
- Back
|
Access Database Executable (ACCDE) file
|
An Access database file that has been compiled and compacted for distribution. The ACCDE file format allows users to view forms and reports, update information, and run queries, but prevents them from changing database objects.
|
|
|
Access Deployment (ACCDC) file
|
An Access database file that has been compressed and digitally signed for distribution.
|
|
|
application parts
|
Predefined database objects that you can add to an existing database. Access comes with 10 types of forms and several Quick Start parts.
|
|
|
action query
|
A type of query that performs an action on matched records, such as updating fields or deleting the records. See also select query.
|
|
|
aggregate function
|
A function that performs a calculation, such as Sum or Avg (average), on multiple values and returns a single summary value.
|
|
|
append query
|
A query that adds, or appends, records from one or more tables to the end of one or more tables.
|
|
|
arithmetic operator
|
An operator that is used with numerals: + (addition), - (subtraction), * (multiplication), or / (division).
|
|
|
back-end database
|
The portion of a split database that contains the tables that store all the data. The back-end database is kept on a central computer. See also front-end database and split database.
|
|
|
binary file
|
A file that contains encoded information that is interpreted by a computer according to the application that created it. In general, a binary file can be edited only by the application in which it was created. A binary file is not encrypted and is therefore not secure.
|
|
|
bound
|
Linked, as when a text box control is linked to a specific field in a table. See also unbound.
|
|
|
combo box
|
A control that combines a text box with a list box. This allows the user to type an entry or choose one from a list.
|
|
|
comma-delimited text file
|
A text file in which each field is separated from the next by a comma.
|
|
|
command button
|
Any button with which users initiate an immediation action. You can add command button controls to forms and reports.
|
|
|
comparison operator
|
An operator that compares two expressions, expressed as > (greater than), < (less than), = (equal to), >= (greater than or equal to), <= (less than or equal to), <> (not equal to), or like (pattern matching).
|
|
|
constant
|
A value that is not calculated and , therefore, does not change. For example the number 210 and the text Quarterly Earnings are constants. An expression, or a value resulting from an expression, is not a constant.
|
|
|
control
|
A graphical user interface object, such as a text box, combo box, or command button, that displays data or choices, performs an action, or makes a database object easier to use.
|
|
|
control property
|
A setting in the control's Property Sheet that determines the control's appearance, what kind of data it can display, and its behavior.
|
|
|
control source
|
The element, such as a field, table or query, to which a control is bound. See also record source.
|
|
|
crosstab query
|
A type of query that displays data for summarized values from a field or table and then groups them by two sets of facts: one down the left side, and the other across the top of the datasheet.
|
|
|
database application
|
A database that is made easier to use by the inclusion of queries, forms, reports, custom categories and groups, and various other tools.
|
|
|
database object
|
One of the components of an Access database, such as a table, query, form, report, macro, or module.
|
|
|
database program
|
An application from creating databases, ranging from simple databases that can store one table per file (referred to as flat databases) to more complex databases that can store information in multiple related tables (referred to as relational databases).
|
|
|
dtaabase security
|
Measures adopted to protect data from accidental or intentional corruption and make it difficult for unauthorized people to gain access to private information; for example, passwords, encryption, and ACCDE files.
|
|
|
Datasheet view
|
The view in which you can see and modify informaiton in a table or query. Along with Design View, this is one of the two most common views for tables. See also Design view and view.
|
|
|
delete query
|
A query that deletes records that match a specified pattern from on or more tables.
|
|
|
delimited text file
|
A text file that contains data in which individual field values are separated by a character, such as a comma or a tab.
|
|
|
delimiter
|
A character, such as a comma (,), semicolon (;), or backslash (\), that is used to separate records and fields in a delimited text file.
|
|
|
deselect
|
To click away from selected data or controls to release a selection.
|
|
|
design grid
|
In Design view, the grid in which you can manually work with advanced filters and queries.
|
|
|
Design view
|
The view in which you can see and modify the structure of a table, query, form, or report.
|
|
|
dialog box launcher
|
On the ribbon, a button at the bottom of some groups that opens a dialog box with features related to the group.
|
|
|
duplicate query
|
A type of select query that finds records containing identical information in one or more specified fields. Can be created with the assistance of the Find Duplicates Query wizard.
|
|
|
empty string
|
A string with the value "" (two quotation marks with nothing between them).
|
|
|
encrypting
|
To encode (scramble) information in such a way that is is unreadable to all but those individuals possessing the key to the code.
|
|
|
exclusive use
|
A setting that permits only one person to have a database open. Generally used when setting or removing a database password.
|
|
|
exporting
|
The process of converting an Access table or database into a format that can be used by other programs. See also importing.
|
|
|
expression
|
A combination of functions, field values, constants, and operators that can be used to assign properties to tables or forms, to determine values in fields or reports, as a part of a query, and in many other places. Also known as a formula.
|
|
|
Expression Builder
|
A tool used to create an expression. The Expression Builder includes a list of common expressions that you can select from to define the properties you want to target.
|
|
|
Extensible Markup Language (XML)
|
A format for delivering rich, structured data in a standard, consistent way. XML tags describe the content of a Web document, whereas HTML tags describe how the document looks. XML allows designers to create their own customized tags. See also Hypertext Markup Language (HTML).
|
|
|
field
|
An element of a table that contains a specific item of information, such as a last name. A field is represented in Access as a column in a database table. See also record.
|
|
|
field property
|
A property that controls what can be put into a field and how it can be placed there.
|
|
|
filter
|
A set of criteria you can use to specify the information you want to display.
|
|
|
fixed-width text file
|
A common text file format that is often used to trnsfer data from older programs. The same field in every record contains the same number of characters. If the actual data doesn't fill a field, the field is padded with spaces so that the starting point of the data in the next field is the same number of characters from the beginning of every record.
|
|
|
flat database
|
A simple database that can store information in only one table. See also relational database.
|
|
|
form
|
An organized and formatted view of some or all of the fileds from one or more tables or queries. Forms work interactively with the tables in a database and are often used to simplify data entry.
|
|
|
form selector
|
The box at the intersection of the vertical and horizontal rulers when a form is displayed in Design view. You click the form selector to select the entire form.
|
|
|
front-end database
|
The portion of a split database that contains the forms, queries, and reports people use to work with data. The front end can be copied to the local computer of any user who needs to work with the database. See also back-end database and split database.
|
|
|
function
|
A named procedure or routine, often used for mathematical or financial calculations.
|
|
|
group
|
On a ribbon tab, an area containing buttons related to a specific database element or function. On the Navigation bar, a list that is part of a category.
|
|
|
grouping level
|
The level by which records are grouped in a report. When you group on a field, the report adds a group header and footer around each group of records that have the same value in that field.
|
|
|
HTML tag
|
A code that identifies an element in an HTML document, such as a heading or a paragraph, for the purposes of formatting, indexing, and linking information in the document.
|
|
|
Hypertext Markup Language (HTML)
|
A simple markup language used to create hypertext documents that are portable from one platform to another. HTML files are simple ASCII text files with embedded markup tags that control formatting and hypertext links. See also Extensible Markup Language (XML).
|
|
|
importing
|
The process of converting external data into a format that can be used by Access. See also exporting.
|
|
|
input mask
|
A property that controls the appearance, format, and type of data in a field.
|
|
|
label control
|
A control that contains text as it will appear on a form or report.
|
|
|
linking
|
The process of connecting to data in other programs so that you can view and edit it both in Access and the originating program.
|
|
|
logical operator
|
An operator, such as AND, OR, or NOT, that is used in queries and filters to extract matching records from tables.
|
|
|
Lookup wizard
|
An Access wizard with which you can create a lookup list.
|
|
|
main form
|
A form that contains other embedded subforms. See also subform.
|
|
|
main report
|
A report that serves as a shell for one or more embedded subreports. See also subreport.
|
|
|
make-table query
|
A query that combines all or part of the data from one or more tables into a new table.
|
|
|
many-to-many relationship
|
A relationship between two tables in which records in each table have multiple matching records in the related table. For exampe, each sales invoice can contain multiple products, and each product can appear on multiple sales invoices. See also one-to-many relationship and one-to-one relationship.
|
|
|
mapped network drive
|
A network drive to which you have assigned a drive letter so that it can be accessed as a hard drive on your local computer. See also Universal Naming Convention (UNC).
|
|
|
Microsoft Database Executable (MDE) file
|
The equivalent of an ACCDE file created by previous versions of Access. See Access Database Executable (ACCDE).
|
|
|
named range
|
A group of related spreadsheet cells defined by a single name.
|
|
|
navigation control
|
A control on a navigation form that consists of a placeholder for a navigation button and a subform or subreport control.
|
|
|
navigation form
|
A format that presents the user with a set of navigation buttons that can be clicked to display and work with forms and reports. Database designers can use navigation forms to make it easier for users to access and manipulate data and more difficult for them to unintentionally change or delete it.
|
|
|
Navigation pane
|
An area of the Access program window that enables the user to quickly open database objects.
|
|
|
network share
|
A storage location on a network that is shared with and accessible from authorized computers on the network.
|
|
|
normalization rules
|
A set of database design rules that minimizes data redundancy and results in a database in which referential integrity can be enforced.
|
|
|
Null
|
Nothing; a field with no entry.
|
|
|
one-to-many relationship
|
In relational databases, a relationship between two tables in which a single record in the first table can be related to one or more records in the second table, but a record in the second table can be related to only one record in the first table. See also many-to-many relationship and one-to-one relationship.
|
|
|
one-to-one relationship
|
In relational databases, a relationship between two tables in which a single record in the first table can be related to only one record in the second table, and a record in the second table can be related to only one record in the first table. See also many-to-many relationship and one-to-many relationship.
|
|
|
operator
|
See arithmetic operator, comparison operator, and logical operator.
|
|
|
option button
|
A control that allows a user to select from a fixed set of mutually exclusive choices.
|
|
|
parameter query
|
A type of query, that, when run, prompts for the values (criteria) to use to select the records for the result set so that the same query can be used to retrieve different result sets. See also action query, crosstab query, and select query.
|
|
|
parsing
|
The process of analyzing an imported document, such as an HTML document, and identifying anything that looks like structured data.
|
|
|
password
|
A string of characters used to access information or log on to a computer. Passwords help prevent unauthorized people from accessing files, programs, and other resources. See also secure password.
|
|
|
populating
|
To add data to a table or other object.
|
|
|
primary key
|
One or more fields whose value or values uniquely identify each record in a table. A primary key cannot allow Null values and must always have a unique index. In related tables, the primary key field in one table corresponds with the foreign key field in the other table.
|
|
|
property
|
A named attribute of a control, a field, or an object that you set to define one of the object's characteristics (such as size, color, or screen location) or an aspect of its behavior (such as whether the object is hidden).
|
|
|
publisher
|
The person or entity who digitally signs a database or other file, thereby guaranteeing its source.
|
|
|
query
|
A database object that locates specific information store in a table and allows you to view and manipulate the results. The results of a query can be used as the basis for forms and reports.
|
|
|
Quick Access Toolbar
|
A small, customizable toolbar that displays frequently used commands.
|
|
|
record
|
All the related information about a person or item in a table. A record in Access is represented as a row in a database table. See also field.
|
|
|
record selector
|
The gray bar along the left edge of a form in Form view. You can select an entire record by clicking its record.
|
|
|
record source
|
The source from which the data in a bound record originates. See also control source.
|
|
|
referential integrity
|
A restriction on data, requiring that in two related tables, an entry will not be allowed in one table unless it already exists in the other table.
|
|
|
relational database
|
A type of database that stores information in tables. Relational databases use matching value from two tables to relate data in one table to data in the other table. In a relational database, you typically store a specific type of data just once. See also flat database.
|
|
|
relationship
|
An association between common fields in two or more tables.
|
|
|
report
|
A database object used to display table information in a formatted, easily accessible manner, either on the screen or on paper. It can include items from multiple tables and queries, values calculated from information in the database, and formatting elements such as headers, footers, titles, and headings.
|
|
|
report selector
|
The box at the intersection of the vertical and horizontal rulers when a report is displayed in Design view. You click the report selector to select the entire report.
|
|
|
results datasheet
|
The presentation of the records matched by a query and any specified calculations in a table-like structure.
|
|
|
ribbon
|
A user interface design that organized commands into logical groups, which appear on separate tabs.
|
|
|
row selector
|
The gray box at the left end of each row in the field definition area when a table's structure is displayed in Design view.
|
|
|
schema
|
The definition of the structure of an XML file. A schema contains property information as it pertains to the records and fields within the structure.
|
|
|
secure password
|
A password that includes uppercase letters, lowercase letters, and symbols or numbers, and is not a word found in a dictionary. Also called a strong password.
|
|
|
security warning
|
A warning that appears when a database that contains one or more macros is opened.
|
|
|
select query
|
A query that matches records from one or more tables and displays them in a results datasheet. Can contain specifications for which fields to display in what order and how to group (summarize) their values. See also action query.
|
|
|
signing
|
The act of guaranteeing the source and content of a file by attaching a digital signature.
|
|
|
sorting
|
A method of arranging data based on the order of specified information.
|
|
|
split database
|
A database that has been organized into two parts: a back-end database containing the tables that store all the data, and a front-end database containing the forms, queries, and reports that people use to work with the data. See also back-end database and front-end database.
|
|
|
SQL database
|
A database based on Structured Query Language (SQL).
|
|
|
subdatasheet
|
A datasheet that is contained within another datasheet.
|
|
|
subform
|
A form that is contained within another form. See also main form.
|
|
|
subreport
|
A report that is contained within another report. See also main report.
|
|
|
syntax
|
The required format in which expressions must be entered.
|
|
|
tab
|
A tabbed page on the ribbon that contains buttons organized in groups. Also a navigation button attached to a database object that is open in the Access program window workspace. You click the button to display the object's page.
|
|
|
tabbed pages
|
The default display of objects in the Access program window. Alternatively, you can display objects in their own windows.
|
|
|
table
|
A structured arrangement of one or more rows and one or more columns. The intersection of each row and column is a cell. All the items of information in a row constitute a record, and all the items of information in a column constitute a field.
|
|
|
tag
|
A code in HTML or XML that gives instructions for formatting or defining the structure of a document.
|
|
|
template
|
A ready-made pattern that can be used to create a specific type of database. Access 2010 comes with several templates, all of which can be customized.
|
|
|
text box control
|
A control on a form or report in which text can be viewed, entered or edited. A text box control is bound to a field in the underlying table.
|
|
|
transform
|
A type of template used to convert XML data to other formats.
|
|
|
unbound
|
Not linked. An unbound control is not linked to a field in an underlying table; instead it might be used, for example, to calculate values from multiple fields. See also bound.
|
|
|
undocking
|
To drag a toolbar, task pane, or similar item so that it floats in the program window.
|
|
|
Universal Naming Convention (UNC)
|
The system of naming files among computers on a network so that a file on a given computer will have the same path when it is accessed from any of the other computers on the network. See also mapped network drive.
|
|
|
unmatched query
|
A select query that locates records in one table that do not have any related records in another table. This query can be created with the assistance of the Find Unmatched Query wizard.
|
|
|
update query
|
A query that changes the values in one or more fields of matched records in a table.
|
|
|
validation rules
|
A field property that ensures entries contain only the correct type, size, or range of data.
|
|
|
view
|
The display of information from a specific perspective. Each Access object has two or more views, such as Datasheet view and Design view.
|
|
|
wildcard character
|
A keyboard character that can be used to represent one or many characters in a search. The question mark (?) represents a single character, and the asterisk (*) represents one or more characters.
|
