need help Access 1 home work
Do you need academic writing help with your homework? Let us write your papers.
Order a Similar Paper
Order a Different Paper
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowHome 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 |
0 |
2 |
Create a new table in Design view. |
12 |
3 |
Add the following field names to the |
8 |
4 |
Switch to Datasheet view and add the Guillaume Keith Martin Agent Usa-chan Steven Dougherty Agent in Training Rajesh Khanna Agent in Training Juan Rosario President
|
8 |
5 |
Sort the Agents table by the |
4 |
6 |
Apply a selection filter so that |
8 |
7 |
Open the Properties table in Design 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 |
12 |
8 |
Sort the records in the Properties |
10 |
9 |
Click Relationships in the |
10 |
10 |
Drag the AgentID field from the |
14 |
11 |
Open the Properties table. Use |
14 |
12 |
Close all database objects. Close |
0 |
Total Points |
100 |