Stockman, Joseph C. creator text nju Hoboken, NJ John Wiley & Sons 2007 2008 monographic eng

print

electronic resource

327 p. : ill. ; 26 cm.+ 1 computer disc 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. 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. specialized by Joseph C. Stockman Microsoft Access Problems, exercises, etc 9780470179536 UMP 080424 20251117145555.0 vtls000026924