(Original post by LucieJan3X)
So can anyone help me out and explain to me step by step what to do in the exam so i can get some marks. Please help a sister out xx.
Do you have your tables sorted, with all the data types, validations and screenshots done? If so, just follow what I've written below
(Original post by HypNose)
Hello everyone, does anyone remember the first two queries that we had to do? If so, what were they about?
I can help with the Queries
A query to display a list of two bedroom vacant properties from the cheapest rent to the most expensive rent.
a query that would allow a user to enter a property type and minimum number of bedrooms as parameters
Okay so in query design, you need to have tblProperty and put in the fields NumBedroom and MonthlyRent
For the criteria, put 2 for bedrooms. For Rent, put the (I forgot what it was called but there is a drop down box beneath the field that should provide three options) and click ascending.
That is the first query done.
Second one, you need tblProperty and tblPropertyType. Put on both fields of tblPropertyType. Put in PropertyID. Click E totals. Under the fields should be "Group by". Put PropertyID as " count"