How could I implement an appopintment system into my patient database so that I can see what appointments I have coming up and with which patient, and also be able to reflect the appointments that the patients have attended for within thier record.
The simplest method is to create a "Schedule" table, with fields for the Date of Appointment, Time of Appointment and Patient ID (and Doctor ID if you have more than one doctor). You can then use filtered portals to display the schedule for a date, patients, doctors, etc. Just don't allow any of the records to be deleted. That way you can track missed appointments, etc.