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 Issues | Question |
|---|
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 Pane | Question |
|---|
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 Issues | Question |
|---|
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 Issues | Question |
|---|
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 Issues | Question |
|---|
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 Issues | Question |
|---|
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 Browser | Question |
|---|
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 Issues | Question |
|---|
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 Issues | Question |
|---|
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