Solved

using Access

Posted on 2016-10-05
8
58 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 27

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 27

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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 27

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

911 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

26 Experts available now in Live!

Get 1:1 Help Now