John Colby – författare

What is this book about?

Access 2002 is the core database application within the Office XP suite. Using VBA (Visual Basic for Applications), the user can create his or her own programs in what is essentially a subset of the Visual Basic programming language.

Using VBA with Access is a tremendously powerful technique, as it allows you to create great user interfaces (like forms or reports) as a front end to actual data storage and manipulation within the database itself.

What does this book cover?

This book is a revision of the best-selling Beginning Access 2000 VBA, reworked to provide a rich tutorial to programming Access 2002 with VBA. New material covers the enhanced options in Access 2002 for publishing data to the Web, handling XML, integrating with SQL Server Desktop Engine, and so on.

Who is this book for?

This book is for the Access user who already has a knowledge of databases and the basic objects of an Access database, and who now wants to learn how to program with VBA. No prior knowledge of programming is required.

Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all timesFocuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendixPaul Wilton is a successful Wrox "Beginning" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particular database productSQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others

Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix Paul Wilton is a successful Wrox "Beginning" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particular database product SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others

An intranet can be a powerful tool. A well-designed intranet becomes the key resource and communications platform for your organization, used by members of staff as their first destination for information. In contrast, a poorly designed intranet will sit unused, accumulating useless information, and eating up IT budgets. So, how do you avoid this situation, and make sure you design the most useful, and usable, intranet? This book takes you through the steps you need to take to make an invaluable intranet, from identifying your users'' needs and building an indispensable tool, to marketing the results. It guides you through the problems that may occur, passing on invaluable advice from people who have been through the process before. We start by setting the scene, giving an overview of what intranets are and how to justify it to your organization. We then give you a rundown of the main areas you''ll need to think about when developing an intranet, covering browsers, development techniques, usability, content management, security, and internal marketing. Finally, we''ll take a look at what to do when the Intranet moves beyond its original function, looking at remote access, extranets, and what to do when the Intranet gets too big.

You'd think that designing an intranet would be a web professional's heaven. You know exactly what browsers and operating systems your audience are using. You can easily identify users for testing. What could be easier than that? But then, few people ever get to see other companiesi intranets. How can you learn from your peers? Everyone and his dog needs to publish content on an intranet - how do you ensure that content stays current and relevant? How do you ensure that the temp who is uploading situations vacant ads doesnit break it all? Is your intranet accessible? Or do you really need an extranet, for clients and suppliers? How about security? AARGGH! This book helps you frame the questions that you need to ask, sharing best practices from people whoive lived through the nightmare, and survived to tell you the tale. From the Publisher A well-designed intranet becomes the key resource and communications platform for your organization, used by members of staff as their first destination for information.This book guides you through the steps you need to take to make a useful and usable intranet, from identifying your users' needs and building an indispensable tool, to marketing the results. It guides you through the problems that may occur, passing on invaluable advice from people who have been through the process before.