Steps to Create This Form in Microsoft Access
1. Create a Table
o Open Access → Create a Blank Database.
o Define fields (columns) such as:
▪ Consultation_Date (Date/Time)
▪ Patient_Name (Short Text)
▪ Consultation_Fee (Currency/Number)
▪ Fee_For_Equipment_Used (Currency/Number)
▪ Medication_Price (Currency/Number)
2. Create a Form
o Go to the Create tab → Click Form Design or Form Wizard.
o Add fields from your table to the form using the Add Existing Fields option.
3. Add Controls (Textboxes, Labels, Buttons)
o Use the Form Design Tools → Design tab to insert:
▪ Textboxes for data entry (linked to fields).
▪ Labels (for field names).
▪ Buttons (using the Command Button Wizard).
For example:
o Add a button for Search, Delete, Save, etc.
o In the wizard, choose the correct action (e.g., Record Operations → Delete
Record).
4. Customize the Layout
o Adjust fonts, alignment, and spacing.
o Add a title ("Lotus Flower Health Care Clinic").
o Insert a small calendar picker for Consultation_Date (Access does this
automatically if the field is Date/Time).
5. Navigation Buttons
o Use the Button Wizard to create Previous Record, Next Record, and New
Record.
6. Print Receipt Button (Optional)
o Create a report (for the receipt).
o Add a button that opens/prints the report for the current record.
How to Set This Up in Microsoft Access
You can enforce rules like this either in the Table Design or directly in the Form.
Option 1: Set Validation in the Table
1. Open the table in Design View.
2. Select the field Fee_For_Equipment_Used.
3. In the Field Properties (bottom panel):
o Validation Rule:
o >=200
o Validation Text:
o Fee_For_Equipment_Used must always be greater than or equal to P200
This way, the rule applies everywhere in the database (table, queries, forms, reports).
Option 2: Set Validation in the Form
1. Open the form in Design View.
2. Select the textbox for Fee_For_Equipment_Used.
3. In the Property Sheet (Data tab):
o Validation Rule:
o >=200
o Validation Text:
o Fee_For_Equipment_Used must always be greater than or equal to P200
This way, the rule applies only when using the form.
