1 / 35

Access Intro RDBMS

Access Intro RDBMS. Relational Database Management System. Getting Started. Start Access. New Blank Database. Default Start: Table Tools: Fields. Click to Add: Text, Number, Date, currency, etc. That was starting from nothing…. Lets’ open a small DB…. Open Photographers DB.

javen
Download Presentation

Access Intro RDBMS

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. Access Intro RDBMS Relational Database Management System

  2. Getting Started

  3. Start Access

  4. New Blank Database

  5. Default Start: Table Tools: Fields

  6. Click to Add: Text, Number, Date, currency, etc.

  7. That was starting from nothing…

  8. Lets’ open a small DB…

  9. Open Photographers DB

  10. Home Tab: Photographers Database

  11. Navigation Pane Home Tab: Photographers Database

  12. Let’s Check out the Ribbons

  13. Go Backstage Home Tab Ribbon

  14. Backstage View

  15. Go Back to Ribbon Tabs Backstage View

  16. Clipboard Records Text Formatting Find Sort and Filter Back to Home Tab

  17. Create Tab: “Grand Central” for objects

  18. Before next Ribbon let’s talk about Objects

  19. What are Objects?

  20. Objects are • Templates • Tables • Wizards • Forms • Reports • Macros Next: more on each object Create Tab

  21. Tables (Macros) Relationships (not an object) Queries 5. Macros Forms Close Relationship Tab Reports 1.Tables 2.Queries 3. Forms 4. Reports There are 5 Access Objects

  22. No data This will be Relevant When we Look At queries We are in Design View

  23. Datasheet View

  24. Design Tab

  25. Photographer's Table Property Sheet

  26. I will demo the rest of the objectswithout reference slidesDon’t expect full retention!Just get a feel for the program today.(Exit slides for now)

  27. Next Ribbon is…

  28. Data In and Out We will import our tables in this view External Data Tab Ribbon

  29. for our purposes, mostly used for getting to Relationships Database Tools Ribbon

  30. Tell me what you want to do (2016 only) Tell Me Button… not really a tab or Ribbon

  31. Tell me what you want to do dropdown Tell me

  32. Hide/Pin toggle Ribbon

  33. Hidden Ribbon

  34. Now we will open a Larger Database…

  35. Now we will open a Larger Database

More Related