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
