Microsoft Office Tutorials and References
In Depth Information
Controlling What Happens When You Open the Database
Setting What It Does
Filter Lookup Options for Sample Database
Show List Values In:
Local Indexed Fields
Shows list values only in indexed fields.
Local Non-Indexed
Fields
Shows list values only in nonindexed fields.
ODBC Fields
Shows list values for Open Database Connectivity
(ODBC) fields.
Don’t Display Lists
When More Than
This Number of
Records Is Read
Sets maximum number of records to be read.
Caching Web Service an d SharePoint Tables
Use the Cache
Format That Is
Compatible with
Microsoft Access
2010 and Later
Specifies caching format.
Clear Cache on Close
Applies only to Microsoft Access 2010 and later cache
format.
Book VII
Chapter 3
Never Cache
Applies only to Microsoft Access 2010 and later cache
format.
Consider changing these settings:
Do you want people to be able to use Layout view to change your forms
and reports? If not, deselect the Enable Layout View check box.
Do you want a form to open automatically when the database opens? Set
the Display Form option to the form of your choice.
Do you want a macro to run automatically when the database opens?
After you customize a database by using the Access Options dialog box,
when anyone opens this database, Access performs the startup actions
you specify. Then Access runs the AutoExec macro, if any, which
performs additional actions. (See Book VI, Chapter 2 for details on creating
an AutoExec macro.)
Do you want to create any keyboard shortcuts? You can define them by
using an AutoKeys macro, which we describe in Book VI, Chapter 1.
Sometimes, you need to bypass the settings in the Current Database section
of the Access Options dialog box. No problem! Hold down the Shift key while
the database opens.
 
Search JabSto ::




Custom Search