Access 2007 Workbook For Dummies (For Dummies Series) - Softcover

Stockman, Joseph C.

Softcover

ISBN 10: 0470179538 ISBN 13: 9780470179536

Publisher: John Wiley & Sons, 2007

Synopsis

Do you wish Access was more accessible? Do you wonder what to do with databases in the first place? If you ve just been letting Access sit there as an anonymous icon on the Ribbon, Access 2007 Workbook For Dummies can open up new worlds for you.

The coolest thing about this friendly, easy–to–follow workbook is that you ll actually create a database that you can use to organize your own home media collection, if you like. In the process, you discover how to build a database from the ground up and some of the ways a database can be helpful, even if you re not a business mogul or an accountant. Using a problem–solution approach, Access 2007 Workbook For Dummies gives you plenty of chances to practice each step, so you gain confidence along with information.

You ll discover how to:

• Set up Access and use database fundamentals
• Create a home media database from start to finish
• Build tables, relationships, forms, and reports
• Use select and action queries
• View and manipulate data
• Edit and build simple macros and use them to automate navigation
• Arrange controls on a form
• Build a user interface to add, edit, and update data
• Track every aspect of the media collection, including

The bonus CD–ROM includes separate database files for each exercise and a video that walks you through each step of the more complex procedures. In no time you ll find Access is no longer unapproachable.

Note: CD–ROM/DVD and other supplementary materials are not included as part of eBook file.

About this title

About the Author

Joe Stockman is an independent consultant, software designer, and author who has been using Microsoft Access since its initial release. He s also developed courseware and taught classes in Access and VBA. Joe developed his first application in Access, and then migrated into Visual Basic and VB.NET, where he specializes in creating applications for the Windows Mobile platform. He s worked for several software companies before forming his consulting business in 2002, where he deals with all types of clients including healthcare, financial, government, manufacturing, and small business. His ability to turn his customers wishes into working applications keeps them satisfied. Joe is the co–author of the Access 2007 Bible and Access 2007 VBA Programming For Dummies and also writes for the Advisor Guide to Microsoft Access magazine.

From the Back Cover

Find out how to use Access as you actually build a database!

The best way to catch on to something new is by actually doing it, right? As you work your way through this book building tables and relationships, using select and action queries, building forms and reports, and automating with macros, you′ll also be creating a database you can use for your own media collection. How cool is that?

See how to

• Set up Access and use database fundamentals

• Create and view tables

• View and manipulate data

• Arrange controls on a form

• Edit and build simple macros

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2007
• Language: English
• ISBN 10: 0470179538
• ISBN 13: 9780470179536
• Binding: Paperback
• Number of pages: 328