Includes index

System requirements for accompanying CD-ROM: Acrobat Reader

Contents
1 Quick tour of Microsoft Office Access 2007 3
2 The world of relational databases 27
3 Creating a database 41
4 Creating and modifying tables 57
5 Relating tables 95
6 Entering and editing data 113
7 Sorting, filtering, and printing records 163
8 Extracting information with queries 191
9 Creating advanced queries 241
10 Creating form and report designs 269
11 Using the form tools 315
12 Customizing forms 345
13 Using the report wizard 391
14 Customizing reports 423
15 Creating charts and graphs 465
16 Customizing the workplace 499
17 Improving database performance 531
18 Understanding events and the event model 553
19 Automating with macros 569
20 Customizing the user interface 599
21 Customizing the navigation pane and creating switchboards 623
22 Exchange database objects and text 655
23 Exchanging data with outside sources 683
24 Sharing with multiple users 707
25 Secure a database 719
A Converting to Access 2007 733

The Ultimate Microsoft Office Access 2007 Resource Build a highly responsive a database so you can track, report, and share information and make more informed decisions. This comprehensive resource shows you how to design and develop custom Access 2007 databases--even if you have little or no programming experience. You'll learn to collect data from a variety of sources, share it securely with others, and integrate it with other Office applications. Filled with detailed, easy-to-follow instructions, Microsoft Office Access 2007: The Complete Reference shows you how to take full advantage of all the new features, including the new ribbon user interface and navigation pane, new field types, and more. Create a reliable and versatile information management solution with help from this all-inclusive guide. As a bonus, you can gain hands-on experience by following along with the book's sample databases on the CD-ROM. Customize the user interface to suit your preferences Use the built-in database templates or design your own Create, modify, and relate tables Enter and edit data Write advanced queries to extract and manipulate information Create customized forms and reports Improve performance and back up your database Develop macros to carry out automated responses to user actions Import, link, and export data Enable a multiple-user environment Secure your database --Publisher.

In English text.