230 likes | 254 Views
Database Basics. Definitions. Database Relational database Table Record Field Primary key. Definitions continued. Query Form Report. Field types. Text (255 characters) Memo (64,000 characters) Number Date/Time Currency AutoNumber Yes/No OLE Object Hyperlink Attachment
E N D
Definitions • Database • Relational database • Table • Record • Field • Primary key
Definitions continued • Query • Form • Report
Field types • Text (255 characters) • Memo (64,000 characters) • Number • Date/Time • Currency • AutoNumber • Yes/No • OLE Object • Hyperlink • Attachment • Lookup Wizard
Tutorials http://office.microsoft.com/en-us/access-help/get-to-know-access-2007-RZ010274013.aspx Before next time Get to know Access 2007 Length: 45 min
Templates office.microsoft.com/en-us/templates/CT010142616.aspx?av=ZAC
Getting started (local) or office.microsoft.com/en-us/templates/CT010142616.aspx?av=ZAC (Access 2007)
Download • Download • Remember location (directory) • Extract (if in zip format) • Start MS Access 2007 • Open database