WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

New to database

 
   Home -> Office other -> Table Design RSS
Next:  Updating (changing) Linked tables by code?  
Author Message
Garry Bullock

External


Since: Oct 09, 2008
Posts: 1



(Msg. 1) Posted: Thu Oct 09, 2008 8:20 am
Post subject: New to database
Archived from groups: microsoft>public>access>tablesdbdesign (more info?)

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
Back to top
Login to vote
Jeff Boyce

External


Since: Nov 04, 2004
Posts: 3939



(Msg. 2) Posted: Thu Oct 09, 2008 8:34 am
Post subject: Re: New to database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" <GarryBullock.TakeThisOut@discussions.microsoft.com> wrote in message
news:15692CAA-DC22-4D4C-8703-6AE58AA2AB6C@microsoft.com...
> 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
Back to top
Login to vote
Jerry Whittle

External


Since: Mar 03, 2006
Posts: 1993



(Msg. 3) Posted: Thu Oct 09, 2008 8:58 am
Post subject: RE: New to database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Login to vote
John W. Vinson

External


Since: Jan 29, 2004
Posts: 6313



(Msg. 4) Posted: Thu Oct 09, 2008 11:23 am
Post subject: Re: New to database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Thu, 9 Oct 2008 08:20:09 -0700, Garry Bullock
<GarryBullock.RemoveThis@discussions.microsoft.com> 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 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
--

John W. Vinson [MVP]
Back to top
Login to vote
Klatuu

External


Since: Sep 09, 2008
Posts: 312



(Msg. 5) Posted: Thu Oct 09, 2008 4:20 pm
Post subject: Re: New to database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

"Garry Bullock" <GarryBullock.TakeThisOut@discussions.microsoft.com> wrote in message
news:15692CAA-DC22-4D4C-8703-6AE58AA2AB6C@microsoft.com...
> 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
Back to top
Login to vote
Display posts from previous:   
       Home -> Office other -> Table Design All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
 Office
  Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET