A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

New to database



 
 
Thread Tools Display Modes
  #1  
Old October 9th, 2008, 04:20 PM posted to microsoft.public.access.tablesdbdesign
Garry Bullock
external usenet poster
 
Posts: 1
Default New to database

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 Bullock
  #2  
Old October 9th, 2008, 04:34 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default New to database

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

"Garry Bullock" wrote in message
...
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 Bullock



  #3  
Old October 9th, 2008, 04:58 PM posted to microsoft.public.access.tablesdbdesign
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default New to database

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Garry Bullock" wrote:

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 Bullock

  #4  
Old October 9th, 2008, 06:23 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default New to database

On Thu, 9 Oct 2008 08:20:09 -0700, Garry Bullock
wrote:

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 he

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...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
--

John W. Vinson [MVP]
  #5  
Old October 9th, 2008, 10:20 PM posted to microsoft.public.access.tablesdbdesign
Klatuu[_3_]
external usenet poster
 
Posts: 396
Default New to database

And one more bit of info. If you go to this site:
http://www.databaseanswers.org/data_...tals/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

"Garry Bullock" wrote in message
...
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 Bullock



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.