A | B |
---|
Append
| To add on to the end of an object; for example, to add records to the end of an existing table.
|
AutoNumber Data type
| A data type the describes a unique sequential or random number assigned by Access as each record is entered and that is useful for data that has no distinct field that can be considered unique.
|
Best Fit
| An Access commmand that adjusts the width of a column to accommodate the column's longest entry.
|
Blank desktop Database
| A database that has no data and has no database tools- you must create the data and the tools as you need them.
|
Caption
| A property setting that displays a name for a field in a table, query, form, or report other than that listed as the field name.
|
Common Field
| A field in one or more tables that stores the same data.
|
Currency Data Type
| An Access data type that describes monetary values and numeric data that can be used in mathematical calculations involving data with one to four decimal places.
|
Data
| Facts about people, events, things, or ideas.
|
Data Source
| The table or tables from which a form, query, or report retrieves its data.
|
Data Type
| The characteristic that defines the kind of data that can be entered into a field, such as numbers, text, or dates.
|
Database
| An organized collection of facts about people, events, things, or ideas related to a specific topic or purpose.
|
Database Management System (DBMS)
| Database software that controls how related collections of data are stored, organized, retrieved, and secured; also known as a DBMS.
|
Database Template
| A preformatted database designed for a specific purpose.
|
Datasheet View
| The Access view that displays data organized in columns and rows similar to an Excel worksheet.
|
Design View
| An Access view that displays the detailed structure of a query, form, or report; for forms and reports, may be the view in which some tasks must be performed, and only the controls, and not the data, display in this view.
|
Destination Table
| The table to which you import or append data.
|
Field
| A single piece of information that is stored in every record and formatted as a column in a database table.
|
Field Properties
| Characteristics of a field that control how the field displays and how data can be entered in the field.
|
First Principle of Good Database Design
| A principle of good database design stating that data is organized in tables so that there is no redundant data.
|
Flat Database
| A simple database file that is not related or linked to any other collection of data.
|
Form
| An Access object you can use to enter new records into a table, edit or delete existing records in a table, or display existing records.
|
Form View
| The Access tool that creates a form with a single mouse click, which includes all of the fields from the underlying data source.
|
Import
| The process of coying data from another file, such as a Word table or an Excel workbook, into a separate file, such as an Access database.
|
Information
| Data that is organized in a useful manner.
|
Layout View
| The Access view in which you can make changes to a form or report while the object is running - the data from the underlying data source displays.
|
Link
| A connection to data in another file.
|
Multiple-Items Form
| A form that enables you to display or enter multiple records in a table.
|
Navigation Area
| An area at the bottom of the Access window that indicates the number of records in the table and contains controls with which you can navigate among the records.
|
Navigation Pane
| An area of the Access window that displays and organizes the names of the objects in a database; from here, you open objects for use.
|
Normalization
| The process of applying design rules and principles to ensure that your database performs as expected.
|
Object Window
| An area of the Access window that displays open objects, such as tables, forms, queries, or reports; by default, each object displays on its own tab.
|
Objects
| The basic parts of a database that you create to store your data and to work with your data; for example, tables, forms ,queries, and reports.
|
Populate
| The action of filling a database table with records.
|
Primary Key
| The field that uniquely identifies a record in a table; for example, a Student ID number at a college.
|
Query
| A database object that retrieves specific data from one or more database objects- either tables or other queries- and then, in a single datasheet, displays only the data you specify.
|
Record
| All of the categories of data pertaining to one person, place, thing, event, or idea, and which is formatted as a row in a database table.
|
Record Selector Bar
| The bar at the left edge of a record when it is displayed in a form, and which is used to select an entire record.
|
Record Selector Box
| The small box at the left of the record in Datasheet view that, when clicked, selects the entire record.
|
Redundant
| In a database, information that is repeated in a manner that indicates poor database design.
|
Relational Database
| A sophisticated type of database that has multiple collections of data within the file that are related to one another.
|
Report
| A database object that summarizes the fields and records from a table or query in a easy-to-read format suitable for printing.
|
Run
| The process in which Access searches the records in the table included in the query design, finds the records that match the specified criteria, and then diplays the records in a datasheet; only the fields that have been included niter query design displays.
|
Second Principle of Good Database Design
| A principle stating that appropriate database techniques are used to ensure the accuracy of data entered into a table.
|
Select Query
| A type of Access query that retrieves data from one or more tables or queries, displaying the selected data in the datasheet; also know as a simple select query.
|
Simple Select Query
| Another name for a select query.
|
Single-Record Form
| A form that enables you to display or enter one record at a time in a table.
|
Source File
| When importing a file, refers to the file being imported.
|
Structure
| In Access, the underlying design of table, including field names, data types, descriptions, and field properties.
|
Table
| The database objects that stores data organized in an arrangement of columns and rows, and which is the foundation of an Access database.
|
Tables and Related Views
| An arrangement in the Navigation Pane that groups object by the table to which they are related.
|
Truncated
| Refers to data that is cut off or shortened.
|
Wizard
| A feature in Microsoft Office that walks you step by step through a process.
|
Custom web app
| a database that you can publish and share with others over the Internet
|
DBMS
| an acronym for database management system
|
Export
| the process of copying data from one file into another file, such as an Access table into an Excel spreadsheet
|
Number data type
| an Access data type that describes numbers that might be used in calculations
|
Object tab
| in the object window, a tab that identifies the object and which enables you to make the open object active
|
Property Sheet
| a list of characteristics-- properties-- for fields or controls on a form or report in which you can make precise changes to each property associated with the field or control
|
Secure environment
| a system that uses controlled servers to ensure the security and privacy of email, to control the storage and use of information and to protect against the loss of cofidential data
|
Server
| a computer that provides services on a network such as an email server or a file server
|
SharePoint
| a Microsoft application used for setting up websites to share and manage documents
|
Short Text data type
| an Access data type that describes text, a combination of text and numbers, or numbers that are not used in calculations, such as a Postal Code
|