|
1.
|
ADO and DAO Library References in Access Databases
Avoid the problems with these default references.
|
By Tom Wickerath, MS Access MVP
|
|
2.
|
"Auto-complete" A Form, With or Without Code
Automatically fill in the rest of the text boxes in the record.
|
By The Gunny
|
|
3.
|
Automatically Update the Front End of a Split Database
Hesitant to split a multiuser database because updates are a headache? Virtually painless updates for split databases can be yours.
|
By Tom Wickerath, MS Access MVP
|
|
4.
|
The Case for the Surrogate Key
Ever wonder if there's an easier way to reference records and join tables in SQL queries than using the "natural" composite key?
|
By Mike Lonigro of Intelligent Enterprise Database Programming & Design Online
|
|
5.
|
Conditional Formatting In Forms And Reports
Customize text formatting in forms and reports, even without the conditional formatting feature in Access 2000 and later versions.
|
By Tom Wickerath, MS Access MVP
|
|
6.
|
Create Personalized Splash Screens for Access
Want to customize your Access database application so that it isn't so generic? Use a custom splash screen and an Access profile to allow your application to exhibit those custom behaviors.
|
By Steve Fisher of Access/VB/SQL Advisor Magazine
|
|
7.
|
Creating A Custom Login Screen For A Secured Database
Tired of the default login form when opening a secured Access database? Create your own custom login screen to give your users a unique experience and provide customized selections to choose from.
|
By Jeff Conrad, Access MVP (AKA The Access Junkie)
|
|
8.
|
Custom Command Bar Button
Create a custom command bar button to automate repetitive tasks.
|
By D. C. Conlin
|
|
9.
|
Dealing With The Trust Center
Learn to use Access 2007's Trust Center to avoid digitally signing your database applications.
|
By Tom Wickerath, MS Access MVP
|
|
10.
|
Determine Which Subform Records Have Been Selected
Get user input from multiple record selections at the same time.
|
By The Gunny
|
|
11.
|
Displaying Subtotals and a Grand Total on a Form That Displays a One-to-Many Relationship
Put subtotals and grand totals on your form.
|
By Tom Wickerath, MS Access MVP
|
|
12.
|
Do Microsoft MVP's Get a Free Marketing Boost By Promoting Their Web Sites In Newsgroup Postings?
We tested whether or not this "free advertising" is a useful marketing tool. The results may surprise you.
|
By D. C. Conlin
|
|
13.
|
Database-Driven Web Sites -- Series of Articles:
|
|
|
|
13a.
|
Introduction to Databases on The Web
Connect to your data, no matter where you are.
|
By D. C. Conlin
|
|
|
13b.
|
Static Data with Microsoft Publisher (Coming Soon)!
|
|
|
|
13c.
|
Static Data with Net Objects Fusion
Publish static Web pages based upon records in an Access database.
|
By D. C. Conlin
|
|
|
13d.
|
Dynamic Data with ASP and Microsoft Access
Add new records to an Access database on the Web from your desktop Access database -- with the push of a button. (Coming Soon)!
|
By The Gunny
|
|
14.
|
Education vs. Experience
Which is more important for your career? One of the most important nuggets I gained in my education wasn't in the text books. This nugget may well keep your career from ever stalling, too.
|
By The Gunny
|
|
15.
|
Export All Code Modules
|
By D. C. Conlin
|
|
16.
|
How To Clean Up Data -- Series of Articles:
|
|
|
|
16a.
|
Part 1: Web Pages And Text File Data Sources
Techniques using SQL and VBA functions to get the raw data from the Web page into the table and transform it into accurate, normalized data.
|
By D. C. Conlin
|
|
16b.
|
Part 2: Multi-valued Columns
Techniques using SQL and VBA functions to separate data in multi-valued columns into multiple columns. (Coming Soon)!
|
By D. C. Conlin
|
|
16c.
|
Part 3: Grouped Fields
|
TBD
|
|
17.
|
How to Create a Crosstab Query
Easily summarize information, calculate statistics and spot trends from data already stored in your database.
|
By Tom Wickerath, MS Access MVP
|
|
18.
|
Implementing a Successful Multiuser Access/JET Application
Tips and techniques to optimize your Access/Jet applications.
|
By Tom Wickerath, MS Access MVP
|
|
19.
|
Log Each User's Session
Create a log to record each user's session in the database application.
|
By The Gunny
|
|
20.
|
Multiuser Databases
All users must have "Full Control" permissions on the directory which contains the database.
|
By The Gunny
|
|
21.
|
Relational Database Design Boot Camp -- Series of Articles:
|
|
|
|
21a.
|
Training Day 1 (TD1): Introduction to Relational Database Design
Build your database the right way the first time.
|
By The Gunny
|
|
|
21b.
|
Training Day 2 (TD2): First Normal Form
Prevent data anomolies by avoiding storage of multiple values and multiple types in the same column.
|
By The Gunny
|
|
|
21c.
|
Training Day 3 (TD3): Second Normal Form
|
|
|
|
21d.
|
Training Day 4 (TD4): Third Normal Form
|
|
|
|
21e.
|
Training Schedule and Jarhead Jargon (Glossary Of The Marine's Language)
|
By The Gunny
|
|
22.
|
Sharepoint Services and Access
Connecting to Sharepoint Services to collaborate with distant colleagues easy. But is your data ready for the transition?
|
By D. C. Conlin
|
|
23.
|
Spreadsheet Import Wizard Error
Avoid the most common Spreadsheet Import Wizard Error.
|
By The Gunny
|
|
24.
|
Thirteen Ways To Loathe VB
Warnings for programmers experienced in other programming languages.
|
By Verity Stob of Dr. Dobb's Journal
|
|
25.
|
Use Microsoft Jet's ShowPlan to Write More Efficient Queries
Use Jet's built-in JETSHOWPLAN to analyze query execution plans
|
By Susan Sales Harkins and Mike Gunderloy
|
|
26.
|
Using a Combo Box to Find a Record
Think there must be a better way to search for a record than using the built-in "Find"? There is! You can easily find a record on any bound form by using a combo box.
|
By Tom Wickerath, MS Access MVP
|
