click below
click below
Normal Size Small Size show me how
Access Vocabulary
Computer Concepts I
| Question | Answer |
|---|---|
| Ascending order | A sort order that arranges text alphabetically from A to Z, or numbers/figures from smallest to largest. |
| Database | Is an organized collection of facts about a particular subject |
| Database Management System | Provides functions to store, search, filter, query, and report on the data in a database. |
| Descending order | A sort order used to organize text alphabetically from Z to A or numbers/figures from largest to smallest |
| Design view | A layout used to create or modify the design of a new or existing database object |
| Field content | Specific data in a field |
| Fields | Items of data that make up each record, such as the Id, First, Last, Address. |
| Forms | A format used to display one record at a time; used to update records |
| Primary key | A field in each table that provides a unique code or number to identify each record |
| Queries | A structured way to search for records and retrieve data that meets certain criteria from one or more database tables in Access |
| Record | A complete set of related information about one person or item |
| Relational Database Management System | An Access tool for dividing data separate, subject based tables that you can bring together in reports as needed |
| Reports | In Access, displays information retrieved from the database |
| Sort | Feature that allows users to rearrange the order of words or numbers in a list, table, or records in a database |
| Table | Data organized in columns and rows; in Access, each row in table represents one record |