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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|