click below
click below
Normal Size Small Size show me how
Vocabulary
Access Lesson 1
Question | Answer |
---|---|
Backstage View | Contains many of the commands that were on the File Menu in previous versions of Microsoft Access and enables you to create a new database, create a database from a template, open an existing database, view and edit database Properties |
Badges | Small square labels that contain key tips. |
Change Help Location Menu | A menu that enables you to choose between searching help topics online and help topics offline |
Database | A tool for collecting and organizing information |
Database Management System | A system for managing data that allows the user to store, retrieve and analyze information |
Datasheet | A visual representation of the data contained in a table or of the results returned by a query |
Data type | The kind of information a field contains----whether text, number, date/time, or some other type |
Dialog box Launcher | A small arrow in the lower-right corner of a group that you click to launch a dialog box |
Field | A column in a database table |
File Tab | A tab that displays the Backstage view and contains a menu of commands that you can use for the common tasks performed with your database files --- such as opening, saving, and printing. |
Form | A database object that simplifies the process of entering, editing, and displaying data. |
Groups | Collections of records separated visually and displayed with its introductory or summary information |
Keytip | Small letters and numbers that display on the ribbon when you press ALT; used for executing commands with the keyboard. |
Normal Forms | The standards and guidelines of database design that can be used to determine if a database is structured correctly |
Normalization | The process of applying rules to a database design to ensure that information is divided into the appropriate tables |
Objects | Database elements, such as tables, queries, forms, and reports |
Primary Key | The column in a database the uniquely identifies each row |
Query | A database object that enables stored data to be searched and retrieved |
Quick Access Toolbar | A toolbar at the top left of the screen that contains the commands that you use most often --- such as save, undo, redo, and print |
Record | A row in a database table |
Redundant Data | Duplicate information in a database |
Relational Database | A group of database tables that is connected or linked by a defined relationship that tiles the information together |
Report | A database object that presents information in a format that is easy to read and print |
Ribbon | A graphic band across the top of the screen that contains tabs and groups of commands |
Tab | An area of activity on the ribbon |
Table | The most basic database object: stores data in categories |