Access assignment

Database Project

Scenario 5
Dundrum Estate Agent is a busy estate agent specialising in residential market. As the business grows faster staff is finding it difficult to retrieve informationquickly from the paper filling system. You are required to create a database to keep track of property that they have to offer.

1. - Field Layout
Field Name | Data Type | Format | Additionalinformation |
Property Number | Text | 3 | Primary Key |
Client First Name | Text | 10 | |
Client Surname | Text | 15 | |
Address | Text | 255 | |
Client Contact Number | Text | 12 | |
Price| Currency | 8 bytes | |
Property Type | Text | 18 | Index (restrict data entry) |
Number of Bedrooms | Number | Single | |
Number of Bathrooms | Number | Single | |
Under Negotiation |Yes/No | 1 byte | |

2. – Records Table

3. –Data Capture Form

4. – Queries
Query Name | Houses for Sale |
Purpose of Query | Find Houses That are for Sale |
Fields in Query | PropertyNumber, Property Type, Address, Price, Number of Bedrooms and Number of Bathrooms |
Query Conditions | “Not Apartment” under the Type of Property |
Sort | Ascending Order of Price |

Query Name |Apartments For sale |
Purpose of Query | Find Apartments For Sale |
Fields in Query | Property Number, Property Type, Address, Price, Number of Bedrooms and Number of Bathrooms |
Query Conditions| “Apartment” under the Type of Property |
Sort | Ascending order of Price |

Query Name | Detached Houses With More Than 2 Bedrooms |
Purpose of Query | Find Detached Houses with more than 2bedrooms |
Fields in Query | Property Number, Property Type, Address, Number of Bedrooms and Number of Bathrooms |
Query Conditions | “Detached House” Under Property Type>2 Under Number OfBedrooms |
Sort | Descending order of Number of Bedrooms |

Query Name | 2 Bedrooms Apartments With More than One Bathroom |
Purpose of Query | Find 2 bedroom apartments that have more than one...