View Single Post
  #3  
Old October 24th, 2008, 04:58 PM posted to microsoft.public.access.tablesdbdesign
Klatuu[_3_]
external usenet poster
 
Posts: 396
Default 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