Access 2010 FAQ

This article contains answers to common questions pertaining to Access 2010, the latest version of Microsoft Access, a popular database and spreadsheet program that is part of the Microsoft Office suite of products.

  1. How can I learn more about Microsoft Access 2010?
  2. Is there anywhere I can watch videos with more information about Microsoft Access 2010?
  3. Is it possible for me to try Office 2010 without installing it on my computer?
  4. How can I change the default working folder in Access?
  5. What are the changes Microsoft made in Access 2010? What happened to the Office Button?
  6. Why is there no New Field button in Access 2010?

Q1: How can I learn more about Microsoft Access 2010?

If you would like to learn more about Microsoft Access 2010 please visit Lynda.com. If you are interested in access to Lynda.com please contact the Technology Help Desk at [email protected] or 563-387-1000.
top

Q2: Is there anywhere I can watch videos with more information about Access 2010?

Yes. Lynda.com is a provider of web-based software training videos and resources. If you are interested in access to Lynda.com please contact the Technology Help Desk at [email protected] or 563-387-1000.

top

Q3: Is it possible for me to try Office 2010 without installing it on my computer?

No. However, you can download Office 2010 for a 60-day free trial here
top

Q4: How can I change the default working folder in Access?

To set the default file location in Access,

  1. Click the File menu and then click Options.
  2. Click Popular.
  3. Under Creating databases, in the Default database folder box, type the path of the folder where you want to store Access database files.

This only sets the default for Access. You follow similar steps to set the default location in Excel and the other applications in the Office suite.
top

Q5: What are the changes Microsoft made in Access 2010? What happened to the Office Button?

Switching back from the Office Button of Access 2007 to the old File menu is just one of the changes Microsoft made in Access 2010. Some of the other changes and additions include a customizable Ribbon, a data type gallery with the ability to define custom data types, Themes, data/table macros, Sharepoint integration, and modular templates. For details, see Access 2010 Training
top

Q6: Why is there no New Field button in Access 2010?

The New Field button was replaced by a number of buttons in the Fields tab of the Ribbon, including individual buttons for commonly used fields such as Text, Number, and Currency. You can access more fields via the More Fields dropdown menu. At the bottom of this menu is the “Quick Start” section, which includes prepackaged combinations of fields, such as Address. You can also save custom combinations of fields for future use via this menu.
top

Read more training and instructional articles.