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 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 IssuesQuestion

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

 

 

Query Issues

Question

Link

How do you clear the query grid in Access 2007?

 

 

Back to top

 

 

Form IssuesQuestion

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?

Link

Is there a way to select all values in a multi-value combo box control?

Link

Why do I not see the new Date Picker control next to my date field?

 

 

Back to top

 

 

Switchboard IssuesQuestion

Link

How do I make the Switchboard form close both the database and Access?

Link

How do I allow more than eight items on a Switchboard page in Access 2007?

 

 

Back to top

 

 

Macro IssuesQuestion
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 IssuesQuestion
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 IssuesQuestion
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 IssuesQuestion
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

 
 

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