Home All Groups Group Topic Archive Search About
Author
19 Jun 2009 9:47 AM
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?!!?!?

Author
19 Jun 2009 3:20 PM
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.
Are all your drivers up to date? click for free checkup

Author
19 Jun 2009 4:14 PM
John W. Vinson
On Fri, 19 Jun 2009 11:47:25 +0200, "Sarah" <squirtkeat***@gmail.com> wrote:

>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

--

             John W. Vinson [MVP]

Bookmark and Share