click below
click below
Normal Size Small Size show me how
NP Access 1
Access 1
Term | Definition |
---|---|
Access | A database program you use to enter, organize, display, and retrieve related information. |
All Access Objects | The default category in the Navigation Pane; it lists all the objects in the database grouped by type (tables, queries, forms, reports, and so on). |
AutoNumber | An Access data type that automatically assigns a unique number to a record. |
Backstage view | The File tab of the ribbon, which provides access to file-level options and program settings. |
Common field | A field that appears in more than one table, allowing you to connect the records in the separate tables. |
Compacting | A process that rearranges the data and objects in a database to decrease its file size, thereby making more space available and enhancing the performance of the database. |
CREATE tab | A tab on the ribbon that provides options for creating various database objects, including tables, forms, and reports. |
Data type | The field property that determines what field values you can enter for the field and what other properties the field will have. |
Database | A collection of related tables stored in the same file. |
Datasheet | The display of a table’s contents in rows and columns, similar to a table or spreadsheet; each row is a separate record in the table, and each column contains the field values for one field in the table. |
Datasheet view | The Access view that shows a table’s contents as a datasheet in rows and columns. |
Field | A single characteristic or attribute of a person, place, object, event, or idea. |
FIELDS tab | A tab on the Ribbon that provides options for adding, removing, and formatting the fields in a table. |
Form | A database object you can create and customize to maintain, view, and print records in a database in different and useful ways. |
ID field | The default field Access creates to serve as the primary key field for all new tables. |
Layout view | The Access view in which you can make design changes to a form or report while it is displaying data so that you can immediately see the effects of changing the design. |
Navigation Pane | The area on the left of the Access program window that lists all the objects in the database and is the main control center for opening and working with database objects. |
Pencil symbol | The symbol that appears in a row selector to indicate that the record is being edited. |
Primary key | A field, or a collection of fields, whose values uniquely identify each record in a database table. |
Print Preview | The view of a report, form, or datasheet that shows you what the object will look like when printed. |
Query | A question you ask about the data stored in a database. In response, Access displays the specific records and fields that answer your question. |
Query Wizard | An Access tool that asks you a series of questions, and then creates a query based on your answers. |
Record | A complete set of field values for a specific person, place, object, event, or idea. |
Report | A formatted printout (or screen display) of the contents of one or more tables or queries in a database. |
Report tool | An Access tool that places all the fields from a table or query on a report. |
Ribbon | The main set of commands, located at the top of the Access window, organized into tabs and groups that you click to execute tasks. |
Short Text | An Access data type that allows field values containing letters, digits, and other characters. |
Star symbol | The symbol that appears in a row selector to indicate that the row is the next one available for a new record. |
Status bar | An area at the top of the Access window that provides information about the program, open file, or current task or selection; it also contains buttons and other controls for working with the file and its content. |
Table | A collection of fields that describes a person, place, object, event, or idea. |
Template | A predefined database that includes professionally designed tables, forms, reports, and other objects. |
Title bar | The area at the top of the Access window that displays the name of the open file and identifies the program. |