Watch MS Access – Different Ways to Start Up a Database

Posted on
9,552 Points
13 Endorsements
Last Modified:
Experience Level: Beginner
Jim Dettman (EE MVE)
Independent consultant specializing in the writing of custom packages for businesses.
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.

Video Steps

1. Specify a start-up form through options

2. Specify an Autoexec macro

3. Use the /X command line switch to specify a macro name

4. Use the /CMD command line switch to pass arguments into the database

There is no single "correct" calculation method for quartiles. Excel features two methods, some math and statistic packages offer some more, but here is presented no less than twenty methods for various purposes using VBA and Microsoft Access.
Creating multiple copies of a sub-form to use in a single form will bloat your database and require significant effort to maintain.  Instead, use multiple sub-form controls with the same Source Object and make judicious use of SQL and VBA to filter …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month