Search results

  1. W

    Access Login System - DCount using 2 Tables?

    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...
  2. W

    Select Query Multiple Criteria

    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...
  3. W

    Access Yes/No: IF record exists in another table then Yes, ELSE No

    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...
Top Bottom