Link to home
Start Free TrialLog in
Avatar of HLRosenberger
HLRosenbergerFlag for United States of America

asked on

using Access

It's been 10 years or so since I've done anything using Access, as far as forms and executable code.   I know VB very well.  I've used classic VB6.  I know databases.   I've created many form using VB6 and/or VB.NET/Visual Studio. What I don't know is how things are organized in Access, and how to get around, so to speak.  And how does one create a new application?  Define the "startup" form or code?    Can anyone give me a quick overview?
Avatar of Joe Howard
Joe Howard
Flag of United States of America image

To create a new application just create a new Access file.
The startup form is set in the settings window. Any form can be set as the startup form.
Startup code can be executed via the autoexec macro or via the OnOpen or OnLoad events of the startup form.
Access is a relational database system so the most important task to master when beginning with Access is proper database design, you should always follow the database normalization guidelines, this is just the tip of the iceberg.
Once the database is properly designed, comes the fun part, creating the actuall application your users will interact with, forms, reports and queries.
VBA is not required for many projects, nor is knowledge in Access's SQL language, but both can greatly enhance your application.
SQL can be used in queries (although in many cases the graphical query desginer will suffice) or in VBA.
Access is a event driven application, VBA code runs on event occurences, load, open, click, double click and close, to name a few.
Here's several Access Videos by EE Expert - Crystal
Avatar of HLRosenberger

ASKER

I know about Access as far as a relational and  normalization  rules.  My question was to broad, I guess.   What I really mean is how to use Access to create applications, and how to figure out where things are, where code is, where forms are, etc, and how all interact with each other.
SOLUTION
Avatar of Joe Howard
Joe Howard
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I'm not building one from scratch - I'm inheriting one that I need to maintain and make updates to.  The database part is not an issue, and this app have lots of code, VB script, which I also know.  My problem is just getting around the various code modules, forms, reports, etc.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks so much!