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  

Help with database



 
 
Thread Tools Display Modes
  #1  
Old March 16th, 2010, 01:54 AM posted to microsoft.public.access.tablesdbdesign
Jenni
external usenet poster
 
Posts: 21
Default Help with database

I need to create a database that lists companies, with dates items done by,
money paid, notes etc. Thats okay, but I need to retain the previous years
records and start a new year off fresh. How would I do that?

Ads
  #2  
Old March 16th, 2010, 02:27 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Help with database

Jenni,

It sounds like you have never created a database so I'm going to suggest you
start here...

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

Sample data models...
http://www.databasedev.co.uk/table-of-contents.html

AFTER you review and RE-review the above you need to set up some tables...

tblCompanyProfile
cpCompanyID (PK - AutoNumber)
cpCompanyTypeID (FK - Long ~ relate to tblCompanyTypes)
cpCompanyName (Text, 75)
cpSalutation (Text, 4)
cpFirstName (Text, 50)
cpMiddleInitial (Text, 2)
cpLastName (Text, 50)
cpCredentials (Text, 20)
cpNickname (Text, 50)
cpEIN (Text, 20)
cpPositionTitle (Text, 50)
cpAddress1 (Text, 30)
cpAddress2 (Text, 25)
cpCityID (FK: Text, 20)
cpStateID (FK: Text, 20)
cpPostalCode (Text, 15)
etc...

tblCompanyTypes
ctCompanyTypeID (PK - Autonumber)
ctComapnyType

tblCompanyActivities
caDate
caPriorityID (High, Medium, Low)
caActivityID (FK - Long - relate to tblActivities)
caNotes (Prefer you don't use a Memo field data type here)
caDone (Yes/No)

tblActivities
aActivityID (PK - Autonumber)
aActivity

....without more information that's as far as I can go.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Jenni" wrote in message
...
I need to create a database that lists companies, with dates items done by,
money paid, notes etc. Thats okay, but I need to retain the previous years
records and start a new year off fresh. How would I do that?

  #3  
Old March 16th, 2010, 03:20 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Help with database

On Mon, 15 Mar 2010 17:54:01 -0700, Jenni
wrote:

I need to create a database that lists companies, with dates items done by,
money paid, notes etc. Thats okay, but I need to retain the previous years
records and start a new year off fresh. How would I do that?


Store all the data in one table, with a date/time field. "Start the new year
fresh" by basing your Forms (and where necessary reports) on Queries selecting
the desired date range.

Having separate tables for each year makes sense for a spreadsheet but no
sense at all for a database!
--

John W. Vinson [MVP]
  #4  
Old March 16th, 2010, 09:10 PM posted to microsoft.public.access.tablesdbdesign
Rob H
external usenet poster
 
Posts: 35
Default Help with database

I'm still pretty new to Access myself but I would think you could keep
entering all of your data on one table but then use queries and reports to
sort and view the data by year. Maybe this isn't what you're looking for
but thought I'd throw it out there.

"Jenni" wrote:

I need to create a database that lists companies, with dates items done by,
money paid, notes etc. Thats okay, but I need to retain the previous years
records and start a new year off fresh. How would I do that?

  #5  
Old March 17th, 2010, 12:04 AM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Help with database

Hello Jenni,

The learning curve for Access is long and steep. It will take a long time to
be able to do it yourself. If you need a database up and running quickly, I
can help you. I provide help with Access, Excel and Word applications for a
very modest fee. I can build the basic database you need for you for a small
fee. Once you have the database up and running, you can add to it if you
want on your own. If you want my help, contact me.

Steve



"Jenni" wrote in message
...
I need to create a database that lists companies, with dates items done by,
money paid, notes etc. Thats okay, but I need to retain the previous
years
records and start a new year off fresh. How would I do that?



  #6  
Old March 17th, 2010, 12:33 AM posted to microsoft.public.access.tablesdbdesign
Stop$teve
external usenet poster
 
Posts: 76
Default Help with database


"Steve" schreef in bericht ...
Hello Jenni,

The learning curve for Access is long and steep. It will take a long time to be able to do it yourself. If you need a database up
and running quickly, I can help you. I provide help with Access, Excel and Word applications for a very modest fee. I can build
the basic database you need for you for a small fee. Once you have the database up and running, you can add to it if you want on
your own. If you want my help, contact me.


The learning curve for YOU is long $teve

--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 11.500 pageloads... it's a shame !!)

Arno R


  #7  
Old March 17th, 2010, 12:48 AM posted to microsoft.public.access.tablesdbdesign
Rob H
external usenet poster
 
Posts: 35
Default Help with database



"Steve" wrote:

Hello Jenni,

The learning curve for Access is long and steep. It will take a long time to
be able to do it yourself. If you need a database up and running quickly, I
can help you. I provide help with Access, Excel and Word applications for a
very modest fee. I can build the basic database you need for you for a small
fee. Once you have the database up and running, you can add to it if you
want on your own. If you want my help, contact me.

Steve



"Jenni" wrote in message
...
I need to create a database that lists companies, with dates items done by,
money paid, notes etc. Thats okay, but I need to retain the previous
years
records and start a new year off fresh. How would I do that?



.
Steve,

I'm new here but I've been warned about your tactics, who would want to
pay a complete stranger for help that is free? At elevated fees? I notice
you don't respond to any of these posts which just makes your case less
reputable.
  #8  
Old March 17th, 2010, 03:13 AM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default Help with database

"Steve" wrote in message
...

The learning curve for Access is long and steep. It will take a long time
to be able to do it yourself. If you need a database up and running
quickly, I can help you. I provide help with Access, Excel and Word
applications for a very modest fee. I can build the basic database you
need for you for a small fee. Once you have the database up and running,
you can add to it if you want on your own. If you want my help, contact
me.

Steve





Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP



  #9  
Old March 18th, 2010, 12:26 AM posted to microsoft.public.access.tablesdbdesign
Jenni
external usenet poster
 
Posts: 21
Default Help with database

Thank you for all the help. It has been years since I made a database and by
all means still a newbie. I have created what I wanted with your help.
  #10  
Old March 18th, 2010, 12:35 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Help with database

And we are glad you got what needed...

You're welcome!
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Jenni" wrote in message
...
Thank you for all the help. It has been years since I made a database and
by
all means still a newbie. I have created what I wanted with your help.

 




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 01:35 PM.


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