Computer Information system problem: Microsoft Access

You must create an Access database called Brooklyn99RealEstate.

You must the create following tables (Users, Buyers, Seller, Property, Feature) that correspond to this database. Apply their corresponding data types for each attribute adjust appropriate field size for each data type and create the relationships between these tables, also define the primary keys and foreign keys for each table.

• Users table must contains the following the following attributes: UserID, UserType,

FirstName, LastName, City, State, DateOfBirth, Gender, CellPhoneNumber, EmailAddress Create a custom dropdowns for Gender and UserType

• Buyers table must contain the following attributes: UserID, PropertyType, PreferredCity, MaxAreaSize, MaxBudget
• Seller table contains the following the following attributes: UserID, PropertyID
• Property table must contain the following attributes(PropertyID, PropertyType, Address, City, State, Zipcode, ListingDate, NumberOfBedrooms, NumberOfBathRooms, Square_Feet, PricePerSquareFeet, Price )
• Features table must contain the following attributes(PropertyID, FeatureName, Description)

Create a form for each table (Must be done this order)

1. Seller Table create a form called Seller_Information_Form
2. User table form must be called Buyer_Seller_Information_Form
3. Buyer table create a form called Buyer_Information_Form

In addition apply a color scheme to the forms, change the font color, font family, adjust the width of all the form fields, add a date to each form and add a buttons to each form (Previous, Next, Last and First button optional is a search button)