Access 2010 For Dummies
Laurie Ulrich Fuller, Ken Cook
Language: English
Pages: 456
ISBN: 0470497475
Format: PDF / Kindle (mobi) / ePub
A friendly, step-by-step guide to the Microsoft Office database application
Access may be the least understood and most challenging application in the Microsoft Office suite. This guide is designed to help anyone who lacks experience in creating and managing a database learn to use Access 2010 quickly and easily.
In the classic For Dummies tradition, the book provides an education in Access, the interface, and the architecture of a database. It explains the process of building a database, linking information, sharing data, generating reports, and much more.
- As the Microsoft Office database application, Access may be the least understood and most challenging part of the Office suite
- Access 2010 For Dummies walks newcomers through building and using their first database
- Covers linking information in a database, setting relationships, modeling data, and building tables
- Explores how to extract data from Access and get specific answers, create forms, and export data in reports
- A section for more experienced users looks at analyzing errors and creating an interface
Fully updated for the newest version, Access 2010 For Dummies gets new Access users up to speed and helps veterans get the most from the Office database application.
provides some cool automatic tools that let you pick and choose what you want in your report, and then it goes and makes the report for you. How neat is that? Automatic reports weren’t good enough for you, eh? If your job relies upon reports not only being informative but also attractive and attention-grabbing, Part V will be like opening a birthday present. Well, not really, but you’ll find out about charts, printing labels, and putting everything from your logo to page numbers on your reports.
goes: ✓ The File tab and its associated Backstage View panel are new; they replace the Office button and resulting menu in Access 2007. Using the panel on the left (shown in Figure 1-6), you make your choices for opening new files, accessing recently used files, saving files, printing, and exiting the application (among other momentous decisions). It’s a lot like ye olde File menu from Access 2003 in terms of what’s available; Backstage view makes the commands and features that used to live on
chaos trying to write a report or generate a query that pulls data from that database. You could end up with a recipe that calls for motor oil or a maintenance schedule that tells you to preheat the car to 350 degrees. Such a report might be amusing, but it’s hardly useful. The database An Access database, or database file (the terms are interchangeable), is a collection of everything relating to a particular set of information. The database contains all the tables, queries, reports, and forms
vacation by default ........................................... 136 Part III: Data Mania and Management ...................... 139 Chapter 7: Creating Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .141 Generating Forms ........................................................................................ 141 Keeping it simple: AutoForm ............................................................ 143 Granting most wishes: The Form Wizard
problem: 1. Press Ctrl+Break to stop the import process. 2. Open the source file in its native application and check the data that’s being imported for problems, such as • Corrupt data: The file you are attempting to import may be unusable. • Badly organized spreadsheet data. • An invalid index: Sometimes database indexes become corrupt, making the data within the table with the corrupt index unusable. Access will usually holler at you when you open the source table that contains the invalid