Solved

using Access

Posted on 2016-10-05
8
52 Views
Last Modified: 2016-10-13
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?
0
Comment
Question by:HLRosenberger
8 Comments
 
LVL 26

Expert Comment

by:MacroShadow
ID: 41830674
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.
0
 
LVL 26

Expert Comment

by:MacroShadow
ID: 41830694
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.
0
 
LVL 17

Expert Comment

by:Roy_Cox
ID: 41831173
Here's several Access Videos by EE Expert - Crystal
0
 
LVL 1

Author Comment

by:HLRosenberger
ID: 41831622
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.
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 26

Assisted Solution

by:MacroShadow
MacroShadow earned 250 total points
ID: 41831699
Your question is indeed very broad, it's like asking how to compose music using a piano.
Any idea what kind of application ou want to build?
If not, you best bet would be to fiddle around with sample applications. There are several Access dedicated sample repositories to get you started:
http://www.access-programmers.co.uk/forums/forumdisplay.php?f=64
http://www.utteraccess.com/forum/index.php?showforum=34
0
 
LVL 1

Author Comment

by:HLRosenberger
ID: 41831775
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.
0
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 250 total points
ID: 41831896
An Access app could have standard modules (in the Modules group of the Nav pane), and forms and reports can have their own modules (opened from the View Code button on the Ribbon, or under the Microsoft Access Class Objects folder in the VB window:
Form modulesYou might find my book on Access application development useful -- it was written several versions ago, but the principles are still the same:

Title:  Expert One-on-One Microsoft Access Application Development
Author:  Helen Feddema
Publisher:  Wiley
Publication Year:  2004
ISBN:  0-7645-5904-4
Description:  This book is written for experienced Access users, who know how to create tables, queries, forms and other Access objects, and have some familiarity with writing Access VBA code, but need help in making the transition from an experienced and competent Access user who can create databases for personal use, to an Access developer who can make a living developing applications for clients. The book concentrates on this book writing VBA code to connect the components of a database into a functioning, coherent application.
0
 
LVL 1

Author Closing Comment

by:HLRosenberger
ID: 41842616
Thanks so much!
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now