Access

access logo
msofficeshare logo
switchboard logo

Switchboard

Switchboard is a wonderful navigation tool.  It’s versatile and user-friendly.  Click the above picture or here to see how to do it.

Use ODBC to connect Oracle Database and MS Access

Click the above picture or here to see how to do it.

odbc logo
accde logo

MDE or ACCDE format

Hide Visual Basic Modules by saving your Access Files in MDE or ACCDE file formats.  Click the above picture or here to see how to do it.

Use Input Form for Parameter Query

Click the above picture or here to see how to do it.

compact logo

Hide the Navigation Pane

Click the above picture or here to see how to do it.

pic4 hide navigation pane

Use Embedded SQL Query

Use Embedded SQL Query for better efficiency and security  Click the above picture or here to see how to do it.

Compact Database

Compact your Access database to keep it small and improve its performance.  Click the above picture or here to see how to do it.

parameter query logo
pic4 join and union

Joins and Union for Queries

Click the above picture or here to see how to do it.

embedded sql logo
tranlate logo

Use Translator

The translator can help save 80% to 90% of time compared with the one that we did in the old fashioned way.  Click the above picture or here to see how to do it.

access search form logo

MS Access Search Form

Use a search form for easy access and editing to a paricular record in a database..  Click the above picture or here to see how to do it.

array logo

Use Array in Access VBA to read data from or write data to Tables and Queries

Click the above picture or here to see how to do it.