New to database

  • Thread starter Thread starter Garry Bullock
  • Start date Start date
G

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
 
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
 
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.
 
If someone could help me get started up on
the basics again I would be most grateful.
Click to expand...

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
 
Back
Top