Microsoft Office: Access 2007 All-In-One Desk Reference for Dummies
- Updated to cover all the latest features and capabilities of Access 2007, this resource provides new and inexperienced Access users with nine task-oriented minibooks that cover beginning to advanced-level material
- Each minibook covers a specific aspect of Access, such as database design, tables, queries, forms, reports, and macros
- Shows how to accomplish specific tasks such as database housekeeping, security data, and using Access with the Web
- Access is the world's leading desktop database solution and is used by millions of people to store, organize, view, analyze, and share data, as well as to build powerful, custom database solutions that integrate with the Web and enterprise data sources
Margaret Levine Young has co-authored several dozen computer books about the Internet, UNIX, WordPerfect, Access, and (stab from the past) PC-File and Javelin, including The Internet For Dummies (Wiley) and Windows XP Home Edition: The Complete Reference (Osborne/McGraw-Hill). She met her future husband Jordan in the R.E.S.I.S.T.O.R.S., a high-school computer club before there were high-school computer clubs. Her other passions are her children, music, Unitarian Universalism (www.uua.org), reading, and anything to do with cooking or eating.
Alison Barrows has authored or co-authored books on Windows, the Internet, Microsoft Access, WordPerfect, Lotus 1-2-3, and other topics. In addition to writing books, Alison writes and edits technical documentation and training material. In real life she hangs out with her “guys” — Parker, 6, and Mason, 4, and Evan 2 — and tries to carve out some time to practice yoga. Alison lives with her family in central Massachusetts.
April Wells is a graduate of the University of Pittsburgh and holds an MBA from West Texas A&M. She is a database administrator with expertise in a wide variety of enterprise database software programs, including Oracle, DB2, MySQL, and Access. She is the author of several books and white papers on database software and is a frequent public speaker, trainer, and consultant.
Table of Contents
Book I: Essential Concepts.
Chapter 1: Introducing Access 2007.
Chapter 2: Getting Started, Getting Around.
Chapter 3: Creating a Database from Templates.
Chapter 4: Designing Your Database the Relational Way.
Book II: Tables.
Chapter 1: Creating and Modifying Tables.
Chapter 2: Entering and Editing Data in Datasheets.
Chapter 3: Sorting, Finding, and Filtering Data.
Chapter 4: Importing and Exporting Data.
Chapter 5: Avoiding “Garbage In, Garbage Out”.
Chapter 6: Relating Your Tables and Protecting Your Data.
Book III: Queries.
Chapter 1: Creating Select Queries.
Chapter 2: Letting Queries Do the Math.
Chapter 3: Doing Neat Things with Action Queries and Query Wizards.
Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables.
Book IV: Forms.
Chapter 1: Designing and Using Forms (and Reports).
Chapter 2: Jazzing Up Your Forms (and Reports).
Chapter 3: Creating Smarter Forms.
Chapter 4: Doing Calculations in Forms (and Reports).
Book V: Reports.
Chapter 1: Creating and Spiffing Up Reports.
Chapter 2: Printing Beautiful Reports.
Chapter 3: Creating Charts and Graphs from Your Data.
Book VI: Macros: Automating Stuff in Access.
Chapter 1: Making Macros Do the Work.
Chapter 2: Making Macros Smarter.
Book VII: Database Administration.
Chapter 1: Database Housekeeping.
Chapter 2: Sharing the Fun — and the Database: Managing Multiuser Access.
Chapter 3: Securing Your Access Database.
Book VIII: Programming in VBA.
Chapter 1: What the Heck Is VBA?
Chapter 2: Writing Code.
Chapter 3: Writing Smarter Code.
Chapter 4: Controlling Forms with VBA.
Chapter 5: Using SQL and Recordsets.
Chapter 6: Debugging Your Code.
Appendix: Installing Microsoft Access.
Sign up now »
- FTJob Title: Mac Systems/ Enterprise Systems EngineerNZ
- FTLead Software EngineerSA
- FTOS Web Applications DeveloperNSW
- FTQuality ManagerSA
- FTSenior Python DeveloperNSW
- FTR&D EngineerSA
- FT.NET - Sitecore Developer - Melbourne - PermNSW
- FTSenior Python Web Applications DeveloperNSW
- FTSenior Python DeveloperNSW
- FTFlash / ActionScript Developer - ContractNSW
Besides form factor, virtual systems are not really that different than physical systems. They both use the same operating systems and applications. They both present users with computing resources such ...
"Darn those pesky laws that get in the way of commercial exploitation ..."
Larry Page wants to see your medical records
"Instead of partitioning the device between corporate and personal data, another approach ..."
Dual-Persona Smartphones Not a BYOD Panacea
"Well that's a nice back-handed compliment isn't it? So now, finally, my ..."
After two-year hiatus, EFF accepts bitcoin donations again
"Actually, both Mobile App developers and CIOs should be blamed for it. ..."
CIOs struggle to deliver timely mobile business apps: survey
"Too little too late. Spice normally has better standards than this. I ..."
Spiceworks' free management software gets integrated MDM
- Microsoft may be scanning your Skype messages
- Researchers find critical vulnerabilities in popular game engines
- Pentagon clearance for iOS could open even more doors for Apple in the private sector
- Digital strongboxes won't solve whistleblower problem for journalists
- ACMA database keeps finger on Australia’s malware pulse
- Commonwealth Bank leads four Australian brands in the 2013 top 100 Global brands list
- More Australians are using mobiles to connect to social media: report
- Oo.com.au partners with Responsys to overhaul digital customer strategy
- Coles Flybuys wins over Aussie consumers in new customer loyalty schemes report
- Tablet advertising exceeds smartphone spend in March quarter: IAB