1 / 23

Database Basics

Learn about databases, tables, records, fields, queries, forms, reports, and field types in Access 2007 with this helpful tutorial. Explore definitions, create relationships, and access templates to get started.

wbrantley
Download Presentation

Database Basics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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)

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

  10. Database

  11. Tables

  12. Views

  13. Table (Fields – design view)

  14. Table (Fields – datasheet view)

  15. Relationships

  16. Relationship Chart

  17. Form

  18. Form

  19. Report

  20. Report

  21. Query

  22. Create

More Related