MIS 180 SIMNET ASSIGNMENTS
fiendin
Access 2013 Chapter 1 Creating a Database and Tables Last Updated: 2/27/15 Page 1
USING MICROSOFT ACCESS 2013 Improve It Project 1-7
Improve It Project 1-7 Placer Hills Real Estate (PHRE) is a real estate company with regional offices throughout central California. Kelsey Kroll, one of the managers, had begun building a database. The database has one table that contains information about the real estate properties currently listed for sale. You add one field into the table, edit field properties, enter data into records, modify the datasheet layout, and sort and filter the data in the table. This project has been modified for use in SIMnet®.
Skills Covered in This Project
Open a database.
Use the Navigation pane.
Edit the default primary key.
Add a new field into a table.
Edit properties in Datasheet view.
Save a table.
Enter records.
Change the datasheet layout.
Sort data in a table.
Filter data in a table.
1. Open the PlacerHills-01 database start file. a. Enable content in the security warning.
b. The file will be renamed automatically to include your name. Change the project file name if
directed to do so by your instructor.
2. Open the Listings table in Datasheet view.
3. Edit the field properties of the Listings table
using the information in the nearby table.
For several of the fields, you will see a Some
data may be lost warning message when you
change the field size. Because the new field
sizes are sufficient for the existing data, click the
Yes button to continue.
4. Save the table after updating the properties.
5. Add a new field to the left of the Agent field.
6. Edit the field properties using the following
information:
a. Field Name: Construction
b. Data Type: Short Text
c. Size: 5
7. Save the table after updating the properties.
Step 1
Download start file
Access 2013 Chapter 1 Creating a Database and Tables Last Updated: 2/27/15 Page 2
USING MICROSOFT ACCESS 2013 Improve It Project 1-7
8. Enter the data values shown in the nearby table into the new
Construction field.
9. Change the layout of the Listings table.
a. Change the Font Size to 12 pt.
b. Select the entire datasheet and use AutoFit to adjust all
the fields to their correct size. Remember that if the width
of the Access window was not wide enough, some of the
columns may still be too small. You can adjust the width of
those columns individually.
c. Center-align the SqFt, Beds, Baths, Built, and
Construction fields.
d. Change the gridline color to Green 5 (seventh column,
sixth row in the Standard Colors category).
e. Set the row height of the table to 16.
f. Save the changes to the layout.
10. Add the following database properties and save the changes:
a. Company: PHRE
b. Comments: Listings table updated [enter today’s date]
11. Sort the Listings table in descending order by the List Price field.
ListingID 10024 should be at the top of the datasheet and
ListingID 10053 should be at the bottom of the datasheet.
12. Remove the sort criteria.
13. Filter the Listings table to find the listings of homes that are at
least 2000 square feet, have 3 or 4 bathrooms, and are brick
construction.
14. Sort the filtered results in ascending order by the List Price field.
Your datasheet should be similar to the one shown in
Figure 1-110.
15. Remove the sort criteria.
16. Clear all the filters. The datasheet updates to show all
the records.
17. Close the Listings table.
18. Do not save any of the changes as a result of sorting or filtering
the table.
19. Close the database.
20. Upload and save your file.
21. Submit project for grading. Step 3
Grade my Project
Step 2
Upload & Save