1 / 12

What is Microsoft Access?

What is Microsoft Access?. Pandora Rose Cowart Health Science Center IT Center – Training training@health.ufl.edu 352-273-5051. What is a Database?. A structured collection of related data An filing cabinet, an address book, a telephone directory, a timetable, etc.

sylvester-haynes
Download Presentation

What is 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. What is Microsoft Access? Pandora Rose Cowart Health Science Center IT Center – Training training@health.ufl.edu 352-273-5051

  2. What is a Database? • A structured collection of related data • An filing cabinet, an address book, a telephone directory, a timetable, etc. • In Access, your Database is your collection of related tables

  3. Database Options

  4. Why Use Access? • Familiar look and feel of Windows • Easy to start building simple databases • Can build sophisticated systems • It’s already on your computer • True relational database

  5. What is a Relational Database? • A relational database is a collection of tables from which data can be accessed in many different ways without having to reorganize the database tables. • That is, once relationships are created, tables can “talk” to each other. We can link (relate) the tables to find: • Which doctors have seen a patient • Which students are in a class • Which item is selling the most on Friday’s

  6. The Access Database Window The menu on the left hand side provide access to all database objects

  7. Data View/Design View Datasheet View Design View

  8. Introducing Tables • Database is a collection of TABLES • Tables store the data

  9. Introducing Queries • A means of asking questions (querying) of your data • Can look across a number of Tables and other Queries • Can perform Calculations and Combine fields

  10. Introducing Forms • A friendlier view of the database • Used for data input, menus, display and printing • Can perform Calculations and Combine fields

  11. Introducing Reports • Output of information in a printed report • Allows you to group and summarize data • Can perform Calculations and Combine fields • Cannot Edit Data • Can Make Labels

  12. Forms Reports Customer Queries Company Name Address City Telephone Contact Name Working Together Tables Employees Customers

More Related