Question

Create an MS Access Query with the following criterias below. I need the MS Access Query Design View screenshot with the proper codes.

Towards the end of month, the Apartment complex prepares a list of all the apartments that will be available for the next month. The list in general provides details about the address, air conditioning status, furniture status, etc. of all the apartments available.

ApartmentID

Address

AC_Status

Refrigerator _Status

Furniture_Status

________________________________________________

TenantID

Phone

E-Mail

Move_In_Date

Move_Out_Date

Answer 1

Solution:

Table Tools Design Databasel: Database (Access 2007) icrosoft Access (Product Activation Failed) Home CreateExternal Data Database Tools Insert Rows Delete Rows Modify Lookups Sheet View Primary Builder Test Validation Property Indexesrate Data Rename/Delete Relationships Object Key Rules Macros Macro Dependencies Views All Access Objects Search... Tables Tools Show/Hide Field, Record & Table Events Relationships apartment_details Field Name Data Type Description TenantID Phone E-mail Move In Date Move out Date ApartmentlD AutoNumber Number Text Date/Time Apartment Tenant Queries ate/Time Number apartment-details

Table Tools Databasel : Database (Access 2007) Microsoft Access (Product Activation Fail Home Create External Data Database Tools Design Insert Rows Delete Rows View Primary Builder Test Validation Property Indexesrate Data Rename/Delete Relationships Object Key Rules Modify Lookups Sheet Macros Macro Dependencies Tools Views All Access Objects Search... Tables Show/Hide Field, Record & Table Events Relationships << 幽Tenant LP apartment_details Apartment Field Name Data Type Description ApartmentID Address AC Status Refgirator status Furniture status Number Text Text Text Text Apartment Tenant Queries apartment details

Query lools Databasel : Database (Access 2007) - Microsoft Access (Product Activation Fail File Home CreateExternal Data Database Tools Design RowsProperty Shet Insert Rows Delete Rows Builder Insert Columns Delete Columns Return: Property Sheet Pass-Through Table Names View Run Select Make Append Update Crosstab Delete Show Totals Parameters Table Data Definition Table Results Query Type Query Setup Show/Hide All Access Objects << Tenant apartment details Apartment Search... ρ | |SELECT Apartment.ApartmentID, ApartmentAddress, Apartment.AC-Status, Apartment. Refgirator-status, Apartment. Furniture-status FROM Apartment where Apartment.ApartmentID= (Select max(Apartment!D) from Tenant where Move-out-date() Date0: Tables Apartment Tenant Queries apartment details

Query lools Databasel: Database (Access 2007) - Microsoft Access (Product Activation Fail File Home Create External Data Database Tools Design Insert Rows Insert Columns Delete RowsDelete Columns Builder Property Sheet Pass-Through Table Names View Run Select Make Append Update Crosstab Delete Show Totals Parameters Data Definition Table Return: All Table Results Query Type Query Setup Show/Hide - All Access Objects << Tenant apartment details Apartment Search... Apartment Tables Apartment ApartmentID Address AC Status Refgirator status Furniture status Tenant Queries apartment details Field: ApartmentID Table: Apartment Address AC Status Apartment Refgirator status Apartment Furniture status Apartment Apartment Sort Show Criteria: (Select max(Apartmen