usining Access instead of Excell.

A

Alex

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
 
J

Jeff Boyce

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
 
K

Klatuu

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.
 
J

John W. Vinson

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/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

If you have specific questions we'll be happy to try to give you specific
answers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top