FREE BOOK OFFER: $25 Value

Using Microsoft Access 2010

by Alison Balter

Thanks to a special arrangement with Alison Balter and the publisher, Que, we are please to offer a limited quantity of this book for FREE to purchasers of our Microsoft Access product suites.

Simply purchase one of these suites:

• Total Access Developer Suite
• Total Access Ultimate Suite

and click HERE to add it to your cart, or mention this offer when ordering.

Terms and Conditions

• Not available for past orders or reseller sales.
• Limited to one book per customer.
• Customer are responsible for shipping:
  • For US customers, this can be included in your shipment for no additional cost.
  • Cost for international customers based on actual shipping cost.
• Offer available while supplies last.

Book Description

Get comfortable with Access 2010. Don't just read about it: see it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the Free Web Edition that comes with every USING book.

With the book, you get online access anywhere with a web connection--no books to carry, updated content, and the benefit of video and audio learning. Way more than just a book, this is all the help you'll ever need...where you want, when you want!

Learn fast, learn easy, using web, video, and audio:

• Show Me video walks through tasks you've just got to see--including bonus advanced techniques
• Tell Me More audio delivers practical insights straight from the experts
• Audio sidebars feature Ross Pimentel

Contents

Let’s take a peek at some of the techniques for using Access 2010 that you’ll be learning about:

Manipulating data

After you learn about relational databases, and what Microsoft Access 2010 has to offer, Chapter 1, “Manipulating Data with Databases and Tables,” shows you how to open a database and modify the data within it. You will also learn how to filter table data.

Retrieving the data you need

Chapter 2, “Using Queries to Retrieve the Data You Need,” shows you all the basics of working with queries. You learn techniques such as how to select fields, apply criteria, and order the query result.

Displaying data with forms

Chapter 3, “Using Forms to Enter and Edit Table Data,” shows you how to manipulate table data from within a form. It also covers the process of using a Form Wizard to create a form.

Printing data with reports

Chapter 4, “Using Reports to Print Information,” first shows you how to open, view, and print an existing report. You then learn how to build your own reports.

Building databases and tables

Chapter 5, “Creating Your Own Databases and Tables,” covers both the process of creating new databases, and of creating new tables. In this chapter, you learn important techniques such as how to work with field properties.

Relating the data in your database

Chapter 6, “Relating the Information in Your Database,” shows you how to relate the tables that you build. After this chapter provides you with a crash course on database design, you learn how to establish relationships, and how to enforce referential integrity.

Working with queries

Chapter 7, “Enhancing the Queries That You Build,” enhances what you learned about queries in Chapter 2. In this chapter, you learn how to build queries based on multiple tables, how to add calculations to the queries that you build, how to run parameter queries when you don’t know the criteria at design time, how to use action queries to update your table data, and how and why to work with outer joins.

Working with forms

Chapter 8, “Building Powerful Forms,” enhances what you learned about forms in Chapter 3. In this chapter, you learn how to work with form controls, how to apply conditional formatting, and how to modify form properties. You also learn how to work with combo boxes, the Command Button Wizard, how to build forms based on more than one table, and how to work with subforms.

Working with reports

Chapter 9, “Building Powerful Reports,” enhances what you learned about reports in Chapter 4. In this chapter you learn how to work with report bands, work with controls, build multi-table reports, work with subreports, add sorting and grouping, and take advantage of report properties.

Using macros to automate your database

Chapter 10, “Automating Your Database with Macros,” shows you how to automate the databases that you build. In this chapter, you learn important techniques such as how to create and run macros, how to control the flow of the macros that you build, and how to create submacros. You also learn how to take advantage of Access 2010’s new features such as embedded macros, data macros, and drill through macros. You learn how to work with variables and error handling, and finally you learn how to take advantage of a very special macro, the AutoExec macro.

Sharing data with other applications

One of Access’s greatest strengths is its ability to share data with other applications. In Chapter 11, “Sharing Data with Other Application,” you learn how to export data to and import data from Excel, text files, and Access databases. You learn how to link to data in other databases, and how to use a powerful tool called the Linked Table Manager to manage the links that you create. As a special bonus, you learn how to link to data in a SQL Server database, so that you can take advantage of Access’s strong ability to participate in a client/server environment.

Running your application in a web browser

Chapter 12, “Working with Web Databases,” shows you how to take your database to the Web. In this chapter, you learn about web databases and what they are. You are introduced to application parts, and you learn how to create server objects. Finally, you witness your completed application running in a web browser.

Whether it’s the new and exciting macro environment, or the ability to easily take Access data to the Web, it won’t take long for you to get to know this new and exciting version of Microsoft Access. Access 2010 is fast, stable, and extremely packed with new and thrilling features. Using Access 2010 is your personal guide to learning how to use Access 2010 and how to get the most out of what it has to offer.

About the Author

Written by Alison Balter, a Microsoft Access MVP and author of over 15 Microsoft Access books. Alison is a long-time friend of FMS. We've known Alison for two decades through industry groups, as conference speakers, and respected colleagues. She's an expert with Microsoft Access and able to communicate and train Access users and developers of all levels.