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
|
|||
|
|||
New User Help with lots of information
I want to create a data base here in Access however I have never used it
before, So i dont know if these things are possible and what forms are the best to use if this is possible. I have been using Excel which i am pretty familiar with. Each tab I have a listing of different reports. One reports lists all the deposits for every company that uses a specific product. Right now this is about 30,000 + rows. THen i have another 5-6 different places where I report things. I want to see if I can move these into ACCESS. This is what I want to do. First I want to enter all the companies and what specific services they use SEcond I want repot all the deposits Then I want to bring in all the other reports. Then is is possible for me to create a report for one specific company? Say, I want to get all their basic information, (i.e. name address) and then on the same page it prints reports of the different services they are using and how often? Is this possible in access? Sorry for the long winded question but i really want to get this up and going. Thanks in advance. |
#3
|
|||
|
|||
New User Help with lots of information
"Steve" wrote in message
... Access has a long learning curve. There's quite a bit you need to learn to do what you describe here. You said you never used Access but you want to get this database up and running (soon I presume); the reality is "it ain't gonna happen". I would like to build the database for you. I provide help with Access, Excel and Word applications for a very modest fee. Contact me and let's get your database up and running. 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. John... Visio MVP |
#4
|
|||
|
|||
New User Help with lots of information
"John" wrote in message
... I want to create a data base here in Access however I have never used it before, So i dont know if these things are possible and what forms are the best to use if this is possible. I have been using Excel which i am pretty familiar with. Each tab I have a listing of different reports. One reports lists all the deposits for every company that uses a specific product. Right now this is about 30,000 + rows. THen i have another 5-6 different places where I report things. I want to see if I can move these into ACCESS. This is what I want to do. First I want to enter all the companies and what specific services they use SEcond I want repot all the deposits Then I want to bring in all the other reports. Then is is possible for me to create a report for one specific company? Say, I want to get all their basic information, (i.e. name address) and then on the same page it prints reports of the different services they are using and how often? Is this possible in access? Sorry for the long winded question but i really want to get this up and going. Thanks in advance. Be careful about responding to steve. He is not qualified enough to compete in a fair market so he preys on unsuspecting posters in a free advice newsgroup offering questionable results at unreasonable prices. If he was any good, his repeat business should keep him busy. John... Visio MVP |
#5
|
|||
|
|||
New User Help with lots of information
"Steve" schreef in bericht ... Access has a long learning curve. There's quite a bit you need to learn to do what you describe here. You said you never used Access but you want to get this database up and running (soon I presume); the reality is "it ain't gonna happen". I would like to build the database for you. I provide help with Access, Excel and Word applications for a very modest fee. Contact me and let's get your database up and running. Remember ??? "I judiciously chose who to offer fee-based help to based on whether it appears highly unlikely that the poster will get a solution from the newsgroup." -- 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.000 pageloads... it's a shame !!) Arno R |
#6
|
|||
|
|||
New User Help with lots of information
WARNING: Steve wants to build a database for you - at a price.
Learning curve? Yes. "it ain't gonna happen"? WRONG! Many of us were self-taught. I was. Your biggest problem will be "commit spreadsheet". As spreadsheet and table look similar, but they are not. I highly recommend getting some relational database training or reading "Database Design for Mere Mortals" by Hernandez before proceeding any further on this database. If you do need to hire someone, I would not recommend Steve. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Steve" wrote: Access has a long learning curve. There's quite a bit you need to learn to do what you describe here. You said you never used Access but you want to get this database up and running (soon I presume); the reality is "it ain't gonna happen". I would like to build the database for you. I provide help with Access, Excel and Word applications for a very modest fee. Contact me and let's get your database up and running. Steve "John" wrote in message ... I want to create a data base here in Access however I have never used it before, So i dont know if these things are possible and what forms are the best to use if this is possible. I have been using Excel which i am pretty familiar with. Each tab I have a listing of different reports. One reports lists all the deposits for every company that uses a specific product. Right now this is about 30,000 + rows. THen i have another 5-6 different places where I report things. I want to see if I can move these into ACCESS. This is what I want to do. First I want to enter all the companies and what specific services they use SEcond I want repot all the deposits Then I want to bring in all the other reports. Then is is possible for me to create a report for one specific company? Say, I want to get all their basic information, (i.e. name address) and then on the same page it prints reports of the different services they are using and how often? Is this possible in access? Sorry for the long winded question but i really want to get this up and going. Thanks in advance. . |
#7
|
|||
|
|||
New User Help with lots of information
Yes, that can all be done with Access.
From the basic information you have given, you are probably going to need at least three tables for the information. Table: Companies (contains information about each company) CompanyID (A unique value - often an autonumber field) that specifically identifies this record. That way you can edit the company name when/if needed NameOfCompany AddressInformation (several fields perhaps) ContactName (If you have just one contact) CompanyType (If you categorize companies) Table: AvailableServices (a list of the services and information about the service that does not change) ServiceID ServiceName ServiceDescription .... Table: ServicesUsedByCompany (Stores information on each service used by a company and any other details on this service incident for this company) ServiceID CompanyID DateOfService .... Once you get that structure set up you should be able to transfer the data in from the excel sheets with some work. You will be setting up forms for data entry and reports for publishing the information. And you will be able to fairly easily get a report of all companies that use a service(s) and a list of all services used by a company. With a little more work you can get a report of companies that don't use a service or all the services not used by a company. Post back when you get the structure set up and ask for help in setting up the transfer of data. When you do you will need to let people know about the database structure you have set up and about the structure of the excel file you are using. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County John wrote: I want to create a data base here in Access however I have never used it before, So i dont know if these things are possible and what forms are the best to use if this is possible. I have been using Excel which i am pretty familiar with. Each tab I have a listing of different reports. One reports lists all the deposits for every company that uses a specific product. Right now this is about 30,000 + rows. THen i have another 5-6 different places where I report things. I want to see if I can move these into ACCESS. This is what I want to do. First I want to enter all the companies and what specific services they use SEcond I want repot all the deposits Then I want to bring in all the other reports. Then is is possible for me to create a report for one specific company? Say, I want to get all their basic information, (i.e. name address) and then on the same page it prints reports of the different services they are using and how often? Is this possible in access? Sorry for the long winded question but i really want to get this up and going. Thanks in advance. |
#8
|
|||
|
|||
New User Help with lots of information
On Thu, 11 Feb 2010 08:04:01 -0800, John
wrote: I want to create a data base here in Access however I have never used it before, So i dont know if these things are possible and what forms are the best to use if this is possible. I have been using Excel which i am pretty familiar with. Each tab I have a listing of different reports. One reports lists all the deposits for every company that uses a specific product. Right now this is about 30,000 + rows. THen i have another 5-6 different places where I report things. I want to see if I can move these into ACCESS. This is what I want to do. First I want to enter all the companies and what specific services they use SEcond I want repot all the deposits Then I want to bring in all the other reports. Then is is possible for me to create a report for one specific company? Say, I want to get all their basic information, (i.e. name address) and then on the same page it prints reports of the different services they are using and how often? Is this possible in access? Sorry for the long winded question but i really want to get this up and going. Thanks in advance. All very possible. Steve is correct that there's a learning curve and that what you describe isn't trivial; he's incorrect in offering paid support on this FREE, VOLUNTEER forum (he's refused for ages to follow the rules the rest of us observe). Bear that in mind if you should consider hiring him. That said... Access is *very different* from Excel; your learning curve may require more than that of someone with no Excel experience because you may need to "unlearn" some of the "things you always do". For instance in Excel you will have different reports on different tabs; that's NOT how Access reports work at all! A Report is like a Form, a layout of data for printing; it would be based on a Query selecting which company and/or which services you want to print. Take a look at some of these resources, especially the tutorials at the end. They should get you started, and you're welcome to come back here for *free, volunteer* support. 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 Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
#9
|
|||
|
|||
New User Help with lots of information
You might try some of the very templates from the Access page.Experiment with
and change them to suit your needs.You will learn much doing this -- Lee Rolin "John Spencer" wrote: Yes, that can all be done with Access. From the basic information you have given, you are probably going to need at least three tables for the information. Table: Companies (contains information about each company) CompanyID (A unique value - often an autonumber field) that specifically identifies this record. That way you can edit the company name when/if needed NameOfCompany AddressInformation (several fields perhaps) ContactName (If you have just one contact) CompanyType (If you categorize companies) Table: AvailableServices (a list of the services and information about the service that does not change) ServiceID ServiceName ServiceDescription .... Table: ServicesUsedByCompany (Stores information on each service used by a company and any other details on this service incident for this company) ServiceID CompanyID DateOfService .... Once you get that structure set up you should be able to transfer the data in from the excel sheets with some work. You will be setting up forms for data entry and reports for publishing the information. And you will be able to fairly easily get a report of all companies that use a service(s) and a list of all services used by a company. With a little more work you can get a report of companies that don't use a service or all the services not used by a company. Post back when you get the structure set up and ask for help in setting up the transfer of data. When you do you will need to let people know about the database structure you have set up and about the structure of the excel file you are using. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County John wrote: I want to create a data base here in Access however I have never used it before, So i dont know if these things are possible and what forms are the best to use if this is possible. I have been using Excel which i am pretty familiar with. Each tab I have a listing of different reports. One reports lists all the deposits for every company that uses a specific product. Right now this is about 30,000 + rows. THen i have another 5-6 different places where I report things. I want to see if I can move these into ACCESS. This is what I want to do. First I want to enter all the companies and what specific services they use SEcond I want repot all the deposits Then I want to bring in all the other reports. Then is is possible for me to create a report for one specific company? Say, I want to get all their basic information, (i.e. name address) and then on the same page it prints reports of the different services they are using and how often? Is this possible in access? Sorry for the long winded question but i really want to get this up and going. Thanks in advance. . |
Thread Tools | |
Display Modes | |
|
|