Microsoft Office Access 2007 : the complete reference /
Virginia Andersen.
- New York : McGraw-Hill, c2007.
- xxiv, 775 pages : illustrations ; 23 cm. + 1 CD-ROM (4 3/4 in.)
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.