Les, welcome to Access, this is a smart move. The transition is not
quite as easy as you might think. The only similarities in the two
programs are that they come from Microsoft and the spreadsheet and
tables appear to be the same.
While Excel is a flat file, Access is a multi level file which then uses
a Primary Key ("ID") to link the data of all the sheets together. The
transition requires you to de-excel your thinking as Access tables are
completely dumb. They cannot calculate or perform any lookup or
relational functions. They just hold data in rows and fields. So to
answer your questions in general first, here's some starters. One
you've got your head around that, come back to us with the specifics on
how to make it all work sweetly.
After import, your excel sheets will need to be split into a number of
different tables. It's called "Normalization" and basically means that
if you have repeating data in your rows like State for example, then
that data lives in a table of its own and you simply use its ID to
indicate the state in your main data. There is a Tool called the
Performance or Database Analyser. This will read all the data in your
imported spreadsheet and split it into relational tables. That's not a
bad place to start at all.
Looking at most of your questions, learning about Queries and Forms
(with subforms) will almost certainly lift the scales from your eyes and
give you a tool that will perform much more than Excel. Your questions
just briefly,
First: You use Forms to add/modify records. Without knowing what your
excel sheet does, we can't comment on the relative speeds between the
two programs as you need to use them.
Second: If you're querying your data then you will use Access Queries,
not excel ones. Your excel ones can be duplicated in Access and a lot
done with them.
Third: Your VBA forms are created so quickly in Access that you will
not use the excel ones any more.
Brett
Les Williams wrote:
> Hi Gang
> I'm stuck with a few problems. I'd consider myself to be quite
> advanced in excel but I'm having trouble in taking it to the next
> level.
>
> First: I'd like to house my data in Access as the amount of info is
> slowing excel down. I do know how to import an excel file into access
> but I don't know how to just add a few records (or even "one" record)
> at a time.
>
> Second: I don't know how to pass perameters from excel to a queiry in
> access so as to only retrieve the "filtered" or pertinent data that I
> need from the Access file so that I can manipulate it in excel.
>
> Third: A short lesson on how to change the properties of such things
> as (VB User forms) would be of great help.
>
> I have a program called "GoToMeeting" that I could use to get this
> help with. If anyone has any suggestions about how I can get through
> these few knotholes, I'd greatly appreciate hearing from you.
>
> Thanks
>
> Les Williams (The Corporate Gardener)
> Bradford Ontario Canada (905-775-4004)
> www.CorporateGRIP.com
>
Brett Collings
Strengthening Families Administrator
D2D 46422
DDI (04) 916 3422
-------------------------------
This email message and any attachment(s) is intended only for the
person(s) or entity(entities) to whom it is addressed. The
information it contains may be classified as IN CONFIDENCE and may be
legally privileged. If you are not the intended recipient any use,
disclosure or copying of the message or attachment(s) is strictly
prohibited. If you have received this message in error please
notify us immediately and destroy it and any attachment(s).
Thank you. The Ministry of Social Development accepts no
responsibility for changes made to this message or to any
attachment(s) after transmission from the Ministry.
-------------------------------
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
