A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

usining Access instead of Excell.



 
 
Thread Tools Display Modes
  #1  
Old October 24th, 2008, 03:41 PM posted to microsoft.public.access.tablesdbdesign
ALEX
external usenet poster
 
Posts: 731
Default 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  
Old October 24th, 2008, 04:48 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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  
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



  #4  
Old October 24th, 2008, 06:17 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:16 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.