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
|
|||
|
|||
usining Access instead of Excell.
Hello all,
I have an Excel five sheet tables and would like to use Access instead so I can run keyword or subject search for a particular subject, book, title, material source and so. I need some help. Thank you |
#2
|
|||
|
|||
usining Access instead of Excell.
Alex
That's a very broad, general request. These newsgroups work best on offering specific suggestions. What have you already tried? Have you tried using Excel to do this? (learning Access will take some time and effort...) Regards Jeff Boyce Microsoft Office/Access MVP "Alex" wrote in message ... Hello all, I have an Excel five sheet tables and would like to use Access instead so I can run keyword or subject search for a particular subject, book, title, material source and so. I need some help. Thank you |
#3
|
|||
|
|||
usining Access instead of Excell.
What kind of help do you need?
The first thing you need to do is get a good book on relational database design and get your head around the concept of relational data. A good choice is "Database Design for Mere Mortals". You will discover Access is not Excel on steriods. Excel uses a flat data model. It is a spreadsheet and is a whole different way of looking at data. If your first thought for a response is "well, I just need to look up some data, so why can't I just import my data into Access tables?", my answer would be don't bother with Access, just use data filtering in Excel. So first, get a handle on how your data should be structured, then sit down with a pencil and paper (pencil, specifically, you will need the eraser end), and lay out your table designs. Now you are ready to plan a data import strategy. When you need help. a specific question is best. It helps to include your version of Access and Windows. Also, define What you want to do. People can and will provide more help than if you ask How to do something. Often times, people will ask a how question that makes no sense because the how is not a good idea. Ask the What, you will get the How. Best of Luck to you. "Alex" wrote in message ... Hello all, I have an Excel five sheet tables and would like to use Access instead so I can run keyword or subject search for a particular subject, book, title, material source and so. I need some help. Thank you |
#4
|
|||
|
|||
usining Access instead of Excell.
On Fri, 24 Oct 2008 07:41:00 -0700, Alex
wrote: Hello all, I have an Excel five sheet tables and would like to use Access instead so I can run keyword or subject search for a particular subject, book, title, material source and so. I need some help. Thank you Here are some general resources for your general question: 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 If you have specific questions we'll be happy to try to give you specific answers. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|