ms-access-sample-database-implementation-1

Phase 3 – MS Access Sample Database Implementation

-A document with transaction Processing Needs: categorized with brief description (for forms, reports, and queries) from phase 1. This will be used as a guide to grade your Prototype using Access. This file needs to be typed.

-A zipped .accdb file including Microsoft Access Prototype including

• Schema Definition – set up all tables defined in the phase 2
• Field and Table Validation Rules – set up each attribute field and its validation rules in the phase 1 and 2 intermediate documents. (Design View->General>Validation Rule)
• Relationships – set relationships among tables, including referential integrities (Database Tools->Relationship)
• Test Data – populate each table with at least 4 tuples to test Forms, Reports, Queries (Each query should show at least one tuple in it.)
• Forms – create at least 2 forms listed in the previous phase document
• Reports – create at least 2 reports listed in the previous phase document

Queries – create at least 3 queries listed in the previous phase document

——————————————————————————————-

Example: company.accdb

.accdb file implemented in Microsoft Access for the COMPANY enterprise from the Fundamentals of Database Systems (sample project).

To view its tables, go to:
Create->Navigation->pick one such as “Vertical Tabs, Left”, then click on “show all tables”.