Skip to main content

Access Junkie - MVP Alumnus

Home
Access Inside Out Books
Access 2010 FAQ
Access 2007 Training
Access 2007 FAQ
Access 2007 KB Articles
Technical Articles
Links
MSDN Articles
Blogs
Forums
Contact Us
About Us
Member Login
Access 2010 Frequently Asked Questions (FAQ)

 

This page presents answers to some of the most frequently asked questions concerning Microsoft Access 2010. These questions are loosely organized by category.

 

Application IssuesQuestion

Link

Where do I find all the Access Options in Access 2010?

Link

Where do I find the Database Properties dialog box in Access 2010?

Link

Why does Access 2007 display in the application window title even though I'm using Access 2010?

Link

How do I create a new database in the 2000-2003 MDB format?

Link

How do I create a new Access Data Project (ADP) in Access 2010?

Link

How to I create a Blank database template that includes all the settings and objects I want?

Link

How do I open a database in Exclusive Mode in Access 2010?

Link

How do I clear all saved Trusted Documents?

Link

Can I change the color scheme to something other than the default silver color?

Link

Why can’t I create web objects in my database?

Link

How do I install the 64-bit version of Access 2010?

Link

Is it possible to connect to SQL Azure from Access 2010?

Link

How do I pin a custom Access database shortcut to the Windows 7 taskbar?

 

 

Back to top

 

 

Backstage View Question

Link

How do I close the Backstage view?

Link

How do I find out what version of Access 2010 I’m using?

Link

Can I adjust the number of recently opened databases on the Backstage view?

Link

Is it possible to customize the Backstage view?

 

 

Back to top

 

 

Navigation PaneQuestion

Link

What happened to the Database Window in Access 2010?

Link

Why can't I use the Ctrl + Double click shortcut to open the various database objects in Design View?

Link

I've heard there is a Search box for the Navigation Pane. Where do I find it?

Link

Is there a way to add or remove items from a group in the Navigation Pane through VBA or a macro?

Link

Where do I find the option to view hidden and system objects in the Navigation Pane?

Link

Is it possible to not show the Navigation Pane when I open my database in Access 2010?

Link

How do I view the details of each object in the Navigation Pane?

Link

Can I have the objects in the Navigation Pane display in multiple columns?

Link

How can I open objects from the Navigation Pane with only a single click?

Link

I can't expand the Navigation Pane because it's too small. How do I fix that?

 

 

Back to top

 

 

Client Table Issues

Question

Link

Where are the Table Templates that were available in Access 2007?

Link

How do you set up a field to accept Rich Text in Access 2010?

Link

I cannot find the Attachment or Calculated data type in table design mode. Can you tell me why?

 

 

Back to top

 

 

Web Table Issues

Question

Link

How do I create a new web table?

Link

How can I design web tables using Design view?

Link

How do you create a table level validation rule in a web table?

Link

How do I view the Relationships diagram in a web database?

 

 

Back to top

 

 

Data Macro IssuesQuestion

Link

Where is the USysApplicationLog table?

Link

Can I change the font size and color in the Logic Designer?

Link

Can you use data macros to simulate a multi field index?

Link

I'm getting an error when I try to use data macros in local tables to update data in linked tables. Why?

 

 

Back to top

 

 

Client Form IssuesQuestion

Link

Where is the ActiveX Calendar Control in Access 2010?

Link

Can I convert an embedded image into a shared image?

Link

Is there any way to navigate the new Web browser control using VBA?

Link

Why can’t I see Web Browser Control listed in the Controls group?

Link

Where do I find the Switchboard Manager Wizard in Access 2010?

Link

Is there a way to convert the elements of a Switchboard Manager to the new Navigation Control?

Link

Is there a way to extract saved form background images to reuse elsewhere?

 

 

Back to top

 

 

Web Form IssuesQuestion

Link

Why do I have extra images in the Shared Images dialog after I import objects?

Link

Why don’t I see any controls on my form in Layout view?

Link

How can I publish web forms and reports based on the USysApplicationLog to the server?

Link

How do I add a shared image into the database?

Link

Why does my web browser control not show any content?

Link

Why don’t I see any events in the Property Sheet window for my label control?

Link

How do I create a cascading combo box on a web form?

 

 

Back to top

 

 

Client Macro IssuesQuestion

Link

Why are my macros and VBA code not working in Access 2010?

Link

Where are all the extra Macro Actions for client databases in Access 2010 such as SetValue?

Link

Is it possible to write code or use a macro to open the Access Options dialog box in Access 2010?

Link

Why does the Action Catalog not appear when I click the Ribbon button to display it on the macro design surface?

 

 

Back to top

 

 

Working in BrowserQuestion

Link

How do I instantiate a built-in web database on the server?

Link

Can you instantiate the five web templates using a PowerShell command?

Link

Can I upload my own custom web template to the server and instantiate it?

Link

Can you upload, activate, and instantiate your own custom ACCDT on the server with PowerShell?

Link

Why does the web form in the browser say it can’t find the field, but it works fine in client?

Link

Why can’t I restore my record from the SharePoint recycle bin?

Link

Why does my continuous form have so much extra gap between the records in the browser?

Link

Why can’t I see the hyperlink, attachment, and calendar picker buttons on my web form in the browser?

Link

Can I deactivate and delete a custom ACCDT from the Solutions Gallery using a PowerShell command?

 

 

Back to top

 

 

Ribbon IssuesQuestion

Link

Is there a graphical tool available to edit the built-in Ribbons in Access 2010?

 

 

Back to top

 

 

Runtime Issues

Question

Link

Where do I find the Package Solution Wizard in Access 2010?

Link

Where can I download the Access 2010 Runtime?

Link

Where can I download the Access Database Engine 2010 Redistributable?

Link

Where can I download the Access 2010 Source Code Control Add-in?

 

 

Back to top

 

 

Template IssuesQuestion

Link

Where do I find the Northwind 2010 web database?

Link

Is there a quick and easy way to clear all the records in the Northwind 2010 sample database?

Link

Why won't Access let me convert one of the 2010 web templates to the 2000-2003 MDB format?

Link

Where can I find all the Access 2010 database templates on Office.com?

Link

Are there any video tutorials available for the Access 2010 web database templates?

Link

How do I add a new report into the Report Center for the Contacts 2010 Web Template?

 

 

Back to top

 

 

See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out