Microsoft Office Access 2007: The Complete Reference

Complete Reference Series
By Virginia Andersen 
775 pages
McGraw-Hill Osborne Media; 1 edition (January 26, 2007)
ISBN-10: 0072263504
ISBN-13: 978-0072263503

Book Description

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

Download Microsoft Office Access 2007: The Complete Reference

Access 2007 The Missing Manual

By Matthew MacDonald
751 pages
Publisher: Pogue Press (December 29, 2006)
ISBN-10: 0596527608
ISBN-13: 978-0596527600

Product Description

Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.

Download Access 2007 The Missing Manual 

Access 2007 for Starters: The Missing Manual

By Matthew MacDonald
Paperback: 378 pages
Publisher: Pogue Press; 1 edition
ISBN-10: 0596528337
ISBN-13: 978-0596528331

Product Description

This fast-paced book teaches you the basics of Access 2007 so you can start using this popular database program right away. You'll learn how to work with Access' most useful features to design databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry.

The new Access is radically different from previous versions, but with this book, you'll breeze through the new interface and its timesaving features in no time with:

• Clear explanations
• Step-by-step instructions
• Lots of illustrations
• Larger type
• Plenty of friendly advice

Ideal for small businesses and households, Access runs on PCs and manages large stores information, including numbers, pages of text, and pictures -- everything from a list of family phone numbers to an enormous product catalog. Unfortunately, each new version of the program crammed in yet another set of features -- so many that even the pros don't know where to find them all. Access 2007 breaks the mold: Microsoft changed the user interface by designing a tabbed toolbar that makes features easy to locate. 

One thing that hasn't improved is Microsoft's documentation. Even if you find the features you need, you still may not know what to do with them. Access 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

Download Access 2007 for Starters: The Missing Manual

Microsoft Access 2007 Data Analysis

By Michael Alexander
552 pages
Publisher: Wiley (March 26, 2007)
ISBN-10: 0470104856
ISBN-13: 978-0470104859

Book Description

Chart a course for more effective data analysis with Access 2007. With this resource, you’ll learn how Access 2007 offers powerful functionality that may be better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time—all using Access. If you know a bit about table structures and formulas as well as data analysis, start thinking outside the chart.

• Apply Access 2007 to the task of collecting, transforming, analyzing, and presenting data
• 
  
  Create custom functions, perform batch analysis, and develop automated procedures that essentially run themselves
• 
  
  Build effective query skills
• 
  
  Learn to clean and shape raw data, create and utilize custom calculations, work with dates, and perform advanced time analysis
• 
  
  Work with SQL statements, PivotTables, and PivotCharts
• 
  
  Perform advanced statistical analysis using subqueries and domain aggregate functions
• 
  
  See how to use macros and Visual Basic® for Applications to enhance data analysis

Download Microsoft Access 2007 Data Analysis 

Microsoft Excel and Access Integration: With Microsoft Office 2007

Access 2007 Bible

By Michael R. Groh Joseph C. Stockman, Gavin Powell, Cary N. Prague Michael R. Irwin, Jennifer Reardon
Publisher: Wiley; Pap/Cdr edition (January 10, 2007)
ISBN-10: 0470046732
ISBN-13: 978-0470046739

Book Description

Harness the power of Access 2007 with the expert guidance in this comprehensive reference. Beginners will appreciate the thorough attention to database fundamentals and terminology. Experienced users can jump right into Access 2007 enhancements like the all-new user interface and wider use of XML and Web services. Each of the book's six parts thoroughly focuses on key elements in a logical sequence, so you have what you need, when you need it. Designed as both a reference and a tutorial, Access 2007 Bible is a powerful tool for developers needing to make the most of the new features in Access 2007.

* Build Access tables using good relational database techniques
* Construct efficient databases using a five-step design method
* Design efficient data-entry and data display forms
* Utilize the improved Access report designer
* Use Visual Basic(r) for Applications and the VBA Editor to automate applications
* Build and customize Access 2007 ribbons
* Seamlessly exchange Access data with SharePoint(r)
* Employ advanced techniques such as the Windows(r) API and object-oriented programming
* Add security and use data replication in your Access applications

Download Access 2007 Bible

Alison Balter's Mastering Microsoft Office Access 2007 Development

Saturday, April 12, 2008

By Alison Balter
1248 pages
Publisher: Sams; 1 edition (June 10, 2007)
ISBN-10: 0672329328
ISBN-13: 978-0672329326

Product Description

Microsoft Office 2007 is a major upgrade from the last version of Office; Access will also be greatly revised. Alison Balter is the name that Access developers will trust to guide them through Access 2007's new features. She has the rare ability to take complex topics and explain them clearly, as shown by the success of her ten previous books on Access. Balter is known for providing real-world solutions to specific Access development problems. She also is known for her ability to back up her practical examples with just enough underlying theory to give the reader a good overall understanding of Access. In short, this book will provide beginning and intermediate Access developers with everything that they need to know to design and build Access 2007 applications. It should also appeal to DBAs and power users who want or need to get started building custom Access apps. This latest book in her Mastering Access series will not disappoint her many fans who anxiously await each new version, and should win her new fans as well.

Download Alison Balter's Mastering Microsoft Office Access 2007 Development