This site is 100% ad supported. Please add an exception to adblock for this site.

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

Deck Info

15

permalink