click below
click below
Normal Size Small Size show me how
Access
CH 1: Introduction to Access
Term | Definition |
---|---|
Access | A database management system included in the Microsoft Office 2013 Professional suite. |
Ascending | A sort that lists text data in alphabetical order or a numeric list in lower to highest order. |
AutoNumber | A number data type that is generated by Access and is incremented each time a record is added. |
Back Up Database | An Access utility that creates a duplicate copy of the database. |
Comparison operator | An operator used to evaluate the relationship between two quantities. |
Criterion (criteria, pl) | A number, text phrase, or an expression used to select records. |
Custom Web app | A database that can be built, used, and shared with others through the use of a host server (e.g., SharePoint or Office 365). |
Database | A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported. |
Database management system (DBMS) | A software system that provides the tools needed to create, maintain, and use a database. |
Datasheet view | A view that enables you to add, edit, and delete the records of a table. |
Descending | A sort that lists text data in reverse alphabetical order or a numeric list in highest to lowest order. |
Design view | A view that enables you to create tables, add and delete fields, and modify field properties; or to change advances design settings not seen in Layout view, such as a background image. |
Enforce referential integrity | A relationship option that ensures that data cannot be entered into a related table unless it first exists in a primary table. |
Field | The smallest data element in a table, such as first name, last name, address, or phone number. |
Field property | A characteristic of a field that determines how a field looks and behaves. |
Field selector | The column heading of a datasheet used to select a column. |
Filter | Displays a subset of records based on a specified criterion. |
Filter by Form | A filtering method that displays records based on multiple criteria. |
Filter by Selection | A filtering method that displays only records that match selected criteria. |
Foreign key | A field in one table that is also a primary key of another table. |
Form | A database object that is used to add, edit, or delete table data. |
Join line | A line used to create a relationship between two tables using a common field. |
Macro | A series of actions that can be programmed to automate tasks. |
Module | An object that is written using Visual Basic for Applications (VBA) and adds functionality to a database. |
Navigation bar | Bar located at the bottom of a table, query, or form that is used to move through records. |
Navigation Pane | An interface element that organizes and lists database objects. |
Normalization | The formal process of deciding which fields should be grouped together into which tables. |
Object | A main component that is created and used to make a database function. |
Primary key | The field (or combination of fields) that uniquely identifies each record in a table. |
Query | Enables you to ask questions about the data stored in a database and then provides the answers to the questions by providing subsets or summaries of data. |
Record | A group of related fields representing one entity, such as data for one person, place, event, or concept. |
Record selector | A small box at the beginning of a row used to select a record. |
Relational database management system (RDBMS) | A database management system that uses the relational model to manage groups of data (tables) and rules (relationships) between tables. |
Relationship | A connection between two tables using a common field. |
Report | An object that contains professional-looking formatted information from underlying tables or queries. |
Sort | The process of listing records or text in a specific sequence, such as alphabetically by last name. |
Table | An object used to store and organize data in a series of records (rows) with each record made up of a number of fields (columns) and is the foundation of every database. |
Template | A predesigned file that incorporates formatting elements, such as theme and layouts, and may include content that can be modified. |
Which sequence represents the hierarchy of terms, from smallest to largest? | Field, record, table, database |
You edit several records in an Access table. When should you execute the Save command? | Records are saved automatically; the save command is not required. |
Which of the following is not true of an Access database? | Every table in a database contains the same number of records as every other table. |
Which of the following is true regarding the record selector box? | An orange border surrounds the record selector box and the active record. |
Which of the following will be accepted as valid during data entry? | Entering numbers into a text field. |
You have finished an Access assignment and wish to turn it in to your instructor for evaluation. As you prepare to transfer the file, you discover that it has grown more than double in size. You should: | Compact and repair the database before sending it to your instructor. |
Which of the following conditions is available through Filter by Selection? | Equals condition. |
An Employees table is open in Datasheet view. You want to sort the names alphabetically by last name and then by first name (i.e., Smith, Andrew). To do this, you must: | First sort ascending on first name and then on last name. |
Which of the following is not true when creating relationships between tables? | The common fields used to create a relationship must both be primary keys. |
All of the following statements are true about creating a database except: | The objects provided in a template cannot be modified. |
View that enables you to add, edit, and delete the records of a table. | Datasheet view |
An Access object that enables you to enter, modify or delete table data. | Form |
An Access utility that reduces the size of the database and can repair a corrupt database. | Com[act and Repair. |
A main component that is created and used to make a database function. | Object |
A filtering method that displays records based on multiple criteria. | Filter by Form |
A system that uses the relational model to manage groups of data (tables) and rules (relationships) between tables. | Relational database management system (RDBMS) |
A database that can be built, used, and shared with others through the use of a host server. | Custom Web app |
An object that contains professional-looking formatted information from underlying tables or quires. | Report |
An object used to store data, and the foundation of every database. | Table |
An Access utility that creates a duplicate copy of the database. | Back Up Database. |
A predefined database that includes professionally designed tables, forms, reports, and other objects. | Template |
A filtering method that displays only records that match selected criteria. | Filter by Selection |
A connection between two tables using a common field. | Relationship |
A method of listing records in a specific sequence. | Sort |
View that enables you to create tables, add and delete fields, and modify field properties. | Design view |
An Access interface element that organizes and lists the database objects in a database. | Navigation Pane |
A question you ask that can help you find and retrieve table data meeting conditions you specify. | Query |
The smallest data element in a table, such as first name, last name, address, or phone number. | Field |
Complete set of all the fields (data elements) about one person, place, event, or concept. | Record |
The field (or combination of fields) that uniquely identifies each record in a table. | Primary key |
Access speed | measures the time it takes for the storage device to make the file content available to use. |
Compact and Repair | reduces the size of the database |
Backup | creates a duplicate copy of the database |