Sunday, November 6, 2011

Access 2007 All in One Desk Reference For Dummies

Microsoft Access 2007 is the latest-and-greatest version of a long line of Access versions, starting (not surprisingly) with Version


Access 2007 is the database software in the Microsoft 2007 Office Suite. It allows you to order, manage, search, and report large amounts of information. 


Book I: Essential Concepts: If this is your first time using Microsoft Access, and you really don’t know where else to go, starting here is a good idea. This is the stuff you really need to know to get anything done with Access.


Book II: Tables: Everything in Access centers around data (information) stored in tables (not the coffee kind, the columns-and-rows kind). You can’t do much of anything with Access until you have some information stored in tables. This book is a good second stop for you newbies (beginners).


Book III: Queries: Data stored in tables tends to be pretty random and, eventually, pretty plentiful. This book shows you how to pick and choose the information you want to see, and how to organize it in a way that’s more useful, such as alphabetically.


Book IV: Forms: You can definitely get away without making forms in your Access database. But if you get tired of looking at information stored in rows and columns, and are up for being creative, forms are definitely worth getting into.


Book V: Reports: Whereas forms are a way to get creative with stuff on your screen, reports are a way to get creative with stuff you print on your computer’s printer. Here’s where you can do things, for example, printing form letters, mailing labels, numbers with totals and subtotals, and stuff like that.


Book VI: Macros: Automating Stuff in Access: There’s a technical term for you — macros. Nothing to be intimidated by, though. They’re just a way of writing simple instructions that tell Access how to do something you’re sick of doing yourself. Optional, but more fun than the name implies.


Book VII: Database Administration: Sounds like a real yawn, we know. Sometimes you just gotta do things such as make backup copies of your information, or get other people to help you with boring stuff such as typing information into your tables. This is the place where we cover those kinds of things.


Book VIII: Programming in VBA: For the aspiring mega-nerd, we didn’t let this topic slide. This is where the über-technogeeks make their money. Though you can skip it if you have no such aspirations.


Download Free: Access 2007 All in One Desk Reference For Dummies

No comments:

Post a Comment

LinkWithin