Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.


TABLE OF CONTENT:

Chapter 01 - Creating Your First Database
Chapter 02 - Building Smarter Tables
Chapter 03 - Mastering the Datasheet: Sorting, Searching, Filtering, and More
Chapter 04 - Blocking Bad Data
Chapter 05 - Linking Tables with Relationships
Chapter 06 - Queries That Select Records
Chapter 07 - Essential Query Tricks
Chapter 08 - Queries That Update Records
Chapter 09 - Analyzing Data with Crosstab Queries and Pivot Tables
Chapter 10 - Creating Reports
Chapter 11 - Designing Advanced Reports
Chapter 12 - Creating Simple Forms
Chapter 13 - Designing Advanced Forms
Chapter 14 - Building a Navigation System
Chapter 15 - Automating Tasks with Macros
Chapter 16 - Automating Tasks with Visual Basic
Chapter 17 - Writing Smarter Code
Chapter 18 - Sharing a Database with Multiple Users
Chapter 19 - Importing and Exporting Data
Chapter 20 - Connecting Access to SQL Server
Chapter 21 - Connecting Access to SharePoint

الرابط في المرفقات