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 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 - Saturday, May 16, 2009

 

Export contacts to an Outlook address book:
http://office.microsoft.com/en-us/access/HA102820741033.aspx
Access and Outlook are both excellent programs for managing your personal and business contacts. As a result, you might find yourself wanting to export contact data from Access to Outlook.

Top tips for Access 2007:
http://office.microsoft.com/en-us/access/HA102618881033.aspx
No matter how long you've worked with Access, there are always a few more tips to learn. Read this article to learn more.

Customer case study: Moving from Excel to Access:
http://office.microsoft.com/en-us/access/HA102786861033.aspx
Is your data getting harder to manage in an Excel workbook? Hear the experiences of one organization as they moved their data into Access.

Watch this: Add attachments to records in a form:
http://office.microsoft.com/en-us/access/HA103359561033.aspx
Watch this video to learn how you can attach documents to records in your database.

Create charts and graphs in Access 2007 (Non-Microsoft site):
http://office.microsoft.com/en-us/access/XT103574981033.aspx
Read about how one Access expert likes to creates charts.

Watch this: Change the data type of a table field:
http://office.microsoft.com/en-us/access/HA102882571033.aspx
Watch this video on how to change the data type of a table field from the Datasheet view.
 
 
Release Date - Thursday, March 19, 2009

Use a query as the record source for a form or report:
http://office.microsoft.com/en-us/access/HA100963181033.aspx
Learn about what you need to consider before using a query as a record source.

Create and use a switchboard:
http://office.microsoft.com/en-us/access/HA012138761033.aspx
Learn how to create and manage a switchboard in your Access database.

Watch this: Use the Projects database template:
http://office.microsoft.com/en-us/access/HA103567291033.aspx
Watch this video and start using the Projects database template to manage your projects.
 
 
Release Date - Monday, February 23, 2009

Control data entry formats with input masks:
http://office.microsoft.com/en-us/access/HA100964521033.aspx
Help make your database easier to manage by defining how users must enter data in specific fields.

Specify how data displays by using predefined formats:
http://office.microsoft.com/en-us/access/HA012330611033.aspx
Learn how to use predefined formatting options to enhance the way your data appears in a table or form.

Create or remove a primary key:
http://office.microsoft.com/en-us/access/HA100140991033.aspx
Want to know how and why to use primary keys? Read this article and find out.
 
 
Release Date - Tuesday, February 10, 2009

Crew interview: in the Dev Kitchen:
http://office.microsoft.com/en-us/access/HA103543871033.aspx
Watch this interview with Access Senior Program Manager Clint Covington to learn more about the Access developer kitchen.

Roadmap to creating a form:
http://office.microsoft.com/en-us/access/HA102875161033.aspx
Read this article to learn the ins and outs of creating a form in Access.

Specify how data displays by using custom formatting:
http://office.microsoft.com/en-us/access/HA103346451033.aspx
Learn how to make data in a field appear in a specific format by using custom formatting.
 
 
Release Date - Tuesday, January 27, 2009

Archive Access data:
http://office.microsoft.com/en-us/access/HA102882591033.aspx
Keep your data organized by periodically archiving old or inactive records.

Demo: Merge Access data with Word:
http://office.microsoft.com/en-us/access/HA102852191033.aspx
Learn how to use the Mail Merge Wizard to merge Access data with a Word document.

Create a macro that runs when you open a database:
http://office.microsoft.com/en-us/access/HA103362391033.aspx
Do you want to perform a set of actions every time your database starts? Save time and create a macro to do it automatically.
 
 
Release Date - Tuesday, January 13, 2009

Set the default form that appears when you open a database:
http://office.microsoft.com/en-us/access/HA102875181033.aspx
Save time. Learn how to have the same form open automatically every time that you open your database.

Watch this: Highlight values on a report by using conditional formatting:
http://office.microsoft.com/en-us/access/HA102852161033.aspx
Watch this demo and learn how to use conditional formatting to draw attention to particular values.
 
 
Release Date - Thursday, January 1, 2009
 
Create a form by using the Multiple Items tool:
http://office.microsoft.com/en-us/access/HA102864661033.aspx
Learn how to create a form that shows many records at once.

Set the tab order for controls:
http://office.microsoft.com/en-us/access/HA102852171033.aspx
On a form, you can control where the "focus" moves each time that you press the TAB key. Read this article to find out how.

Add a total or other aggregate to a report:
http://office.microsoft.com/en-us/access/HA101208541033.aspx
Access reports are great tools for summarizing data. This article shows you how easy it is to add totals, averages, and other aggregates to a report.
 
 
Release Date - Tuesday, December 16, 2008

Create a form by using the Blank Form tool:
http://office.microsoft.com/en-us/access/HA102864821033.aspx
Access provides several different tools for creating forms with the controls already in place. Use the Blank Form tool if you'd rather add the controls yourself.

Which view should I use: Layout view or Design view?:
http://office.microsoft.com/en-us/access/HA102864831033.aspx
Layout view and Design view provide different tools for creating forms and reports. Learn the differences by reading this article.
 
 
Release Date - Friday, November 21, 2008
 
Install updates for Microsoft Office 2007 Help:
http://office.microsoft.com/en-us/access/HA102882051033.aspx
Make sure you have the latest Help articles by downloading and installing updated Help files. Click this link to learn more.
 
Add a field to a table:
http://office.microsoft.com/en-us/access/HA100728831033.aspx
Fields are the basic units of storage in a database, and come in a variety of types, such as Date/Time, Text, or Number. Read this article to learn more about creating fields.
 
Prevent duplicate values in a field:
http://office.microsoft.com/en-us/access/HA102833171033.aspx
Find out how you can ensure that each value in a field is unique.
 
 
Release Date - Monday, November 3, 2008
 
