Database

[Sarah]

Hi,

I'm trying to set up a database for a property rental company. I need it to
include addresses, owner, owner's details (email address and phone number),
hyperlinks to webpages on our website and as much other information as
possible. Can anyone suggest how to do this, what program to use? Any
advice?!!?!?

 

[Fred]

Hello Sarah,

There are infinite number ways of approaching. Let's assume that by posting
here you want to use Access and build it yourself.

Step 1 wold be to learn Access at least a little.

Step 2 Create a new table in design view, make fields for all of those
items that you listed. Make them all text type except "hyperlink" type for
your hyperlink field. Then make an Autonumber type field named
"PropertyNumber". Enter a few records.

Step 3 Using wizards experiment with making and using queries, forms and
reports that use your table as a data source.

 

[John W. Vinson]

Hi,

I'm trying to set up a database for a property rental company. I need it to
include addresses, owner, owner's details (email address and phone number),
hyperlinks to webpages on our website and as much other information as
possible. Can anyone suggest how to do this, what program to use? Any
advice?!!?!?

Access would be very much capable of doing this. Think of Access as a full
featured toolbox. You won't be able to open Access and take out your property
rental database any more than you'ld open a toolbox and take out a garden
shed... but it does have the tools you need. For some resources see
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials