Search results

Thank you for your reply and insight. I completely agree that it makes no sense. But I'm battling with the issue that the Database Admin is outsourced, so therefore not a Staff member. As a result, I thought it would be simpler (and wiser) to have a separate Account table in which Staff...

Thank you for your reply and insight. I completely agree, but I came to realise that an outsourced Database Admin (who would need his own login details, who would also have administrative privileges of which I've not included in this example due to it being unnecessary) would not be a Staff...

Thank you for your reply. I think I'm building a Macro using VBA in the Macro Builder feature of Access. I unfortunately wrote the first code exactly as it was shown in the YouTube video (tweaked to my own table and attribute names) and it surprisingly did work (when the Staff Number was in...

Hello, I'm a college student currently studying a Database Design unit, so I apologise for being clueless in this post. I've watched a YouTube video on how to create a simple login system using an If DCount Macro. I have the following 2 (simplified) tables: Staff Staff_ID Staff_Number...

Thanks very much for your reply. I've successfully learned how to Group By and applied this to the Patient_ID, but by adding the Count variable in the Criteria box like this: Count(>2) Results in the error: Data type mismatch in criteria expression.. I've researched the error and it seems the...

Hello, I feel silly asking for help with such a simple concept, but everything I try doesn't seem to work! I'm a college student completing a Database Design unit, so I apologise for such a simple and potentially stupid question. I have a table called "Vaccinations": Vaccine_ID Patient_ID...

Thank you very much for your response! My intention was to have something like this: Vaccinations Patient_ID Vaccination Type Vaccination Date 1 Johnson & Johnson 10/11/2021 3 Pfizer 10/11/2021 Patient Tests Patient_ID Vaccinated Test Type Test Date 1 Yes Lateral Flow...

Hello, I am a student currently studying an IT course at college, of which includes a unit on Database Design. My project is to design and develop a relational database for a (fake) GP Surgery so they can record COVID-19 test results and vaccination records. I have five tables in this...