1 / 14

Chapter 3

Chapter 3. Using Access to Implement a Relational Database . Learning Objectives. Understand the Access objects, including tables, queries, forms, reports, pages, and macros. Create, open and display tables based on the data model. Create forms to enter data into tables.

zavad
Télécharger la présentation

Chapter 3

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. Chapter 3 Using Access to Implement a Relational Database

  2. Learning Objectives • Understand the Access objects, including tables, queries, forms, reports, pages, and macros. • Create, open and display tables based on the data model. • Create forms to enter data into tables. • Establish relationships among tables.

  3. Access® • Is a Microsoft DBMS program that • Defines the database; • Provides for simplified data entry; • Manipulates, stores, and retrieves data; and • Produces reports from the data. • Microsoft Access (Access) is a relational database management system. • Access refers to the structures used to manage the data as objects.

  4. Types of Objects

  5. Tables • The most important object in a DBMS. • Data is stored in tables. • A table is analogous to a file that stores/collects data. • All the data in a relational database are contained in various tables.

  6. Queries • Allow the user to ask questions about the data stored in the database. • Can be used to locate and display a subset of the records of a table (called a “dynaset”). • Can be used to modify data by combining information from several tables into a single result, to perform calculations on fields, or to specify criteria for searching the data.

  7. Forms • Used to facilitate data entry. • Allow the user to see data from tables in another view, usually one record at a time. • Can be customized so that they are an exact copy of an existing paper form, making it easier to move from hard copy to soft copy. • In a fully automated setting, a form could be complete on-line at the time an event happens, greatly enhancing the simplicity and accuracy of data entry.

  8. Reports • Utilize data created from queries and from one or more tables to provide the user with meaningful information in a printed format. • Can be produced by sorting, grouping and summarizing data. • Can be used to produce documents such as invoices, purchase orders, sales summaries, and financial statements.

  9. Pages • Also known as data access pages • Creates a Web-based form with the benefit of being able to handle live data from the Internet or an intranet outside of the Access database.

  10. Marcos • Are an advanced Access object. • Perform specific, user-specified, automated tasks, such as opening a form, printing a report, or going to the last record. • Can also assist in the creation of turnkey applications that anyone can use, regardless his/her level of experience with Access.

  11. Modules • Are an even more advanced Access object than Macros. • Can be used to create and edit Visual Basic code or procedures for the database. • Are the containers used to organize the code.

  12. Creating and Opening a Database

  13. Create a New File

  14. Create a New File

More Related