HX10214526Help and How-to for Microsoft Office Access 2007
http://office.microsoft.com/en-us/access/FX100646911033.aspx
Get Help and How-to for Microsoft Office Access 2007en-ushttp://office.microsoft.com/global/images/default.aspx?AssetID=ZA102537291033
http://office.microsoft.com/en-us/default.aspx
Office Online16536AutoTab PropertyThe AutoTab property is useful for specifying if an automatic tab occurs when the last character permitted by a text box control's input mask is entered. Learn more about the AutoTab property setting and find out if setting the focus to move to the next control in a form's tab order would be helful in your database.http://office.microsoft.com/en-us/access/HA012327211033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSBack up a databaseUse this process to guard against data loss and protect your investment in your database design.http://office.microsoft.com/en-us/access/HA102355861033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSHelp Access run fasterBy following these tips, you can help speed up many of the Access database operations, such as running reports or opening forms that are based on complex queries.http://office.microsoft.com/en-us/access/HA102355891033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSExport contacts to an Outlook address bookAccess 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.http://office.microsoft.com/en-us/access/HA102820741033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSTop tips for Access 2007No matter how long you've worked with Access, there are always a few more tips to learn. Read this article to learn more.http://office.microsoft.com/en-us/access/HA102618881033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSCustomer case study: Moving from Excel to AccessIs your data getting harder to manage in an Excel workbook? Hear the experiences of one organization as they moved their data into Access.http://office.microsoft.com/en-us/access/HA102786861033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSWatch this: Add attachments to records in a formWatch this video to learn how you can attach documents to records in your database.http://office.microsoft.com/en-us/access/HA103359561033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSCreate charts and graphs in Access 2007 (Non-Microsoft site)Read about how one Access expert likes to creates charts.http://office.microsoft.com/en-us/access/XT103574981033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSWatch this: Change the data type of a table fieldWatch this video on how to change the data type of a table field from the Datasheet view.http://office.microsoft.com/en-us/access/HA102882571033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSUse a query as the record source for a form or reportLearn about what you need to consider before using a query as a record source.http://office.microsoft.com/en-us/access/HA100963181033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSCreate and use a switchboardLearn how to create and manage a switchboard in your Access database.http://office.microsoft.com/en-us/access/HA012138761033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSWatch this: Use the Projects database templateWatch this video and start using the Projects database template to manage your projects.http://office.microsoft.com/en-us/access/HA103567291033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSControl data entry formats with input masksHelp make your database easier to manage by defining how users must enter data in specific fields.http://office.microsoft.com/en-us/access/HA100964521033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSSpecify how data displays by using predefined formatsLearn how to use predefined formatting options to enhance the way your data appears in a table or form.http://office.microsoft.com/en-us/access/HA012330611033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSCreate or remove a primary keyWant to know how and why to use primary keys? Read this article and find out.http://office.microsoft.com/en-us/access/HA100140991033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSCrew interview: in the Dev KitchenWatch this interview with Access Senior Program Manager Clint Covington to learn more about the Access developer kitchen.http://office.microsoft.com/en-us/access/HA103543871033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSRoadmap to creating a formRead this article to learn the ins and outs of creating a form in Access.http://office.microsoft.com/en-us/access/HA102875161033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSSpecify how data displays by using custom formattingLearn how to make data in a field appear in a specific format by using custom formatting.http://office.microsoft.com/en-us/access/HA103346451033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSArchive Access dataKeep your data organized by periodically archiving old or inactive records.http://office.microsoft.com/en-us/access/HA102882591033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSDemo: Merge Access data with WordLearn how to use the Mail Merge Wizard to merge Access data with a Word document.http://office.microsoft.com/en-us/access/HA102852191033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSCreate a macro that runs when you open a databaseDo you want to perform a set of actions every time your database starts? Save time and create a macro to do it automatically.http://office.microsoft.com/en-us/access/HA103362391033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSSet the default form that appears when you open a databaseSave time. Learn how to have the same form open automatically every time that you open your database.http://office.microsoft.com/en-us/access/HA102875181033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSWatch this: Highlight values on a report by using conditional formattingWatch this demo and learn how to use conditional formatting to draw attention to particular values.http://office.microsoft.com/en-us/access/HA102852161033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSEncrypt a database by using a database passwordFind out how to help secure your data by preventing unauthorized use of an Access database.http://office.microsoft.com/en-us/access/HA100962991033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSCreate a form by using the Multiple Items toolLearn how to create a form that shows many records at once.http://office.microsoft.com/en-us/access/HA102864661033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSSet the tab order for controlsOn a form, you can control where the "focus" moves each time that you press the TAB key. Read this article to find out how.http://office.microsoft.com/en-us/access/HA102852171033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSAdd a total or other aggregate to a reportAccess 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.http://office.microsoft.com/en-us/access/HA101208541033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSCreate a form by using the Blank Form toolAccess 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.http://office.microsoft.com/en-us/access/HA102864821033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSWhich view should I use: Layout view or Design view?Layout view and Design view provide different tools for creating forms and reports. Learn the differences by reading this article.http://office.microsoft.com/en-us/access/HA102864831033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSSWatch this: Make it easier to add a dateWatch this demo to learn how the date picker can streamline the entry of dates.http://office.microsoft.com/en-us/access/HA102835451033.aspx?CTT=4&Origin=EC102145231033&WT.mc_id=RSS