Solved

using Access

Posted on 2016-10-05
8
75 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 18

Expert Comment

by:Roy_Cox
ID: 41831173
Here's several Access Videos by EE Expert - Crystal
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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
 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
update query 4 25
set focus to tabbed sub form 10 39
Comparison query - 4 columns 9 26
How to insert a Clrf in query to remove trailing space upon data export 20 20
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

828 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