Access 2007 Bible

  • 23h 6m
  • Michael R. Groh, et al.
  • John Wiley & Sons (US)
  • 2007

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 for Applications and the VBA Editor to automate applications
  • Build and customize Access 2007 ribbons
  • Seamlessly exchange Access data with SharePoint
  • Employ advanced techniques such as the Windows API and object-oriented programming
  • Add security and use data replication in your Access applications

In this Book

  • An Introduction to Database Development
  • Creating Access Tables
  • Designing Bulletproof Databases
  • Selecting Data with Queries
  • Using Operators and Expressions in Access
  • Working with Datasheet View
  • Creating Basic Access Forms
  • Working with Data on Access Forms
  • Presenting Data with Access Reports
  • VBA Programming Fundamentals
  • Mastering VBA Data Types and Procedures
  • Understanding the Access Event Model
  • Using Expressions in Queries and VBA Code
  • Accessing Data with VBA Code
  • Using the VBA Debugging Tools
  • Working with External Data
  • Importing and Exporting Data
  • Advanced Access Query Techniques
  • Advanced Access form Techniques
  • Advanced Access Report Techniques
  • Building Multiuser Applications
  • Integrating Access with Other Applications
  • Integrating Access with SharePoint
  • Using ActiveX Controls
  • Handling Errors and Exceptions
  • Optimizing Access Applications
  • Advanced Data Access with VBA
  • Bulletproofing Access Applications
  • Securing Access Applications
  • Using the Windows API
  • Using the Access Replication Features
  • Object-Oriented Programming with VBA
  • Reusing VBA Code with Libraries
  • Customizing Access Ribbons
  • Distributing Access Applications
  • Using Access Macros
  • Using XML in Access 2007
  • SharePoint as a Data Source
  • Client/Server Concepts
  • SQL Server as an Access Companion
  • Upsizing Access Databases to SQL Server
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)