Access Tutorial 1
Order by
40 terms
Terms | Definitions |
|---|---|
 Microsoft Access 2010 | a computer program used to enter, maintain, and retrieve related data in a format known as a database. |
| Shutter Bar Open/ Close Button | allows you to close and open the Navigation Pane |
| Navigation Pane | the area that lists all the objects (tables, reports, and so on) in the database, and it is the main control center for opening and working with database objects |
| Datasheet view | shows the table's contents as a datasheet. |
| Click to add column | provides another way for you to add new fields to a table |
| Fields tab | provides options for adding, removing and formatting the fields in a table |
| Add & delete group | contains options for adding different types of fields, including Text and Currency, to a table |
| Access Window | the program window that appears when you create a new database or open an existing database. |
| datasheet | displays the table's contents in rows columns, similar to a table that you create in a Word document or an Excel spreadsheet. |
| ID column | created by Access as the primary key field for all new tables. |
| Database Management System | a software program that lets you create databases and then manipulate data in them. |
| Relational Database Management System | data is organized as a collection of tables. |
| template | a predesigned database that includes professionally designed tables, reports and other database objects that can make it quick and easy for you to create a database. |
| Data Type | determines what field values you can enter for the field. |
| Autonumber | automatically inserts a unique number in this field for every record. |
| field selector | selects that entire column aka column selector |
| pencil symbol | indicates that the record is being edited |
| star symbol | identifies the second row as the next row available for new record. |
| current record box | displays the number of the current record as well as the total number of records in the table. |
| field | a single characteristic or attribute of a person, place, object , event or idea. |
| table | is collection of fields that describes a person, place, object, event or idea. |
| field value | the specific value, or content, of a field |
| database | aka relational database, a collection of related tables. |
| primary key | a field, or a collection of fields, whose values uniquely identify each record in a table. |
| foreign key | a primary key from one table as a field in a second table to form a relationship between the two tables. |
| form | a database object you use to enter, edit, and view records in a database |
| Query Wizard | opens a dialog box with different types of wizards that guide you through the steps to create a query. |
| Simple Query Wizard | allows you to select records and fields quickly to display in the query results. |
| query | a question you ask about the data stored in a database. |
| Form tool | creates a form containing all the fields in the table (or query) on which you're basing the form. |
| Form Wizard | guides you through the process of creating a form. |
| Report Tool | places all the fields from a selected table (or query) on a report, making it the quickest way to create a report. |
| report | a formatted printout (or screen display) of the contents of one or more table (or queries) in a database. |
| Create tab | provides options for creating various database objects, including tables, forms, and reports. |
| navigational buttons | provide another way to move vertically through the records. |
| Layout View | make design changes to the form while it is displaying data. |
| Print Preview | shows exactly how the report will look when printed. |
| All access objects | lists all the database objects in the pane |
| Compacting | rearranges the data and objects in a database to decrease its file size. |
| Backing up | the process of making a copy of the database file to protect your database against loss or damage. |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.