Database Basics

1. Database Basics

2. Definitions • Database • Relational database • Table • Record • Field • Primary key

3. Definitions continued • Query • Form • Report

4. Field types • Text (255 characters) • Memo (64,000 characters) • Number • Date/Time • Currency • AutoNumber • Yes/No • OLE Object • Hyperlink • Attachment • Lookup Wizard

5. 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

6. Templates office.microsoft.com/en-us/templates/CT010142616.aspx?av=ZAC

7. MS Access 2007 Exercise

8. Getting started (local) or office.microsoft.com/en-us/templates/CT010142616.aspx?av=ZAC (Access 2007)

10. Download • Download • Remember location (directory) • Extract (if in zip format) • Start MS Access 2007 • Open database

11. Database

12. Tables

13. Views

14. Table (Fields – design view)

15. Table (Fields – datasheet view)

16. Relationships

17. Relationship Chart

18. Form

19. Form

20. Report

21. Report

22. Query

23. Create