Access 2003: Your Visual Blueprint for Creating and Maintaining Real-World Databases - Softcover

Barker, F. Scott

Softcover

ISBN 10: 0764540815 ISBN 13: 9780764540813

Publisher: John Wiley & Sons, 2004

Synopsis

• Designed for professionals who want a high–level, visual approach to Microsoft Access
• Explains database concepts, then shows how databases are built to perform in real–world business situations, with extensive examination of programming and enterprise use of Access
• Covers creating charts and graphs, designing user–friendly forms, creating macros, creating relationships with other databases, and much more
• Discusses enhanced XML support, integration with Microsoft’s .NET and SQL Server, Web security, and how VBA programming is used with Access
• Describes each of the Access objects for higher end users, including Tables, Queries, Forms, and even Data Access Pages
• Presented in the clear, easy–to–follow style of the Visual Blueprint series, with high–resolution screen shots and succinct explanations
• CD–ROM includes all the completed sample databases from each chapter in the book

About this title

About the Author

Scott Barker has been involved with database development for 17 years since he graduated with a BS in Computer Science in 1986. On the original Microsoft Access team, Scott has worked with Access and SQL Server for over 11 years, written seven books, including F. Scott Barker’s Microsoft Access Power Programming, and Database Programming with Visual Basic .NET and ADO.NET. He has trained thousands of developers, and is a frequent speaker at Microsoft conferences around the world.
Scott is the father of five, and can be found in Woodinville, Washington, with his wife Diana. Scott is the owner of AppsPlus, a software development company specializing in database development for both the desktop and the Web. You can reach him at www.appsplus.com.

From the Back Cover

Welcome to the only guidebook series that takes a visual approach to professional–level computer topics. Open the book and you ll discover step–by–step screen shots that demonstrate over 140 key techniques to help you make the most of Access 2003, including:

• Building charts and graphs
• Designing user–friendly forms
• Creating tables, queries, and Data Access Pages
• Writing macros
• Converting macros to VBA code
• Setting up database relationships
• Programming Access with VBA
• Writing and using classes
• Managing databases
• Using ActiveX Data Objects
• Using Data Access Pages in a Web site

Trial software and more on CD–ROM!

• Demo versions of Speed Ferret and Total Access Analyzer
• Trial versions of Total Visual SourceBook code library, Total Access Admin database maintenance control, and Total Access Components (ActiveX controls written for Access)
• Sample databases from the book
• Assorted other database tools from FMS Inc.
• Links to various downloadable files
• A searchable e–version of the book

• "Apply It" and "Extra"sidebars highlight useful tips
• High–resolution screen shots demonstrate each task
• Succinct explanations walk you through step by step
• Two–page lessons break big topics into bite–sized modules

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2004
• Language: English
• ISBN 10: 0764540815
• ISBN 13: 9780764540813
• Binding: Paperback
• Number of pages: 336