Access 2007 workbook for dummies / by Joseph C. Stockman

Introduction -- PART I: LEARNING DATABASE FUNDAMENTALS: Getting started with Access -- Managing databases -- PART II: CREATING AND USING TABLES: Creating and modifying tables -- Entering data in tables -- Viewing date in tables -- Building relationships -- PART III: VIEWING DATA WITH SELECT QUERIES: Creating single-table queries -- Creating multi-table queries -- Performing calculations in queries -- PART IV: MANIPULATING DATA WITH ACTION QUERIES: Changing data with update queries -- Adding data with append queries -- Removing data with delete queries -- Creating tables with make table queries -- PART V: BUILDING FORMS: Creating and using forms -- Basic form design -- Changing control properties -- Changing form properties -- Creating calculated controls -- PART VI: ADVANCED FORM DESIGN: Formating a form -- Arranging and sizing controls on a form -- Using combo boxes and list boxes -- Using split forms and subforms -- PART VII: BUILDING REPORTS: Creating simple reports -- Changing report design -- Grouping and sorting reports -- PART VIII: AUTOMATING ACCESS: Adding buttons to forms -- Editing and building simple macros -- Creating a switchboard -- Importing and exporting data -- PART IX: THE PARTS OF TEN: Ten tips using Access like a pro -- Ten (more or less) shortcut keys for using Access -- Ten (more or less) shortcut keys for entering data -- Appendix A: About the CD -- Appendix B: Exercises.

Provides exercises that cover the features and functions of Microsoft Access, with information on such topics as creating and viewing tables, arranging controls on a form, editing and building macros, and creating reports.