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.
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.
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.
To set the default file location in Access,
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.
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
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.