| 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 |
