Understand how to take database needs and turn them into effective Access databases while gaining a thorough understanding of Access tables, forms, reports, and queries with this definitive handbook.

You’re beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle Access 2007—and challenge yourself to new levels of mastery! Create tables that support your database design strategy Import and link to data from spreadsheets, text files, databases, and other ODBC data sources Build simple to complex queries to manipulate data Learn advanced techniques for building and customizing user interface forms Design attractive reports to calculate and analyze large sets of data Automate your application with Microsoft Visual Basic(R) for Applications Customize the Office Fluent Ribbon Explore using XML and Windows(R) SharePoint(R) Services to create Web-based applications CD includes: Fully searchable eBook—plus bonus chapters Sample database applications—including query, form, and report examples Articles from the experts: designing databases, understanding SQL, exporting data, and more Links to demos, blogs, and user communities References for finding Access 2003 commands in Access 2007 Windows Vista(R) Product Guide eReference and other eBooks For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

A fully illustrated, modular approach to the features of Access allows readers to proceed at their own pace.

Take charge of your data and run your business or organization both more efficiently and more successfully with the Access 2002 Bible, Gold Edition. Receive top-notch advice from Access experts, Cary N. Prague and Michael R. Irwin, which will help you to quickly master Access's premier database management capabilities and its hot new Web features. The Access 2002 Bible offers step-by-step instructions and practical examples and advice that equips you with everything you need to know to organize, present, analyze, and share data on a network or over the Web. Find comprehensive coverage of all new features and capabilities, including vastly improved Data Access Pages which gives users additional ways to provide information over the Web. Access 2002 carries several performance improvements and an enhanced new file format and every bit of that is addressed between the covers of the Access 2002 Bible, Gold Edition and the accompanying CD-ROM.

Enjoy the proven step-by-step style and improved Access 2003 updates of the Shelly Cashman Seriesr and enhance your Office application skills today! Benefits: * Nine projects, an Integration Feature, a Web Feature, SQL Feature, and six appendices offer a comprehensive presentation of Access 2003. Includes material for a ten- to fifteen-week period in a course that teaches Access 2003 as the primary component. * We've made our Access textbook easier than ever to follow! With a more streamlined design, easy to follow steps and screen shots, your students will find this book to be an essential learning reference. * Includes coverage of the new features of Microsoft Access, such as: automatic error checking, using smart tags, importing and linking SharePoint lists to Access databases, setting macro security, and changing the font size for SQL queries. * Extensive end-of-project exercises, including the unique Learn It Online activities, reinforce the concepts and skills learned. * NEW! Free perforated Access 2003 CourseCard back cover provides students a quick reference to Office 2003 skills at their fingertips.