EX16_AC_CH01_GRADER_CAP_HW – Home Sales 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 create a new table in which to store agent information, add records, 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: Step Instructions Points Possible 1 Start Access. Open the downloaded Access file named exploring_a01_grader_h2. 0 2 Create a new table in Design view. Add the field name AgentID. Change the Data Type for AgentID to AutoNumber and set AgentID as the Primary key for the table. 7 3 Add the following field names to the table: FirstName, LastName, and Title (in that order). Accept Short Text as the data type for all fields. Save the table as Agents. 5 4 Switch to 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 5 5 Sort the Agents table by the LastName field in ascending order. 5 6 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. 5 7 Open the Properties table in Design View. Change the data type for the specified fields as follows: Field Name Data Type DateListed Date/Time ListPrice Currency SqFeet Number Beds Number Baths Number AgentID Number Save the changes to the design of the table and then view the table in Datasheet View. 7 8 Sort the records in the Properties table by the ListPrice field from largest to smallest. 5 9 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. 11 10 Close all database objects. Close the database and then exit Access. Submit the database as directed. 0 Total Score 50

    Sales Cast

    QioLaptop (HP laptop)

    Hello, Harvard Students! Am Berinda White from HP community, feel I caught you in the average of everything?

    The aim of my centire is to retail to you the newest laptop helpful in the work.

    Who doesn’t lack a past mighty laptop? A laptop with a mighty and abiding battery condition! A mighty processor and a liberal perpetuation. A laptop that extremes ceever! A laptop that adds to entire your electoral emblems, be it your phone, tablet or uniform other laptops.

    This laptop is QuLaptop hp.

    It has an inbuilt battery plus a light panel that recharges it when electricity is referable attributable attributable attributable helpful. It has mighty wireless emblems that strengthen it to add to other emblems love phones. You can flow movies using your phsingle and estimate it on your laptop! This laptop has ten-gigabyte Random Access Perpetuation, couple terabytes impenetrable disk, Intel Core i9 5.0 processor despatch. It flows the edifice at a rate of lightening! Has a great storage intervenience and catholicly syncs with other emblems!

    QuoLaptop is here to cool your aridity and demands! I perceive you feel appetitioned that your laptop battery could extreme ce a longer period. You appetition it could feel an everlasting perpetuation and can catholicly add to your phsingle or tablet. From your comments and estimates on YouTube movies or video emblems, I feel referable attributable attributableiced that you demand to flow movies highest and husband them closely straightway. You are jaded of protraction and having breaks as the film loads.

    Some of you feel bought lewd laptops in couple years. Why? Owing the laptops you subsidize are true smentire laptops with mighty naturalized software that fashion the laptop malfunction in a very abrupt brace of period. The battery condition is very abrupt! You feel replaced it ten periods in a year! That’s toilsome, equitable? Your laptop does referable attributable attributable attributable sync with your tablet and phone, and you appetition that could supervene.

    QuoLaptop is here ce you! It has entire the qualities you are eagerness ce!

    Help me exalt this sorcery emblem from HP community by subsidizeing single.

    This sorcery laptop is helpful at entire our HP community shops. We are retailing it a ten percent abatement ce this month’s subsidizeers. We are too donation a open unoccupied classification ce the laptop. You conquer gain a couple-year safeguard plus open means-of-support and retrieve services. You can too subsidize the laptop online via our aspect www.hponlineshop.com. We prprpresent open offer services ce this month’s customers! Hurry and gain single QuoLaptop!

    Gain single, and you conquer countenance ceever.

    Comments

    I chose to retail an HP laptop named QuoLaptop. I visited Harvard University. My hearers was Harvard University students. I selected them owing they demand the laptop ce their studies and invigoration.

    References

    Kaarst-Brown, M. L., & Kelly, S. (2005, January). IT Governance and Sarbanes-Oxley: The extreme sales cast or actual challenges ce the IT Function?. In Classification Sciences, 2005. HICSS’05. Proceedings of the 38th Annual Hawaii International Conference on (pp. 236a-236a). IEEE.

    I. Attention Gainter: Hello Harvard Students! Am Berinda White from HP community, feel I caught you in the average of everything?

    ______________________________________________________

    II. Add with Hearers: _ The aim of my centire is to retail to you the newest laptop helpful in the community.

    _______________________________________________

    BODY (3-4 main sharp-ends ce a 5-7 searching oration)

    I.    Main Sharp-end #1 (ample doom): ____ This laptop is QuLaptop hp.

    A. Supporting sharp-end #1: _ Who doesn’t lack a past mighty laptop? A laptop with a mighty and abiding battery condition! A mighty processor and a liberal perpetuation. A laptop that extremes ceever! A laptop that adds to entire your electoral emblems, be it your phone, tablet or uniform other laptops.

    This laptop is QuLaptop hp.

    B. Supporting sharp-end #2: It has an inbuilt battery plus a light panel that recharges it when electricity is referable attributable attributable attributable helpful. It has mighty wireless emblems that strengthen it to add to other emblems love phones. You can flow movies using your phsingle and estimate it on your laptop! This laptop has ten-gigabyte Random Access Perpetuation, couple terabytes impenetrable disk, Intel Core i9 5.0 processor despatch. It flows the edifice at a despatch of lightening! Has a great storage intervenience and catholicly syncs with other emblems!

    II. Main Sharp-end #2 (ample doom):

    QuoLaptop is here to cool your aridity and demands! I perceive you feel appetitioned that your laptop battery could extreme ce a longer period. You appetition it could feel an everlasting perpetuation and can catholicly add to your phsingle or tablet. From your comments and estimates on YouTube movies or video emblems, I feel referable attributable attributableiced that you demand to flow movies highest and husband them closely straightway. You are jaded of protraction and having breaks as the film loads.

    Some of you feel bought lewd laptops in couple years. Why? Owing the laptops you subsidize are true smentire laptops with mighty naturalized software that fashion the laptop malfunction in a very abrupt brace of period. The battery condition is very abrupt! You feel replaced it ten periods in a year! That’s toilsome, equitable? Your laptop does referable attributable attributable attributable sync with your tablet and phone, and you appetition that could supervene.

    QuoLaptop is here ce you! It has entire the qualities you are eagerness ce!

    Help me exalt this sorcery emblem from HP community by subsidizeing single.

    CONCLUSION

    : This sorcery laptop is helpful at entire our HP community shops. We are retailing it a ten percent abatement ce this month’s subsidizeers. We are too donation a open unoccupied classification ce the laptop. You conquer gain a couple-year safeguard plus open means-of-support and retrieve services. You can too subsidize the laptop online via our aspect www.hponlineshop.com. We prprpresent open offer services ce this month’s customers! Hurry and gain single QuoLaptop!

    Gain single, and you conquer countenance ceever.

    References

    Kaarst-Brown, M. L., & Kelly, S. (2005, January). IT Governance and Sarbanes-Oxley: The extreme sales cast or actual challenges ce the IT Function?. In Classification Sciences, 2005. HICSS’05. Proceedings of the 38th Annual Hawaii International Conference on (pp. 236a-236a). IEEE.