Project Description:
An independent real estate firm that specializes in home sales needs to create a database in which to store its records. In the following project, you will open a database containing information about the properties the real estate firm has listed. You will work with a table in which to store agent information, and then sort the table. You create a relationship between two tables and enforce referential integrity. You also apply filters, sort a table, and save the results.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
I
Step |
Instructions |
Points Possible |
1 |
Start Access. Open the downloaded Access file named exploring_a01_grader_h2. |
0 |
2 |
Open the Agents table in Datasheet view, and add the following records letting Access assign the AgentID number: FirstName LastName Title Guillaume Picard Broker Keith Martin Agent Usa-chan Yang Agent Steven Dougherty Agent in Training Rajesh Khanna Agent in Training Juan Rosario President |
15 |
3 |
Sort the Agents table by the LastName field in ascending order. |
15 |
4 |
Apply a selection filter so that everyone with a title other than Agent in Training displays. Save the changes to the table design and close the Agents table. |
15 |
5 |
Open the Properties table in Design View. Change the data type
for the specified fields as follows: DateListed Date/Time ListPrice Currency SqFeet Number Beds Number Baths Number AgentID
Number |
20 |
6 |
Sort the records in the Properties table by the ListPrice field from largest to smallest. |
15 |
7 |
Use Filter by Form to create a filter that will identify all properties with a list price less than $300,000 with two bedrooms. Apply the filter and preview the filtered table. Close the table and save the changes. |
20 |
8 |
Close all database objects. Close the database and then exit Access. Submit the database as directed. |
0 |
Total Points |
100 |
Explain step 7 please
Whenever we required to “filter by many fields” we can use Filter by Form.
Here, fields such as ListPrice and Beds in Properties table needed to be filtered as per the given conditions whereas,
ListPrice < $300,000 and
Beds = 2
Go to Home tab in Access,
then near filter icon in top right side go to advanced command and from drop down list select “Filter by form”
Then similar to original datasheet a blank form will be created with fields names on top.
To specify the condition or criteria, data can be selected in box below the particular field.
To view properties with Beds=2,
select 2 from the drop down in the box below Beds field and click there.
Then after applying the condition click on “toggle filter” option near Filter icon.
Then you are able to see the records match that criteria.
In order to apply AND condition to that,
click on the “look for” near “or” tab in the bottom of form
“look for” tab is for creating AND conditions.
and enter <=300000 in box below ListPrice.
Then click toggle filter
Project Description: An independent real estate firm that specializes in home sales needs to create a database in which...
Start Access. Open the downloaded Access file named exploring_acap_grader_a1_Loans.accdb. Import the exploring_acap_grader_a1_Clients.xlsx Excel workbook into a table named Clients. While importing the data, make sure to select the option First Row Contains Column Headings, and select ClientID as the primary key field. After you have completed the import, open the Clients table in Design view. Change the ClientID field size to 6 and remove the @ symbol from the ClientID format property. Change the ZIP field size to 5. Change...
please use dia to draw the e-r diagram to create Entity - Relationship Diagrams then use MS access This project requires you to create a database design. Your design will be documented in a set of Entity-Relationship Crow's Foot diagrams using the representation as shown in the lecture materials. Draw a set of Entity-Relationship diagrams to model the following scenario. The Maggs Realty Company wants to track the Sales Offices that they have across all of Ontario They are interested...
For this set of Review Questions, we will create and use a database for the Wedgewood Pacific Corporation (WPC) that is similar to the Microsoft Access database we created and used in Chapters 1 and 2. Founded in 1957 in Seattle, Washington, WPC has grown into an internationally recognized organization. The company is located in two buildings. One building houses the Administration, Accounting, Finance, and Human Resources departments, and the second houses the Production, Marketing, and Information Systems departments. The...
EX16 XL _CH01_GRADER ML2 HW - Real Estate Sales Report 1.3 Project Description: You own a small real estate company in Indianapolis. You track the real estate properties you list for dlients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want to calculate the number of days that the houses were on the market and their sales percentage of...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database, the first question users should ask themselves is O A. How much information is going to be stored in this database? B. Where should this database be stored? O C. Who is going to use this database? O D. What questions should this database be able to answer? Question 2 of 38 When linking two tables in a relational database, a user will use...
EX16_XL_CH05_GRADER_CAP_AS - Travel Expenses 1.8 Project Description: <Project Description> Steps to Perform: Step Instructions Points Possible 1 Start Excel. Open the downloaded Excel file named exploring_e05_grader_a1_Expenses.xlsx. Save the workbook as exploring_e05_grader_a1_Expenses_LastFirst, replacing LastFirstwith your own name. 0 2 On the Subtotals worksheet, use the Sort dialog box to sort the data by Employee and further sort by Category, both in alphabetical order. 4 3 Use the Subtotals feature to insert subtotal rows by Employee to calculate the total expense by...
You are the systems manager for Blue City Movies Rentals and you have been asked to create a report on historical sales data. To complete your task you will combine and edit data from multiple sources using Excel’s Power add-ins, XML, and text functions.Instructions:For the purpose of grading the project you are required to perform the following tasks:StepInstructionsPoints Possible1Open e10c2MovieRentals.xlsx and save the workbook with the name e10c2MovieRentals_LastFirst.02Import the movie data from the delimited file e10c2Movies.txt and rename the new worksheet Inventory.Hint: On the Data tab,...
Solve it in access Group Project Note: All documents should be prepared and presented in a professional manner, with a cover page showing the group number and the names of group members. Nothing should be hand written hand drawn Michiana Car Rentals Database System Michiana Car Rentals, Inc., headquartered in South Bend, IN, wants to build a database system which would track information customer billing. Usually, a customer picks up a car and then returns after a period of time....
EA6-A2 Complete a Depreciation Schedule for Furniture Resellers In this exercise, you will create a depreciation schedule for Furniture Resellers as of 12/31/2016 using an Excel table. You will then sort, filter, and analyze the data in the table. These fixed assets, with associated data as of 12/31/2015, were acquired prior to the current year. Fixed Asset Date of Cost Salvage Useful Life Accumulated Acquisition Value (years) Depreciation Machinery 1/1/2007 $8,200 $700 10 $6,750 1/1/2009 $8,400 Garage Equipment $11,000 $200...
CO 4) In terms of data types and their uses, which one of the following is NOT correct? The TEXT data type can be used for Last Name. The Date/Time data type can be used for 10/31/2012. The Currency data type can be used for Account balance. The AutoNumber data type can be used for Customer Name. Flag this Question Question 125 pts (CO 5) All of the following describe form usage except a form user should have less input...