1 / 7

MS Access

MS Access. Database – collection of related data Relational Database Management System (RDBMS) – software that uses related data stored in different tables Table is made up of rows (records) and columns (fields) E.g. 7 records 3 fields. Basic steps to create a database.

ccoker
Download Presentation

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. MS Access

  2. Database – collection of related data • Relational Database Management System (RDBMS) – software that uses related data stored in different tables • Table is made up of rows (records) and columns (fields) • E.g. 7 records 3 fields

  3. Basic steps to create a database • Design the tables – field name, data type, field properties (read pages 4-6) • Create relationships between tables: 1-to-1; 1-to-many; or many-to-many. Enforce referential integrity. • Add records in Datasheet view or create FORM for data entry

  4. Queries(pages 13-14) • retrieve records that match certain criteria • E.g. Use the online help for “Expressions that can be used in criteria” • Create calculated field:

  5. FORMS • A form can created based on table(s) or a query for data entry/modification • Edit a form in its design view. • May need to view the field list to add fields to existing form • Useful Tools

  6. REPORTS • A REPORT can created based on table(s) or a query for displaying information or printing • Edit a REPORT in its design view. • May need to view the field list to add fields to existing REPORT • Can add Grouping level(s) to a report. • Useful Tools Grouped by Team ID & Nickname

  7. Download Sports.mdb, Access_Ex.doc & ASSIGNMENT

More Related