Microsoft Access 2007

• Microsoft Access 2007 Level 1 (pdf)
• Microsoft Access 2007 Level 2 (pdf)
• Microsoft Access 2007 Level 3 (pdf)
• Microsoft Access 2007 Level 4 (pdf)

Microsoft Access 2003

• Microsoft Access 2003 Level 1 (pdf)
• Microsoft Access 2003 Level 2 (pdf)
• Microsoft Access 2003 Level 3 (pdf)
• Microsoft Access 2003 Level 4 (pdf)

Each course is a full day training event starting at 9am and ending at 4 pm.

Click here to see our upcoming schedule

You will learn to use Microsoft Access with confidence

Office Access 2007 provides a completely new experience with the Office Fluent user interface, new navigation pane, and tabbed window views. Even with no database experience, any user can start tracking information and creating reports to make more informed decisions.

With a rich library of prebuilt solutions, you can start tracking your information immediately. Forms and reports are already built for your convenience, but you can easily customize them to meet your business needs. Contacts, issue tracking, project tracking, and asset tracking are only few of the out-of-the-box solutions included in Office Access 2007.

Creating a report in Office Access 2007 is truly a “what you see is what you get” (WYSIWYG) experience. You can modify a report with real-time visual feedback and save various views for different audiences. The new grouping pane and filtering and sorting capabilities help you display the information so you can make more informed business decisions. Learn all about reports with Microsoft Access training in Boise Idaho.

With automatic data type detection, table creation in Office Access 2007 is as easy as working with a Microsoft Office Excel table. Type your information and Office Access 2007 will recognize whether it is a date, currency, or another common data type. You can even paste an entire Excel table into Office Access 2007 to begin tracking the information with the power of a database.

Office Access 2007 enables new field types such as attachments and multivalue fields. You can now attach any document, image, or spreadsheet to any record in your application. With the multivalue field, you can now select more than one value (for example, assign a task to more than one person) in each cell.

With Office Access 2007, you can create forms using Microsoft Office InfoPath 2007 or HTML to gather information for your database. You can then send this form to your teammates via e-mail and use their responses to populate and update your Access table to eliminate the need to retype any information.

Share your Access information with the rest of your team using Windows SharePoint Services and Office Access 2007. With the power of both applications, your teammates can access and edit the data and view real-time reports directly through a Web interface.

Use Office Access 2007 as your rich client interface to analyze and create reports from Windows SharePoint Services lists. You can even take the list offline, and then synchronize any changes when you reconnect to the network, making it easy for you to work with your data at any time.

Make your data more transparent by moving it to Windows SharePoint Services. This way, you can routinely back up the data on the server, recover deleted data from the recycle bin, track revision history, and set access permissions, so you can better manage your information.  LeapFox Learning offers both SharePoint and Access training in Boise Idaho.

With Office Access 2007, you can link tables to your database from other Access databases, Excel spreadsheets, Windows SharePoint Services sites, ODBC data sources, Microsoft SQL Server databases, and other data sources. You can then use these linked tables to easily create reports so you can base your decisions on a more comprehensive set of information.