Access 2007 Frequently Asked Questions (FAQ)
This page presents answers to some of the most frequently asked questions concerning Microsoft Office Access 2007. These questions are loosely organized by category.
| Application Issues | Question |
Link | Where do I find all the Access Options in Access 2007? |
Link | Where do I find the Database Properties dialog box in Access 2007? |
Link | What happened to Clippy in Access 2007? |
Link | The Home ribbon does not show the Window group on my application. How do I enable this feature? |
Link | How do I apply User Level Security to my database in Access 2007? |
Link | How do I apply Replication to my database in Access 2007? |
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 2007? |
Link | What happened to Data Access Pages? |
Link | How do you Compact and Repair a database in Access 2007? I can't find this option in the Ribbon. |
Link | Is it possible to disable Layout View for all forms and reports in my database? |
Link | Is there a tool available that can assist with building custom AutoFormats? |
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 2007? |
Back to top
Navigation Pane | Question |
| Link | What happened to the Database Window in Access 2007? |
| 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 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 2007? |
| 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? |
Back to top
Table Issues | Question |
Link | Where is the Table Wizard located in Access 2007? |
Link | How do you set up a field to accept Rich Text in Access 2007? |
Link | What happened to the AutoFill option with datasheets in Access 2007? |
Link | I cannot find the Attachment data type in table design mode. Can you tell me why? |
Back to top
| Form Issues | Question |
Link | How do you enable a form to open in Layout View? |
Link | How do I remove controls from a form control layout? |
Link | Why can't I open my form in Layout View in an Access Data Project? |
Link | How can I alternate the back color of records in a datasheet form or query? |
Link | How can I designate one form to always open when someone opens the database? |
Link | How do you set the Tab Order for controls on a form? |
Link | Can you put both a picture and text on a command button? |
Link | For click events is there a way for the wizard to create code rather than an embedded macro? |
Link | How do you remove the drop down arrows that show up with a datasheet form to filter the columns? |
Back to top
| Macro Issues | Question |
| Link | Why are my macros and VBA code not working in Access 2007? |
| Link | What happened to all the extra Macro Actions in Access 2007 such as SetValue? |
| Link | Is it possible to write code or use a macro to open the Access Options dialog box in Access 2007? |
Back to top
Report Issues | Question |
| Link | How do you enable a report to open in Layout View? |
| Link | How do I remove controls from a report control layout? |
| Link | How do I get my address field to show up in the Label Wizard in Access 2007? |
| Link | Why is the Export To Excel option not available for reports in Access 2007? |
| Link | Why can't I open my report in Layout View in an Access Data Project? |
| Link | How do you assign a report to a specific printer in Access 2007 and have it remember that setting? |
Back to top
| Template Issues | Question |
| Link | Where do I find the Northwind 2007 sample database? |
| Link | Is there a quick and easy way to clear all the records in the Northwind 2007 sample database? |
Link | Why won't Access let me convert one of the 2007 templates to the 2000-2003 MDB format? |
Link | Where can I find all the Access 2007 database templates on Microsoft Office Online? |
| Link | How can I get a report in the Charitable Contributions template of each Contributor's total donations? |
Back to top
| Ribbon Issues | Question |
| Link | Is there a graphical tool available to create and edit custom Ribbons in Access 2007? |
| Link | How do I get my existing legacy menu bars and toolbars to work in Access 2007? |
| Link | Is there any way to have names appear next to the buttons on the Quick Access Toolbar? |
Back to top
| Runtime Issues | Question |
| Link | Can I use the 2007 Package Wizard to install the data file in one location and the program file in a different location? |
| Link | Using Access 2007 Runtime, how can I create a Trusted Location if there's no UI to create it? |
| Link | Is the Access 2007 Runtime supported on 64-bit Windows Vista? |
Back to top