Access 2007 Help Topics
This page lists new and revised Help topics about Microsoft Office Access 2007 on Office Online
This Help topic is a good starting point - Help and How-to for Microsoft Office Access 2007:
http://office.microsoft.com/en-us/access/FX100646911033.aspx
Release Date - Monday, July 14, 2008
Why does Access want me to enter a parameter value?
http://office.microsoft.com/en-us/access/HA102549011033.aspx
Sometimes, changes to database objects can result in unwanted prompts that ask for a parameter value. Read this article to find out why they appear, and learn how to look for the cause of the problem.
Demo: Set the relationship between two tables:
http://office.microsoft.com/en-us/access/HA102549011033.aspx
Table relationships help you keep data organized across multiple tables. This new demo explains what they are and how to set them up.
Watch this: Create a subform by using the Subform Wizard:
http://office.microsoft.com/en-us/access/HA102786481033.aspx?
Subforms let you display a record and its related records together on one form. The Subform Wizard walks you through the process, as shown in this short demo.
Release Date - Tuesday, July 01, 2008
Locate specific records in a database:
http://office.microsoft.com/en-us/access/HA101153261033.aspx
The larger your database, the harder it gets to find the data you need. Read this article to get tips on locating records quickly.
Set the field size:
http://office.microsoft.com/en-us/access/HA102747161033.aspx
Make sure your fields can accommodate the data that you want to store. This article gives you the details.
Document and print your database design:
http://office.microsoft.com/en-us/access/HA102706681033.aspx
Good database documentation helps you and others understand the structure of your database. Learn how to use the documentation features of Access by reading this article.
Release Date - Thursday, June 19, 2008
Demo: Add or remove controls from a layout:
http://office.microsoft.com/en-us/access/HA102765511033.aspx
Layouts help you quickly align and format data on forms and reports. Watch this short demo to see how to add or remove controls from layouts.
Demo: Create a form that contains a subdatasheet:
http://office.microsoft.com/en-us/access/HA102774071033.aspx
A subdatasheet lets you work with a lot of data in a compact space. See how to add one to a form.
Demo: Create a subform by dragging one form onto another form:
http://office.microsoft.com/en-us/access/HA102774091033.aspx
If you have two existing forms that show related data, you can drag one onto the other to create a subform. In this demo, you can see how it's done.
Release Date - Monday, June 02, 2008
Set name AutoCorrect options:
http://office.microsoft.com/en-us/access/HA102564131033.aspx
The name AutoCorrect feature helps keep your database operating correctly, even after you rename an object. Read this article to learn how to set the options for this feature.
Add a subdatasheet:
http://office.microsoft.com/en-us/access/HA102668001033.aspx
Learn how to create a subdatasheet by embedding one datasheet in another.
Watch this: Specify criteria for a text field:
http://office.microsoft.com/en-us/access/HA102565051033.aspx
Watch this new demo to see how you can limit the results of your query based on the value of a text field.
Release Date - Tuesday, May 20, 2008
Demo: Select the right form view:
http://office.microsoft.com/en-us/access/HA102549081033.aspx
Choosing the right form view can greatly impact the effectiveness of presenting your data. Watch this demo to get some tips.
Stop disabled mode from blocking a query:
http://office.microsoft.com/en-us/access/HA102564031033.aspx
See how you can enable database content that has been blocked by the security features of Access.
Decide whether to trust a database:
http://office.microsoft.com/en-us/access/HA102564121033.aspx
Learn more about the security features of Access, and how to determine if a database is trustworthy.
Release Date - Monday, May 05, 2008
Make your queries interactive by using parameters:
http://office.microsoft.com/en-us/access/HA100963141033.aspx
New video demos in this article help clarify how to add parameters to queries.
Refresh or requery data
http://office.microsoft.com/en-us/access/HA102564001033.aspx
If another person or process changes the data you're working with, you might want to refresh your view. Read this article to learn how.
Demo: Use the Expression Builder
http://office.microsoft.com/en-us/access/HA102549021033.aspx
The Expression Builder helps you create calculated fields and controls with a minimum of fuss. Watch this demo to see how it works.
Release Date - Monday, April 21, 2008
Hide VBA code from users:
http://office.microsoft.com/en-us/access/HA102395571033.aspx
Learn how to lock down an Access database to prevent users from making design changes.
Split a database:
http://office.microsoft.com/en-us/access/HA102400961033.aspx
Improve the flexibility and maintainability of your database by splitting it into a front-end/back-end configuration.
Watch this: Make a query ask for input:
http://office.microsoft.com/en-us/access/HA102563981033.aspx
Get more out of a query by entering new parameters each time you run it.
Release Date - Tuesday, April 08, 2008
Watch this: Make a control move as you resize a form:
http://office.microsoft.com/en-us/access/HA102565391033.aspx
Want that command button to always stick to the bottom right corner of a form? Watch this short demo to learn how.
Store the date and time when a record is modified:
http://office.microsoft.com/en-us/access/HA102412841033.aspx
Timestamps help you determine whether your data is up-to-date. This new article shows you how to add them.
Remove a subdatasheet:
http://office.microsoft.com/en-us/access/HA102565411033.aspx
Access creates subdatasheets by default in many cases, but you can remove them if you want.
Release Date - Monday, March 24, 2008
Demo: Bring your business data together in an Access database:
http://office.microsoft.com/en-us/access/HA102552031033.aspx
Access can help you integrate data from a variety of sources. See how it works by watching this demo.
Selecting and using the Access 2007 templates:
http://office.microsoft.com/en-us/access/HA102515841033.aspx
Access templates can help you build complete databases with just a few clicks. Learn how to select the one you want.
Run an Access macro by using a keyboard shortcut:
http://office.microsoft.com/en-us/access/HA102391111033.aspx
Make macros more accessible by assigning them to key combinations.
Release Date - Tuesday, March 11, 2008
Demo: Make a text box grow or shrink as you resize a form:
http://office.microsoft.com/en-us/access/HA102549791033.aspx
In Access 2007, controls can be configured to adjust their size as you resize the form. See how it's done.
Demo: Display a form and its datasheet simultaneously:
http://office.microsoft.com/en-us/access/HA102549001033.aspx
Split forms give you more flexibility in how you display your data. This demo shows you how they work.
Demo: Enable database content:
http://office.microsoft.com/en-us/access/HA102565031033.aspx
Some of the content in your database might be disabled by default. See how to enable it by watching this short demo.
Release Date - Tuesday, February 26, 2008
Help prevent and correct database file problems by using Compact and Repair
http://office.microsoft.com/en-us/access/HA102355831033.aspx
Keep your database in good shape by using the Compact and Repair command.
Restore a database
http://office.microsoft.com/en-us/access/HA102355881033.aspx
Rest assured! In the event of problems with your database, you can restore part or all of it if you have a backup copy.
Undo and redo typing
http://office.microsoft.com/en-us/access/HA102297091033.aspx
Learn how to use the improved Undo and Redo commands in Access 2007.
Release Date - Monday, February 11, 2008
Change the default folder for storing databases
http://office.microsoft.com/en-us/access/HA102327641033.aspx
You can specify which folder Access uses to store new databases. Read this article to learn how.
Help Access run faster
http://office.microsoft.com/en-us/access/HA102355891033.aspx
Learn tips that can help speed up database operations such as running reports or opening forms.
Link an Access 2007 database to a database that contains data access pages
http://office.microsoft.com/en-us/access/HA102414541033.aspx
Access 2007 doesn't support data access pages, but you can still link to databases that contain them.
Release Date - Tuesday, January 29, 2008
Modify a report:
http://office.microsoft.com/en-us/access/HA100141171033.aspx
Learn how to add such things as page numbers, line numbers, and logos to a report.
Demo: Collect data in Access 2007 by using e-mail
http://office.microsoft.com/en-us/access/HA102527131033.aspx
Take the pain out of data collection--let Access and Microsoft Outlook do the work for you!
Create a text box that looks up a value in a table
http://office.microsoft.com/en-us/access/HA102358561033.aspx
Display a value from a table or query other than the one that your form is bound to.
Release Date - Tuesday, January 15, 2008
Process SQL on a database server by using a pass-through query:
http://office.microsoft.com/en-us/access/HA102064881033.aspx
Combine text values by using an expression:
http://office.microsoft.com/en-us/access/HA102358511033.aspx
Back up a database:
http://office.microsoft.com/en-us/access/HA102355861033.aspx
Release Date - Friday, December 14, 2007
Introduction to queries:
http://office.microsoft.com/en-us/access/HA102098921033.aspx
Create an expression:
http://office.microsoft.com/en-us/access/HA101061751033.aspx
Create a control that references a control on another form:
http://office.microsoft.com/en-us/access/HA102358541033.aspx
Release Date - Monday, December 03, 2007
Help secure an Access 2007 database:
http://office.microsoft.com/en-us/access/HA012301871033.aspx
Learn how to use the new security features in Access 2007.
Demo: Use control layouts on forms and reports:
http://office.microsoft.com/en-us/access/HA102374121033.aspx
See a video demo about how to format data on forms and reports.
Access Glossary:
http://office.microsoft.com/en-us/access/HA102182021033.aspx
Bookmark this glossary so that it's handy when you need it.
Release Date - Monday, November 19, 2007
What happened to data access pages?
http://office.microsoft.com/en-us/access/HA100308321033.aspx
Learn how to use Access 2007 to work with a database that contains data access pages.
Make a database easier to use by customizing and controlling the Navigation Pane.
http://office.microsoft.com/en-us/access/HA102345601033.aspx?pid=CH100645691033
Improve the usability of your database by customizing and controlling the Navigation Pane.
Show or hide the Navigation Pane
http://office.microsoft.com/en-us/access/HA102357171033.aspx
Keep the Navigation Pane visible when you need it.
Release Date - Saturday, November 3, 2007
Show trust by adding a digital signature:
http://office.microsoft.com/en-us/access/HA102345621033.aspx
View and manage objects by using the Navigation Pane:
http://office.microsoft.com/en-us/access/HA012138791033.aspx
Use the Expression Builder:
http://office.microsoft.com/en-us/access/HA102369491033.aspx
Release Date - Tuesday, October 23, 2007
Exploring a desktop Access 2007 database
http://office.microsoft.com/en-us/access/HA102326851033.aspx
To navigate more precisely through the database management system, gain a better understanding of how the main components of Access are related.
What happened to user-level security?
http://office.microsoft.com/en-us/access/HA102345611033.aspx
Find out the best way to manage user-level security for the new, unsupported file formats.
Add a date or time stamp to new records
http://office.microsoft.com/en-us/access/HA102358491033.aspx
Learn how to add date and time information automatically when new files are added to your database.
Release Date - Monday, October 08, 2007
Interactive: Access 2003 to Access 2007 command reference guide.
http://office.microsoft.com/search/redir.aspx?AssetID=HA102388991033
Locate your favorite Access 2003 commands in Access 2007 by using this interactive reference guide.
Convert an Access 2007 database to an earlier file format
http://office.microsoft.com/search/redir.aspx?AssetID=HA102308221033
Read this if you are considering converting your database to an earlier version of Access.
Bypass startup options when you open a database
http://office.microsoft.com/search/redir.aspx?AssetID=HA102269961033
Learn to reset startup settings that might be denying you full access to a database.
Explore the Access Developer Portal
http://office.microsoft.com/search/redir.aspx?AssetID=XT102273081033
Getting comfortable working with macros, functions, and event procedures? Get more information about creating database solutions at the Access Developer Portal.
Release Date - Thursday, October 04, 2007
Track and view version information for SharePoint list items
http://office.microsoft.com/search/redir.aspx?AssetID=HA102093051033
If you're linking to data in a Microsoft Windows SharePoint Services 3.0 list, you can track versions of the items in the list. Find out how by reading this article.
Compare two tables and find only matching data
http://office.microsoft.com/search/redir.aspx?AssetID=HA10205130103
You can create a query that finds only the matching data in two tables. This article shows you two different ways of getting the job done.
Design great looking forms using Access 2007
http://office.microsoft.com/search/redir.aspx?AssetID=HA102190041033
Learn how to create professional and attractive Access forms in this excerpt from the new book, "Microsoft Office Access 2007 Plain & Simple."
Import an Access 2.0 database into an Access 2007 file
http://office.microsoft.com/search/redir.aspx?AssetID=HA102066241033
If you use an existing database in the Access 2.0 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb).
Compare two tables and find records without matches
http://office.microsoft.com/search/redir.aspx?AssetID=HA102051321033
This article shows you how to use the Find Unmatched Query Wizard, how to modify the wizard output, and how to create your own query to find unmatched records.
Guide to designing reports
http://office.microsoft.com/search/redir.aspx?AssetID=HA102056141033
Learn the basics of designing reports in Microsoft Office Access 2007, and get tips for formatting different data types.
Distribute a report electronically
http://office.microsoft.com/search/redir.aspx?AssetID=HA102063201033
Save time and paper by distributing reports in an electronic format, such as PDF, Snapshot, or XPS.
Create or modify tables or indexes by using a data-definition query
http://office.microsoft.com/search/redir.aspx?AssetID=HA102061121033
Data-definition queries are a powerful tool for creating tables, indexes, constraints, and relationships. Read this article to learn more.
Move the tables in an Access database to a SharePoint site and link to them
http://office.microsoft.com/search/redir.aspx?AssetID=HA101314681033
Learn how to share and manage data from your Microsoft Office Access 2007 database through a Microsoft Windows SharePoint Services site.
Change the appearance of a control by using conditional formatting
http://office.microsoft.com/search/redir.aspx?AssetID=HA102081331033
Sometimes it can be difficult to find specific information on forms and reports. Learn how conditional formatting can make the important data stand out in your forms and reports.
Create and use subreports
http://office.microsoft.com/search/redir.aspx?AssetID=HA102092811033
Have you ever needed to display related information that is stored in separate tables or queries in one report? Using a subreport may be your solution.
Save the results of a select query
http://office.microsoft.com/search/redir.aspx?AssetID=HA102051331033
Learn how to save the results of a select query so that you can share a copy of that data.
Preview and print database objects
http://office.microsoft.com/search/redir.aspx?AssetID=HA012141751033
Learn about the preview and print options in Access 2007, and how to print all or selected records.
Add a custom title or icon to a database
http://office.microsoft.com/search/redir.aspx?AssetID=HA102270581033
Make it easier for users to identify your database by customizing it with a meaningful title or icon.
Insert page numbers into a form or report
http://office.microsoft.com/search/redir.aspx?AssetID=HA100962811033
Tired of trying to organize your reports or forms? Adding page numbers might be your solution.
Demo: Meet the Navigation Pane
http://office.microsoft.com/search/redir.aspx?AssetID=HA102374621033
Watch this demo for a quick look at the improved database management options in Access 2007.
Automate applications with macros in Access 2007
http://office.microsoft.com/search/redir.aspx?AssetID=HA102326831033
Use macros to automate responses to events without the pressure of learning a programming language.
Create an Access 2007 database using templates
http://office.microsoft.com/search/redir.aspx?AssetID=HA102326861033
Looking for some quick and creative options for creating a new database? See how templates can help.
6 ways to get ready for Access 2007
http://office.microsoft.com/search/redir.aspx?AssetID=HA102268881033
Read these tips from experts on Access 2007.
Export a database object to another Access database
http://office.microsoft.com/search/redir.aspx?AssetID=HA012276591033
Learn how exporting is much more than just another option to copy objects from one database to another.
Format the data in tables
http://office.microsoft.com/search/redir.aspx?AssetID=HA012330611033
Read this article to understand how to use enhanced formatting options to display information more effectively.
Introduction to the Access 2007 file format
http://office.microsoft.com/search/redir.aspx?AssetID=HA100678311033
This article provides an overview of the new features in the Access 2007 file format and addresses related file type changes. In addition, it covers file format issues that occur when converting to earlier file formats.
Make summary data easier to read by using a crosstab query
http://office.microsoft.com/search/redir.aspx?AssetID=HA102295771033
Learn how to use a crosstab query to restructure summary data in a format that is easier to read and understand.
Build forms in Access 2007 using design tools
http://office.microsoft.com/search/redir.aspx?AssetID=HA102326841033
Enhance your forms with the handy power of design tools.
Create a simple report by formatting a datasheet
http://office.microsoft.com/search/redir.aspx?AssetID=HA102097921033
Consider this solution when you need an instant and simple report.
Introduction to expressions
http://office.microsoft.com/search/redir.aspx?AssetID=HA102330311033
Get to know how and where expressions can be helpful.
Back to top