Advice Please

  • Thread starter Thread starter SusanM
  • Start date Start date
S

SusanM

Hello Everyone.

I am new to Acess, about 3 months. taken classes at local
university and have a gozillion books.
I have a very large project due march 04 and right now I
don't think I can do it will all the ??? I an doing a
much much smaller version now. If it were for the
community newsgroups I would be crazy.
Can a new user use Access without using VB?
Can a new user setup a end user firendly data base
application?
Advice apreciated
Thanks, you are the greatest group
Susan
 
Susan,

Yes, a new user can use Access without using VBA. However, setting up
a user-friendly application will definitely require the automation of
data management processes, which means either macros or VBA
procedures. There is a tremendous amount you can do with macros, but
there are some things that can only be done with VBA. Just depends on
whether these apply to your project... but if they don't now, it is
probably inevitable that they eventually will :-)

Most people find there is a fairly steep learning curve with Access.
I wouldn't normally recommend a "new user" to launch straight into a
"very large project". I think it is advisable to tackle a smaller
project first, in order to get some degree of mastery on some of the
core principles such as correct table design. But I would expect that
if you make use of your gozillion books, and the help available in the
newsgroups, you will make a lot of progress by March.

- Steve Schapel, Microsoft Access MVP
 
Where and how would be the best way to learn VBA?
We have several MS Certified Training Centers here.
Thanks to all.
SusanM
 
Susan,
Been there, done that! It is not easy. Assuming you are using Access 2000
Professional there is a great book to get you started and guide you along
the way. Taking classes in VBA is also a good option if you have the time
and money. You will still have to have a complete reference book to guide
you after you complete the classes. This book includes many examples, easy
to read and all the code in the book is on an included CD. The book is:
"Access 2000 Developer's Handbook", Volume 2: Enterprise Edition. Author is
Paul Litwin, Ken Getz and Mike Gilbert. Published by Sybex.
You might also consider obtaining the same book, Volume 1. Same deal, same
authors.
I have found the books to be a great help.

Cheers,
Henry
 
Back
Top