# Publisher: McGraw-Hill Osborne Media; 1 edition (January 26, 2007)
# Language: English
# ISBN-10: 0072263504
# ISBN-13: 978-0072263503


BOOK DESCRIPTION

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.

DOWNLOAD

# Publisher: Que; 2Rev Ed edition (May 1, 2007)
# Language: English
# ISBN-10: 0789736691
# ISBN-13: 978-0789736697


BOOK DESCRIPTION

Part I: Creating Forms

Chapter 1 Creating and Using a Form

Chapter 2 Working with Form Controls

Chapter 3 Designing Forms for Efficient and Accurate Data Entry

Chapter 4 Designing Forms for Business Use

Chapter 5 Creating Specialized Forms

Part II: Designing and Customizing Reports

Chapter 6 Creating and Publishing a Report

Chapter 7 Designing Effective Business Reports

Chapter 8 Designing Advanced Reports

Chapter 9 Creating Specialized Reports

Part III: Creating Powerful Queries

Chapter 10 Creating a Basic Query

Chapter 11 Building Criteria Expressions

Chapter 12 Working with Multiple-Table Queries

Chapter 13 Creating Advanced Queries

Chapter 14 Creating PivotTable Queries

Chapter 15 Querying with SQL Statements

Index


DOWNLOAD

# Publisher: Wiley; Pap/Cdr edition (January 10, 2007)
# Language: English
# ISBN-10: 0470046732
# ISBN-13: 978-0470046739

BOOK DESCRIPTION

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

# Publisher: Sams; 1 edition (May 31, 2007)
# Language: English
# ISBN-10: 0672329328
# ISBN-13: 978-0672329326

BOOK DESCRIPTION

Part I The Basics of Access Development

1 Access as a Development Tool. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

2 What Every Developer Needs to Know About Databases and Tables . . . . ........................................... . . 75

3 Relationships: Your Key to Data Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ............ .. . . . . . . . 115

4 What Every Developer Needs to Know About Query Basics. . . . . . . . . . .................................. . . . . . . 137

5 What Every Developer Needs to Know About Forms. . . . . . . . . . . . . . ......................... . . . . . . . . . . . 189

6 What Every Developer Needs to Know About Reports. . . . . . . . . . . . . .......................... . . . . . . . . . . 269

7 What Are Macros, and When Do You Need Them? . . . . . . . . . . . . . . . . . . ........................ . . . . . . . . 315

8 VBA: An Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . 345

9 Objects, Properties, Methods, and Events Explained . . . . . . . . . . . . . . . . . . . . ....................... . . . . . 401

10 Advanced Form Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431

11 Advanced Report Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 493

12 Advanced Query Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539

13 Advanced VBA Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 599

14 Exploiting the Power of Class Modules. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 637

15 What Are ActiveX Data Objects, and Why Are They Important?. . . . . . . . . . 671

Part II What to Do When Things Don’t Go as Planned

16 Debugging: Your Key to Successful Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 727

17 Error Handling: Preparing for the Inevitable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 755

18 Optimizing Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 801

Part III Developing Multiuser and Enterprise Applications

19 A Strategy to Developing Access Applications. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 835

20 Using External Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 847

21 Access 2007 and SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 883

22 Developing Multiuser and Enterprise Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . 909

00_0672329328_FM.qxd 5/4/07 9:23 AM Page iii

Part IV Black Belt Programming

23 Working with and Customizing Ribbons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 935

24 Automation: Communicating with Other Applications. . . . . . . . . . . . . . . . . . . . . . 949

25 Exploiting the Power of the Windows API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 985

26 Creating Your Own Libraries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1011

27 Using Builders and Wizards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1027

28 An Introduction to Access and the Internet/Intranet. . . . . . . . . . . . . . . . . . . . . . . . 1055

Part V Adding Polish to Your Application

29 Documenting Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1073

30 Maintaining Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1091

31 Database Security Made Easy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1103

The following appendixes are available for download

at www.samspublishing.com/title/0672329328.

Part VI Appendixes

A Naming Conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1131

B Table Structures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1137

Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1193


DOWNLOAD