Question

For the Doctor's office system ERD, create an access database with at least 5 sample records in each table. At least four tables.

a. Add at least two queries, at least one using a criteria
b. Add at least three forms with a custom layout
c. Add at least two reports with a custom layout Submit a PDF file showing the screenshots of all the above access objects, including the relationship window. Include the names of group members who contributed to the work. Do not include team members who did not contribute.

Answer 1

To create a functional Access database for a Doctor's office system, one must build at least four interconnected tables with sample data, craft queries using criteria, design custom forms for data entry, and generate reports with custom layouts. Screenshots of all elements need to be compiled for submission.

Step-by-step explanation:

To create an Access database for a Doctor's office system with an Entity Relationship Diagram (ERD), one would need to design the database with at least four interconnected tables. For example, these tables could be Patients, Appointments, Doctors, and Medical Records. Each table should have at least five sample records. Additionally, the database should contain at least two queries, one of which utilizes criteria to filter data.

Further enhancing the usability of the database, at least three forms with custom layouts should be created to input and view data easily. Moreover, to help with the data presentation, at least two reports featuring custom layouts should be incorporated, showcasing summarized information. Screenshots of all elements, including the relationships window, should be assembled into a PDF file for submission. The project should highlight the contributions of team members while maintaining a clear record of individual contributions.