1 / 35

Getting Started with Microsoft Access: Introduction to RDBMS and Database Objects

This guide introduces the basics of Microsoft Access, a Relational Database Management System (RDBMS). You'll learn how to start a new blank database and explore essential features, including adding fields like text, number, date, and currency. We will examine the Photographers database to navigate objects such as tables, forms, and reports. You will get an overview of the ribbons and their tools, which help in managing data. This session is designed to familiarize users with the program and its functionalities without overwhelming detail.

javen
Download Presentation

Getting Started with Microsoft Access: Introduction to RDBMS and Database Objects

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