Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
CGS 2100 ACCESS
Tutorial 1: Creating a Database key terms
| Term | Definition |
|---|---|
| Access | A database program you use to enter, organize, display, and retrieve related information. (AC 1) |
| Access window | The program window that appears when you start the Access program to create a new database or open an existing database. (AC 3) |
| Add & Delete group | A group on the Fields tab in Table Datasheet view that contains options for adding different types of fields to a table. (AC 2) |
| 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). (AC 38) |
| AutoNumber | An Access data type that automatically assigns a unique number to a record. (AC 11) |
| backing up | Making a copy of a database file to protect your database against loss or damage. (AC 40) |
| Click to Add column | In Datasheet view for a table, the datasheet column you can use to create a new field in the table. (AC 2) |
| column selector | In a datasheet, the column heading (also called the field selector) that you click to select the entire column. (AC 14) |
| common field | A field that appears in more than one table, allowing you to connect the records in the separate tables. (AC 4) |
| compacting | A process that 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. (AC 38) |
| Create tab | A tab on the Ribbon that provides options for creating various database objects, including tables, forms, and reports. (AC 23) |
| Current Record box | The box that appears at the bottom of a datasheet or form and that indicates the current record and total number of records displayed. (AC 20) |
| data type | The field property that determines what field values you can enter for the field and what other properties the field will have. (AC 11) |
| database, or relational database | A collection of related tables stored in the same file. (AC 4) |
| database management system (DBMS) | A software program that lets you create databases and then manipulate data in them. (AC 6) |
| 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. (AC 3) |
| datasheet selector | A box in the upper-left corner of a datasheet that lets you select the entire datasheet. (AC 25) |
| Datasheet view (for a table) | The Access view that shows a table’s contents as a datasheet in rows and columns. (AC 2) |
| field | A single characteristic or attribute of a person, place, object, event, or idea. (AC 4) |
| field selector | In a datasheet, the column heading (also called the column selector)that you click to select the entire column. (AC 14) |
| field value | The specific value, or content, of a field in a record. (AC 4) |
| Fields tab | A tab on the Ribbon that provides options for adding, removing, and formatting the fields in a table. (AC 2) |
| foreign key | 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. (AC 5) |
| form | A database object you can create and customize to maintain, view, and print records in a database in different and useful ways. (AC 22) |
| Form tool | An Access tool that creates a form containing all the fields in the table or query on which the form is based. (AC 22) |
| Form Wizard | An Access tool that asks you a series of questions, and then creates a form based on your answers. (AC 22) |
| ID column | The default field Access creates to serve as the primary key field for all new tables. (AC 2) |
| 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. (AC 31) |
| Microsoft Access 2010 | A database program you use to enter, organize, display, and retrieve related information. (AC 1) |
| navigation buttons | A set of buttons found at the bottom of a table datasheet or form that you use to move through the records in the table. (AC 26) |
| 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. (AC 2) |
| pencil symbol | The symbol that appears in a row selector to indicate that the record is being edited. (AC 15) |
| primary key | A field, or a collection of fields, whose values uniquely identify each record in a database table. (AC 5) |
| Print Preview | The view of a report, form, or datasheet that shows you what the object will look like when printed. (AC 35) |
| 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. (AC 22) |
| Query Wizard | An Access tool that asks you a series of questions, and then creates a query based on your answers. (AC 22) |
| record | A complete set of field values for a specific person, place, object, event, or idea. (AC 4) |
| record selector | In a datasheet, the small square at the beginning of a row (also called the row selector) that you click to select the entire row. (AC 14) |
| relational database, or database | A collection of related tables stored in the same file. (AC 4) |
| relational database management system | A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field. (AC 6) |
| report | A formatted printout (or screen display) of the contents of one or more tables or queries in a database. (AC 23) |
| Report tool | An Access tool that places all the fields from a table or query on a report. (AC 23) |
| Report Wizard | An Access tool that asks you a series of questions, and then creates a report based on your answers. (AC 23) |
| row selector | In a datasheet, the small square at the beginning of a row (also called the record selector) that you click to select the entire row. (AC 14) |
| Shutter Bar Open/Close Button | The button on the Navigation Pane that you click to open and close the pane. (AC 2) |
| Simple Query Wizard | An Access wizard that lets you quickly select the records and fields to display in a query datasheet. (AC 22) |
| star symbol | The symbol that appears in a row selector to indicate that the row is the next one available for a new record. (AC 15) |
| table | A collection of fields that describe a person, place, object, event, or idea. (AC 4) |
| template | A predefined database that includes professionally designed tables, forms, reports, and other objects. (AC 7) |
| Text | An Access data type that allows field values containing letters, digits, and other characters. (AC 11) |
Created by:
Bnoya001