farrah-head
Uploaded by
11 SLIDES
295 VUES
140LIKES

Microsoft Access

DESCRIPTION

Dive into the fundamentals of Microsoft Access with our beginner-friendly class. This course, led by experienced instructors Allyson Mower, Alice Weber, and Joan Gregory, will equip you with the skills needed to effectively use MS Access for database creation. You'll learn when and how to use MS Access, gain insights into toolbars and views, and practice data entry and editing. Additionally, explore templates, wizards, and basic queries to maintain data integrity. Transform your data management skills in just a few sessions!

1 / 11

Télécharger la présentation

Microsoft Access

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. Microsoft Access The Basics

  2. The Instructors • Allyson Mower, Digital Initiatives, 581-5263, amower@lib.med.utah.edu • Alice Weber, Collection Development, 587-9247, aweber@lib.med.utah.edu • Joan Gregory, Technical Services, 581-5269, joang@lib.med.utah.edu

  3. Your Expectations/Experience?

  4. Class Objectives • To learn when to use MS Access • To learn how to use MS Access • Toolbars • Views • Data entry and editing • To create usable databases of your own • Using templates and wizards • Using basic queries and reports

  5. Definitions • MS Access - software used for creating databases • Quickly • Accurately • Using wizards and templates developed to maintain the integrity of your data • Data are just information • Database • Collection of data • Related to a particular topic or project

  6. Data Integrity • Data must be accurate. • Data are RELATED to other data in your database (e.g., library patron is related to the book(s) that s/he has checked out). • Maintaining the INTEGRITY of the relationship between different pieces of data is very important. • Example of compromised integrity: sending an overdue notice to the wrong library patron

  7. MS Access vs. MS Excel • MS Excel • spreadsheet • flat database • all information has a one-to-one relationship • MS Access • like multiple spreadsheets that are connected to one another • one-to-many relationships • many-to-many relationships

  8. Examples • Printed Phone Directory (White Pages) • Flat database: One-to-one relationships • Library Catalog • Relational database: Many-to-many relationships • Library patrons check out many books. • Books are checked out by many patrons. • University Class Schedule • Students have many professors. • Professors have many students. • Classes can be held in many classrooms.

  9. MS Access vs. MS Excel • The choice is simple: • IF you have only one-to-one relationships, you need to use MS Excel. • IF you have one-to-many or many-to-many relationships, you need to use MS Access.

  10. Questions

  11. Now for the Hands-On Practice! MS Access Tutorial

More Related