Access Database Terms
MS Access Database Terminology
Terms
undefined, object
copy deck
- Flat-File Database
- database with only one table
- DBMS
- Database Management System
- Mask
- validate data as it is entered and thus ensures the data is in the correct format.
- Form
- let you view and enter data for one record at a time
- Datasheet
- you see all records in one view.
- AutoNumber Field
- Automatically stores a numeric value that is one greater than that in the last record added. AutoNumber fields will automatically contain uniqu.e values
- Database Management System is:
- software tool that lets users add, view, and work with the data in a database
- Records
- collections of fields relating to an entity
- Relational Database
- database where each table is related to at least
- Report
- printed form of data from database
- Fields
- store various pieces of data related to a single entity
- Tables
- are collections of related records
- Query
- used to retrieve specific information from a database
- Database
- repository for collections of related data or facts. Examples, phone books, library catalog, address book
- Primary Key
- a field which is unique to each record