Create a form by using the Form tool:
http://office.microsoft.com/en-us/access/HA102864651033.aspx
The Form tool gives you a quick way to create a form that displays a single record at a time. See how it's done by reading this article.
 
Move and resize controls independently:
http://office.microsoft.com/en-us/access/HA102868491033.aspx
Access 2007 uses layouts to align controls on forms and reports. However, sometimes you just want to move a control without affecting the others. This article shows you how.
 
Require a value in a field:
http://office.microsoft.com/en-us/access/HA102831881033.aspx
Sometimes, an empty field just won't do. Read this article to see how you can ensure that a value is entered for each record.
 
 
Release Date - Tuesday, October 21, 2008
 
Select data by using a query:
http://office.microsoft.com/en-us/access/HA102851001033.aspx
You can use queries to look at subsets of data, and to review and summarize data from multiple tables. Read this article to learn how to create a simple select query.
 
Make summary data easier to read by using a crosstab query:
http://office.microsoft.com/en-us/access/HA102295771033.aspx
Crosstab queries provide a powerful way to summarize data by multiple values, and are similar in many ways to PivotTables in Excel. This article shows you how to get started using crosstab queries.
 
Automatically align controls on a form:
http://office.microsoft.com/en-us/access/HA102864471033.aspx
Trying to figure out how to align controls on forms and reports? This article shows you how layouts can make the job easier.

 
Release Date - Monday, October 06, 2008
 
Validation rules:
http://office.microsoft.com/en-us/access/HA102855321033.aspx
Incorrectly-entered data can cause problems in any database. In this article, Access MVP Allen Browne shows you how validation rules help you keep the bad data out.

Add records to a table by using an append query:
http://office.microsoft.com/en-us/access/HA100765261033.aspx
If you have existing data that you want to add to a table, an append query can do it quickly and accurately.

Administer ODBC data sources:
http://office.microsoft.com/en-us/access/HA102755501033.aspx
Open Database Connectivity (ODBC) is a protocol that you can use to connect an Access database to an external data source such as Microsoft SQL Server. Learn how to manage ODBC data sources by reading this article.
 

Release Date - Tuesday, September 23, 2008
 
Relationships between tables:
http://office.microsoft.com/en-us/access/HA102776121033.aspx
Designing a useful database is all about creating the right relationships. Access MVP Allen Browne presents an example in this article.

Create a tabbed form:
http://office.microsoft.com/en-us/access/HA102776131033.aspx
Learn how to organize the controls on a form by using the Tab control.

Watch this: Create a tabbed form:
http://office.microsoft.com/en-us/access/HA102859411033.aspx
Looking for a video demo to help you add the Tab control to a form? Click this link.
 
 
Release Date - Tuesday, August 26, 2008
 
Create Access forms and reports from a SharePoint list:
http://office.microsoft.com/en-us/access/HA102093061033.aspx
You may already know that you can create Access forms and reports from a SharePoint list, but did you know that you can then make those forms and reports available on the SharePoint View menu?

Top tips for Access 2007:
http://office.microsoft.com/en-us/access/HA102618881033.aspx
No matter how long you've worked with Access, there are always a few more tips to learn. Read this article to learn more.

Customer case study: Moving from Excel to Access:
http://office.microsoft.com/en-us/access/HA102786861033.aspx
Is your data getting harder to manage in an Excel workbook? Hear the experiences of one organization as they moved their data into Access.
 
 
Release Date - Tuesday, August 26, 2008
 
Learn to think relationally:
http://office.microsoft.com/en-us/access/HA102758131033.aspx
Relational databases such as Access can help you store and retrieve data very efficiently, provided that you plan the tables correctly. Access MVP Allen Browne explains in this article.

Move Access data to a SQL Server database by using the Upsizing Wizard:
http://office.microsoft.com/en-us/access/HA102755371033.aspx
Storing your data in a SQL Server database can help improve the performance and scalability of your Access application. Read this article to learn how to use the SQL Server Upsizing Wizard.

Ways to share an Access database:
http://office.microsoft.com/en-us/access/HA102791591033.aspx
Want to make your database available for use by others in your workgroup? This new article shows you several techniques you can use.

Update data by using a query:
http://office.microsoft.com/en-us/access/HA100765271033.aspx
If you need to make the same change to many records in your database, an update query might be the best tool for the job.

Access SQL: Basic concepts, vocabulary, and syntax:
http://office.microsoft.com/en-us/access/HA102564021033.aspx
Knowledge of Structured Query Language (SQL) is not required to use Access, but knowing the basics can help you build a more powerful database.

Create custom menus and shortcut menus by using macros:
http://office.microsoft.com/en-us/access/HA102825091033.aspx
Create menus that contain only the commands you want. This new article shows you how.
 
 
Release Date - Monday, July 28, 2008
 
Create a form that contains a subform (a one to many form):
http://office.microsoft.com/en-us/access/HA100986741033.aspx
Looking for a good overview of adding subforms to forms? This article explains the basics, and provides a couple of video demos as well.

Customize how data is displayed by creating a lookup field:
http://office.microsoft.com/en-us/access/HA102565381033.aspx
Lookup fields let you quickly select a value from a predefined list. Read this article to learn how to create and modify these handy fields.

Add and customize date and time formats:
http://office.microsoft.com/en-us/access/HA100781081033.aspx
Storing and formatting dates and times are common tasks in any database. Get the details on how it's done.
 
 
Release Date - Monday, July 14, 2008
 
Why does Access want me to enter a parameter value?
http://office.microsoft.com/en-us/access/HA102743771033.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
 
 
 
Release Date - Friday, December 14, 2007
 

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
 
 

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.