Microsoft Access Database: How to Make MS Access Database Executable

Microsoft Access Database: How to Make MS Access Database Executable

This is not the first time I’ve discussed how to make MS Access database executable by converting it into either a MDE or ACCDE file format but some of the power users and developers are unaware of a couple of other post steps that should follow. 

Check out the quick two and half minute video on the first step and then watch step then second by locating a third party vendor’s free software application to create that all important script file.

httpvh://www.youtube.com/watch?v=aylQNvVDPsg

So, you can see how easy it is to generate a run-time version and strip out the design components. There are a few things to also bear in mind… 

Microsoft Access Database: How to Make MS Access Database Executable – Few Pointers

Make sure you include Continue reading “Microsoft Access Database: How to Make MS Access Database Executable”

Designing An Access Database: Some Simple Steps For Your New MS Access Database

Designing An Access Database: Some Simple Steps For Your New MS Access Database

As I have preached many times and so it seems other Access database experts are of the same opinion, designing an Access database requires a plan, time and a methodical approach.

designing an access database

I found this article which is another perspective but similar to my 7 step MS Access database plan that may be worth a read – check it out below…

Create an MS Access Database – 9 Simple Steps to a Productive Database

STEP 1: Define the Purpose

Before you try to create an MS Access database first decide what the purpose for the database is. Software is much like a vehicle. Cars transport people from Continue reading “Designing An Access Database: Some Simple Steps For Your New MS Access Database”

Access Form Designs – How To Create A Report Interface For Your Access Database

Access Form Designs – How To Create A Report Interface For Your Access Database

For the more polished and professional database, using Access form designs doesn’t necessarily mean viewing records from tables and queries. It can also serve as a general way to manage your MS Access database objects namely Access reports.

For example, running reports from a nicely designed form showing a list of available reports that calls another form (perhaps for its criteria) before it actually displays the preview or hard copy report can improve the usability of your custom built application.

access form designs - reports

By having an Access form design to list all the reports in a List Box control with a series of command buttons to choose the output (how they run), drives the Continue reading “Access Form Designs – How To Create A Report Interface For Your Access Database”

Microsoft Access Queries – How Many Types Do You Know And Use In Your Access Database?

Microsoft Access Queries – How Many Types Do You Know And Use In Your Access Database?

You use Microsoft Access queries to view, change, and analyse data in different ways. You can also use them as a source of records for your forms, reports, and other output views.

So, how many do you know? How many have actually used?

microsoft access queries - types

Get Microsoft Access queries to ask questions of your database. The more you ask the more answers you get!

To me, it’s the heart of any Continue reading “Microsoft Access Queries – How Many Types Do You Know And Use In Your Access Database?”