Phu Xuan University Library
|
PXU E-LIB
Sign in
Relational Databases and Microsoft Access

External

Relational Databases and Microsoft Access

This text is a free introductory text that introduces MS Access and relational database design. The motivation is to support a second-year course on database systems which, to the student, is either a service course providing an introduction to database concepts, or, as a prerequisite for more advanced study in the field.

Computer ScienceEngineering
Author
Ron McFadyen
Publisher
University of Winnipeg
Source
LibreTexts
License
CC BY-NC-SA
Language
EN
Category
Information Technology
Read online Download PDF (open licence)
Contents· 59 sections
  1. 01: Relational Databases and MS Access
  2. 1.01: Relational Databases
  3. 1.02: Microsoft Access
  4. 02: Creating Tables
  5. 2.01: Creating Tables
  6. 2.02: Using Design View to Create Tables
  7. 03: Creating Forms
  8. 3.01: Using the Form Wizard
  9. 3.02: Modifying the Form
  10. 3.03: Advanced Forms
  11. 04: Microsoft Access Queries
  12. 4.01: Microsoft Access Queries
  13. 4.02: Simple Query
  14. 4.03: Projection Query
  15. 4.04: Selection Query
  16. 4.05: Sorting the Result
  17. 4.06: AND
  18. 4.07: OR
  19. 4.08: Joins
  20. 05: Relationships and the Relationships Tool
  21. 5.01: Relationships and the Relationships Tool
  22. 5.02: Integrity
  23. 5.03: Relationships
  24. 06: Microsoft Access Queries - Advanced
  25. 6.01: Logical Expressions
  26. 6.02: Query Operators
  27. 6.03: Query Properties
  28. 6.04: Totals Query
  29. 6.05: Parameter Query
  30. 6.06: Crosstab Query
  31. 6.07: Action Queries
  32. 6.08: Inner and Outer Joins
  33. 6.09: SQL Select Statement
  34. 6.10: SQL Union and Union All
  35. 07: Entity Relationship Modelling
  36. 7.01: Introduction
  37. 7.02: Entities
  38. 7.03: Attributes
  39. 7.04: Relationships
  40. 08: Mapping an ERD to a Relational Database
  41. 8.01: Mapping Rules
  42. 8.02: Examples
  43. 09: Data Definition Language (DDL)
  44. 9.01: Running DDL in MS Access
  45. 9.02: Example
  46. 10: Normalization
  47. 10.01: Normalization
  48. 10.02: Functional Dependencies
  49. 10.03: Normal Forms
  50. 10.04: First Normal Form (1NF)
  51. 10.05: Boyce-Codd Normal Form (BCNF)
  52. 10.06: Summary
  53. 11: Appendix A - Forms Involving Multiple Tables
  54. 11.01: Forms Involving Multiple Tables
  55. 12: Appendix B - Supertypes and Subtypes
  56. 12.01: Drawing Supertypes and Subtypes on the ERD
  57. 12.02: Supertypes, Subtypes, and Relationships
  58. 12.03: Supertypes, Subtypes, and Attributes
  59. 12.04: Mapping Supertypes and Subtypes to a Relational Database