Explore BrainMass
Share

Real Estate Microsoft Database

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

I need help. Please help

1. Create a Client/Property database using Microsoft Access.
a. Open the Microft Access software program
b. After the Microsoft Access Window opens, select Blank Access Database, then click okay
c. The file New Database window opens, then type the word Client as the name for this file where the cursor is blinking, then click the create bottom.
d. Your Client: Database window opens, then type the word Client as the name for this file where the cursor is blinking, then click the create bottom.
e. Table 1 will appear with 3 columns titled, "Field Name" and "Data type" and "Description." The Field Name column heading is okay so you don't change the name. The Data Type means you need to specify whether it is text, number, data, or other type of information, and a description is used to set the criteria of the field name area cannpt have more than 50 characters, or you cna create your own setting, which may be 25 characters or less. In this case, you would change the 5o to 25 in the Foeld Size category. As you gain greater understanding of what the Access program can do, you will start to get creative in the descrition column.
f. Enter the date in each column and press the tab key after each entry to move your cursor to the next column. A same is shown below under each table heading.
Field Name

Name of Property (tab)
Kind of Property (tab)
Account ID# (tab)
Address (tab)
City property is in (tab)

Data Type
Text (tab)
Text (tab)
Text (tab)
Text (tab)
Text (tab)

Description

Zip code of Property (tab) Number (tab)
Contact Person (tab) Text (tab)
Area Code (tab) Number (tab)
Phone Number (tab) Number (tab)
Sq. Ft. of Property (tab) Number (tab)

© BrainMass Inc. brainmass.com October 25, 2018, 1:07 am ad1c9bdddf
https://brainmass.com/computer-science/files/real-estate-microsoft-database-252835

Solution Preview

Hello,

I have attached two files:

a) The Access database ...

Solution Summary

This solution deals with the creation of an real estate Access database with detailed steps and description.

$2.19
See Also This Related BrainMass Solution

Databases and financial institutions.

I need help analyzing the use of databases in a large bank/collection call center. I need examples and descriptions of known database applications that are used (Microsoft Access, DB2, Oracle, etc.) or some that could be considered to help the organization run smoother. For the known applications, I need to propose improvements. Any detailed information that can be provided as to known applications and how they are used and also suggested applictions and how they would benefit.

View Full Posting Details