The difficult I do immediately, the impossible takes a little bit longer.


Setting up a Model Database...

How to use Windows System Colors   (Access 2003 and earlier)
Where are the Options?   (Access 2007 and higher)
Trusted Location   (Access 2007 and higher)
Export Specifications   (Access 2007 and higher)
Import Specifications   (Access 2007 and higher)
Navigation Pane Options  (Access 2007 and higher)
Option for Current Database  (Access 2007 and higher)
When I first started to work with Microsoft Access I would make my new database and then proceed to go thru all the Options to get the database ready for me to start creating tables.  And sometimes, I would forget to check (or uncheck) something that would cause me problems later on.   So now I have set up a *Model Database* in Access 2003 and Access 2010.  Now, when I want to create a new database I simply open it and do a *Save As* and rename to the new database, below are the options I set.  For more of my Database Standards see My Blog.
Uncheck *New object shortcuts*
Uncheck *Track name AutoCorrect info*
Check *Always use event procedures* in VB Editor
Uncheck *Compact on Close*
Set *Default font* as Tahoma
Uncheck *Show Smart Tags on Datasheets*
Select *Run Permissions* - Users
Check *Use four-digit year formatting* - All Databases
Set *Default open mode* - Shared
Uncheck *Unassociated label and control*...
Check *Require Variable Declaration* in VB Editor
Continuous form
Tools > Options > View
Options > Client Settings
Options > Client Settings (called *Action Tags*)
Options > Client Settings
Set *Document Window Options* - Overlapping Windows

When I'm all finished designing I uncheck *Display Navigation Pane*.  Afterall, I do not want End-Users to easily get to the backend as I don't use Access Security.  However, if you are looking to use it and want to set up defaults in your Model Database click here.

And lastly, for some Microsoft Access Developer Tools to make your designing and developing life a little easier click here.

Tools > Options > General
Tools > Options > General
Tools > Options > General
Tools > Options > Datasheet
Tools > Options > Datasheet
Tools > Options > Advanced
Tools > Options > Tables/Queries
Tools > Options > Forms/Reports
Tools > Options > Error Checking
Location of Option in 2003
...and *New unassociated labels*
Location of Option in 2010
Go to the VB Editor (Open the database and press Ctrl + G on your keyboard).  Then select Tools > Options...
Checking that box puts *Option Explicit* at the top of every module you create.  (Even the ones behind forms.)

Why is *Option Explicit* important?

While *Option Compare Database* tells your code how to compare strings, numbers, etc.  *Option Explicit* tells your code that each variable needs to be defined for it to be used.  Nothing should be placed above these two lines.

Some of the Tables from my Model Database
Can also be used for Purchase Orders
Forms and Reports in the Model Database
Single form
1. Regular
2. Set up to look like a Datasheet
For Access 2003 I also have...

Odds and Ends

Colors, formatting and text set

Object Designer (Access 2007 and higher)
Report with Subreport
I use this *add-in* because I shy away from using the built in ActiveX Control as it will cause issues on machines that may not have the same version I used.  The other perk is that it does not require any *outside* supporting files, such as .DLL's.
The easiest way to *custom* convert a report to .PDF format.
Using this eliminates that annoying issue of scrolling records when you really want your Users to remain on the current record.
Contains all of my Utility functions

Cool Tip

To prevent a form from maximizing when opening a form or report from said form, set the said forms *Min Max Buttons* Property to [NONE].

Only table I have without *tbl* because I use the *tbl* prefix in code and that prefix will leave that table out of any query.  For a complete list of my Naming Conventions click here.

Set *Subdatasheet* to [None] in your *stock* tables and any ones you create
Tools > Options > Current Database
Set Subdatasheet to None  (Access 2003 and higher)

These options will not *travel* with the file.

Has Cities and Postal Codes