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
 
Answers in-line:


SusanM said:
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?
Click to expand...

Yes, but in most instances VBA will do a better job becuase of programming
language power and error handling. Simple VBA coding isn't that hard, and
you have hundreds of people here to help you.
Can a new user setup a end user firendly data base
application?
Click to expand...

Absolutely! Look at some others on the web for ideas. I have several dozen
simple ones design for specific tasks at my datastrat.com website. Microsoft
has several dozen templates built in. Many of the MVPs here have websites
with examples, and there is of course the MVP Access Web. (see the url in my
sig)

Advice apreciated
Thanks you are the greatest group
Susan
Click to expand...

Awe shucks! Ya make me blush!
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Susan, as long as you understand the basics before beginning to create the
database such as Normalization, Referential Integrity and Relationships on
tables, then creating any Access database will be a piece of cake. The
beauty of Access is that a novice can create a pretty nice database without
a stitch of VBA. In some cases if you use the built-in wizards, Access will
write the VBA code for you. The only time you will need to know how to write
VBA is if you decide to add special procedures or functions that are not
created automatically by Access.

And as mentioned Access does have some built-in templates that you can draw
from, as well as from the Microsoft Office Template website (reachable
through your help menu in Access) and if you read and understand your
gozillion books, then your project should go smoothly.

What does your project entail? Perhaps we have some ideas, solutions, or
pitfalls to pass along.
 
Can a new user use Access
without using VB?
Click to expand...

Yes, but as Arvin stated, that may not be best.

For one thing, you can't include user-friendly error handling just using
macros.
Can a new user setup a end
user firendly data base
application?
Click to expand...

I have a colleague and friend who, back in the early 1990s converted a DBase
application to Access for the food service of the school district by which
he was employed at the time. Enhanced and updated over the years, it has
served them well, day-in-and-day-out, ever since, and he says that the only
VBA code in that application is that generated by Access' wizards.
 
Back
Top