Microsoft Access
Databases
Forms
Queries
Pages
Macros
Reports
Modules
Tables
Access depends heavily on tables
This is a way to input the data into a database
Data Types
Text
Letters and numbers that aren't used in calculation. Can be up to 255 characters
Memo
Text longer than 255 characters
Number
Numbers that are used in calculations
Date/Time
Currency
Monetary values that
Autonumber
A value that is automatically inputed into a record
Yes/No
Yes or No; True or False; On or Off
Attatchment
Files that do not have values, like images and a binary files
Hyperlink
Hyperlinks that when click can open an internet page, or a file.
OLE object
A Microsoft binary data that links and embeds data
Used to create records
and analyze data
This is an example table with names and information
Access can be used to record inputed information into databases that can be used to analyze the data and use it.
Primary Key
A field or combination of fields that make every row unique and avvoid duplicating data.
Used For
