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 |