New to database

[Garry Bullock]

Hello everyone my name is Garry

I am trying to start up a new database that contains lots of information for
houses, flats, bungalows etc.

The type of info i need on the database includes:

Basic property info: Type, style, storeys, rooms, date built, wall type,
roof type etc.

Measurements: Floor area m2, room height, perimeter

Heated conservatory: floor area, double glazed? height etc

Windows:

Heating and controls:

etc, etc, etc.

I have the form on word, and hard copies, but i would like to take my laptop
to the customers house as it is much more professional. I have used access
before but a number of years ago. If someone could help me get started up on
the basics again I would be most grateful.

Regards

Garry

 

[Jeff Boyce]

Garry

I generally advise folks working with Access to focus on their experience in
three areas:

1) relational database design/normalization
2) Access tricks/tips ("how to's")
3) (effective & usable) graphical user interface design

Oh yes, and experience developing applications!

On my projects, step one is always making sure the users & I agree on the
data involved, and creating the normalized table structure to hold/relate
it.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jerry Whittle]

Top of the list of things that I ask new clients is if they have searched
places like trade publications for a program that will do the job. Unless you
have a lot of time or what to learn a new skill or your business is truely
unique, it's almost always cheaper and easier to buy something off the shelf.

I highly recommend getting some database training or reading "Database
Design for Mere Mortals" by Hernandez before proceeding any further on this
database.

 

[John W. Vinson]

If someone could help me get started up on
the basics again I would be most grateful.

In addition to Jerry and Jeff's good advice, you can look at some tutorials
and resources here:

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

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

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

 

[Klatuu]

And one more bit of info. If you go to this site:
http://www.databaseanswers.org/data_models/apartment_rentals/index.htm

There is a template for apartment rental management. It will help you
understand the basic data structures you will need to consider.

Best of Luck