business access 9f

database

collection of information about a subject or purpose, organized in a way that people can retrieve information quickly

record

all information relating to an individual item or person in a database

fields

separate pieces of information within each record (name, city, address, etc.)

relational database

A database that contains (or can) multiple tables with relationships between them

short text / text

specific length of field

memo / long text

long fields that vary in content from record to record

date / time

to meet that specific type of data

yes / no

field only has 2 options

numeric / currency

calculating data

query

allows user to retrieve certain info

report

displays database information in a word processed docu. format, created by the database program

table

a database that contains formatting, styles, and sample text that you can use to create new databases

input mask

a pattern to follow for entering data in a field

file

a group of related records