Search results

In essence, the structure would be something like Main table transactionID - PK transDate transRef customerID salesRepID invoiceID tblCustomer Customer Reference - PK Customer Name Customer Address Customer Phone tblSalesRep Sales Rep ID - PK Sales area Sales Rep Forename Sales Rep...

Hi there, It's been many years since I first created a database from scratch so I was looking for a quick refresher. I have one large transaction table with the following fields: Transaction Date Sales invoice number Transaction Details Product Type Customer Reference Customer Name Customer...

Ok thanks. I have attempted this simpler example here - maybe I've started with too hard a problem without having a basic grounding in the theory! Question A hospital requires a database to store admission information about patients. On arrival, each patient’s personal details (name, address...

Thanks for all the detailed responses. So here's my attempt at the original question Entities with attributes 1) Building - Building ID, Building Name 2) Meals - Meal ID, Meal Type 3) Flat - Flat ID, Room Type 4) Student - Student ID, Name, Building ID, Flat ID And the primary key would be...

It's a past paper question which Im trying to do as part of my revision - it will help me do the main exam if someone can talk me through this example :)

Hi there, I was looking for guidance with regards to this problem. Any help would be greatly appreciated :) Problem A new accommodation block has been built on a university campus close to university facilities. There are three main buildings, named Hufflepuff, Ravensclaw and Slytherin, each...

Hi there, I'm trying to get the sum of a field named "Net" and display it in on a report. i54. tinypic. com / 2nby5ux .jpg I realise that I have to put something like sum[(Net)] in the query but how and where do I put this? Any help would be excellent :) Thanks

thanks for the link i had a look and i cant find anything about this specific problem I have about displaying data that is over the entered value?

this is a query :)

Sorry what do you mean by that? I have very limited experience with Access :)

I have added this but when I run the query, nothing comes up? i52. tinypic. com /11rqcfo.jpg what have I done wrong? Sorry Im not too experienced with Access.

Hi there, I have been requested to complete a query where only records which are above the "net value" entered by the user are displayed. For example, if I entered £100 into the database, it would display records of £100 and over and not records that have a "net value" of £50. Screenshot...