Access 2007, the newest version of Microsoft’s Access database software, helps you create powerful, user-friendly systems for storing, manipulating, and displaying vast amounts of information. Manage all of your data by learning to:
The
Office button is a round button with the Microsoft Office® insignia on it. Clicking it reveals commands that resided in the File menu in earlier versions of Access.
The Ribbon
The Ribbon is the core of the new Access interface. It replaces the drop-down menus and toolbars of previous versions of Access and organizes and displays the many Access commands visually. The Ribbon makes it easier for you to find and use the commands you need in order to work with your Access databases. The Ribbon is made up of tabs and groups.
Tabs
Tabs are the main organizational categories for Access functions. When you click on a tab, the functions within that tab appear on the Ribbon. Access 2007 has four main tabs:
- Home: Features many of the most popular Access commands, such as changing the overall Access view, modifying the appearance of text within database records, and creating new database records
- Create: Commands for creating database tables and forms and for generating reports based on your data
- External Data: Commands for importing data into a database from existing sources (such as Microsoft Excel® spreadsheets), exporting data to other file formats, collecting data via email, and publishing databases onto a Microsoft SharePoint® server
- Database Tools: Commands for managing existing databases and analyzing the data they contain
Contextual Tabs
Some tabs in the Ribbon appear only in certain contexts, such as once you’ve clicked on a specific command in one of the four standard Ribbon tabs. These tabs are known as
contextual tabs. For instance, when you click on the Table icon

in the Create tab, a contextual tab called Datasheet will appear in the Ribbon that provides various commands for entering and managing table data.
Groups
The functions displayed within each tab are further organized into smaller groups. For instance, the Create tab has the groups Tables, Forms, Reports, and Other. Some groups have a little square at their bottom right, called a dialog box launcher (or launcher for short). Clicking the launcher pops up a dialog box that gives you access to more commands in the category that the group covers.
Quick Access Toolbar
The
Quick Access Toolbar spans the top of the Access window and contains the commands you use most often, such as Save, Undo, and Redo. It’s visible no matter what tab you’ve selected. You can customize the commands that appear on the toolbar by selecting a command from the menu that appears when you click on the down arrow

at the toolbar’s right.
Help
You can display Access’s built-in help system through the Help button

or by pressing F1 on your keyboard.
The Access Work Area
The Access 2007 work area is the main part of the Access user interface, in which you create
database objects and enter data. Access 2007’s interface works a bit differently from that of previous versions. It has three main parts:
- Navigation pane: The Navigation pane lets you access the various components of your database in order to enter or edit data or perform other commands. If you don’t see the Navigation pane right away, it might be minimized (hidden). To view it, click on the words “Navigation pane” shown vertically at the far left side of the Access work area. For more on the Navigation pane, see How to Navigate Access Datasheets.
- Document pane: The portion of the work area below the Ribbon and to the right of the Navigation pane. You can use the document pane to enter data into tables, create forms, build queries, view reports, and so on.
- Document tabs: Clicking on these tabs lets you switch among open objects in a database instantly.
System Requirements:
| Computer and processor |
500 megahertz (MHz) processor or higher is required for Microsoft Access 2007. |
| Memory |
256 megabyte (MB) RAM or higher is recommended for Access 2007. |
| Hard disk |
Before you download Microsoft Access 2007, be sure you have 1.5 gigabyte (GB) of free space available; a portion of this disk space will be freed after installation if the original Access 2007 download package is removed from the hard drive |
| Drive |
A CD-ROM or DVD drive is necessary for Access 2007 |
| Display |
A 1024x768 or higher resolution monitor is recommended for optimum viewing of your Access 2007 download. |
| Operating system |
Microsoft Access 2007 will work best with: Microsoft Windows XP with Service Pack (SP) 2, Windows Server(R) 2003 with SP1, or later operating system. |
| Other |
Connectivity to Microsoft Windows Server 2000 or later is required for certain advanced functionality in Outlook 2007. Connectivity to Microsoft Windows Server 2003 with SP1 or later running Microsoft Windows SharePoint Services is required for certain advanced collaboration functionality. Microsoft Office SharePoint Server 2007 is required for certain advanced functionality. Access Slide Library requires Office SharePoint Server 2007. Microsoft Internet Explorer 6.0 or later, 32 bit browser only. Microsoft Access 2007 internet functionality requires Internet access (fees may apply). * Instant Search requires Microsoft Windows Desktop Search 3.0. |
| Additional |
Actual requirements for Access 2007 functionality may vary based on your system configuration and operating system. A complete list of Access 2007 requirements are available at: http://www.microsoft.com/office/products. |
eBay and Microsoft rules require us to make the following disclaimer:
This is a retail-boxed academic version and can only be used for academic purposes. This product can only be sold to students, Educational Institutions, Administrative Offices, Boards of Education, Public Libraries, and Public Museums. Students are limited to 1 copy of each product per calendar year. Students must supply a signed purchase order. In lieu of the above, you may also provide the name of the school you are currently attending.
Please include this in the message section with your PayPal payment.
Purchase of this product through BUY IT NOW means that you agree and full understand this disclaimer and that you are eligible and qualify to meet the academic requirements as described in this disclaimer.