1 / 31

Relational Databases (MS Access)

Relational Databases (MS Access). What is database?. Database: A collection of data and information describing items of interest to an organization.

Download Presentation

Relational Databases (MS 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. Relational Databases(MS Access)

  2. What is database? • Database: A collection of data and information describing items of interest to an organization. • Database Management System (DBMS): A program that makes it possible for users to manage the data in a database in order to increase accessibility and productivity.

  3. What is a relational database? • Relational Database: A database in which the data are structured in a table format consisting of rows and columns. • Relation/File: The table in a database that describes an entity. • Tuples: The rows of a relation. Also called records. • Fields: The column of a relation. Also called attributes.

  4. What is a relational database?

  5. What is a relational database?

  6. What is a relational database? • The power of a relational database is twofold: 1) information is managed in separate tables to make maintenance easier, 2) data can be combined by relating different tables.

  7. Microsoft Access • A Microsoft Access database is made up of several components including: • Tables • Forms • Queries • Reports

  8. The Main Access Window • When you open Microsoft Access, many items you see are standard in most Microsoft software programs like Word, Excel, and PowerPoint.

  9. What is a Table? • The columns and rows in an Access table resemble an Excel spreadsheet.

  10. What is a Query? • A query lets you find and retrieve information from one or more tables based on a set of search conditions you define. • Queries can be created using a wizard or developed from scratch in the Query Design view.

  11. What is a Query?

  12. What is a Form? • An online form can be created to view, input or change information in one or more tables. • Forms can retrieve data from one or more tables, and display the output on the screen.

  13. What is a Form?

  14. What is a Report? • A report is an effective way to analyze and present data in a printed format using a specific layout. • You have control over the size and appearance of information printed on the report, similar to formatting you perform in a Microsoft Word document.

  15. What is a Report?

  16. Datasheet basics

  17. Field Properties • Table consists of the fields: Last Name, First Name, Phone, Address, City, State, and Zip. • Each field has unique properties. Some contain characters. Others contain numbers. • These Field Properties are defined when the table is created.

  18. Field Properties

  19. Primary Keys • Every table in Microsoft Access must have at least one field that uniquely identifies each record in the table. This field is known as a primary key. • This primary key essentially opens the door to the table and allows you to retrieve information from the table. • The primary key is the mechanism by which you relate different tables and combine information for viewing (query) or printing (report).

  20. Primary Keys

  21. Creating a New Database • Choose File > New from the menu bar.

  22. Creating a New Database

  23. Creating a New Database

  24. Creating a New Tables

  25. Creating a New Tables

  26. Creating a New Tables

  27. Creating a New Tables

  28. Creating a New Tables

  29. Creating a New Tables

  30. Editing and Deleting Table Records

More Related