Muutke küpsiste eelistusi

E-raamat: Access 2003 For Dummies

  • Formaat: PDF+DRM
  • Ilmumisaeg: 06-Jun-2013
  • Kirjastus: Hungry Minds Inc,U.S.
  • Keel: eng
  • ISBN-13: 9780764556715
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 15,11 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
  • Formaat: PDF+DRM
  • Ilmumisaeg: 06-Jun-2013
  • Kirjastus: Hungry Minds Inc,U.S.
  • Keel: eng
  • ISBN-13: 9780764556715
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

When you hear the word "database," do your eyes glaze over? Does the mention of fields and tables make your blood pressure skyrocket? Does the idea of entering and using hyperlinks make you hyperventilate? Whether you're running a business or a household ...whether you need to be able to quickly access customer information, your recipe for chicken cacciatore, or the Little League team's records, Access 2003 holds the key. This friendly guide unlocks the secrets of using Access 2003 to store, manage, organize, reorganize, and use data! It gives you: the basics of the whole database concept; suggestions for solving problems with Access; what you need to know to design, build, use, and change Access tables; info on the ten most common types of fields; the scoop on using queries to unearth the answers hiding somewhere in your data; and guidelines for using the Access report system to make short work of long, previously time-consuming, reports.In the relaxed, comfortable "For Dummies" style, this book has easy-to-follow, step-by-step instructions and lots of screen shots. If you want to create and manage a database for a huge auction house, this guide will get you going ...going ...gone. If you want to create a database for your music collection, it gives you the score then shows you how to use formatting and add graphics to jazz it up. You'll get the low-down on extracting all kinds of information from databases and putting that information to practical use.You'll discover how to: Use Label Wizard to create mailing labels, file labels, shipping labels, or name tags; Use Chart Wizard to create line charts, bar, cone, and column charts, pie and donut charts, area charts, and XY and bubble charts; use Auto Reports to create columnar or tabular reports and then fine-tune them; export reports to Microsoft Word and Excel; get your data Web-ready and put it on the Internet in either static or dynamic form; build forms with Form Wizard; and speaking of high-tech fun, "Access 2003 For Dummies" even tells you how to install and use speech recognition software with Access 2003. So if the idea of working with databases has you talking to yourself, this is just the book you need.
Introduction 1(6)
About This Book
1(1)
Conventions Used in This Book
1(1)
What You Don't Have to Read
2(1)
Foolish Assumptions
3(1)
How This Book Is Organized
3(2)
Part I: Which Came First, the Data or the Base?
3(1)
Part II: Truly Tempting Tables
4(1)
Part III: Finding the Ultimate Answer to Almost Everything
4(1)
Part IV: Turning Your Table into a Book
4(1)
Part V: Wizards, Forms, and Other Mystical Stuff
4(1)
Part VI: The Part of Tens
5(1)
Icons Used in This Book
5(1)
Where to Go from Here
6(1)
Part I: Which Came First, the Data or the Base 7(34)
Chapter 1: The 37-Minute Overview
9(14)
In the Beginning, There Was Access 2003
9(3)
Opening an Existing Database
12(2)
Touring the Database Window
14(1)
Finding Information Amongst the Grass Clippings
15(2)
Making a Few Changes
17(1)
Reporting the Results
18(2)
Saving Your Hard Work
20(1)
The Great Backup Lecture
21(1)
Making a Graceful Exit
22(1)
Chapter 2: Finding Your Way Around like a Native
23(12)
Making Sense of the Sights
24(2)
Windows Shopping for Fun and Understanding
26(5)
The database window
26(2)
The datasheet window
28(1)
The form window
29(1)
The query window
30(1)
Belly Up to the Toolbar, Folks!
31(1)
Menus, Menus Everywhere
32(1)
Playing with the Other Mouse Button
32(3)
Chapter 3: Calling the Online St. Bernard and Other Forms of Help
35(6)
Finding Help Here, There, and Waaaay Over There
36(1)
Asking Questions of the Software
36(2)
Your Internet Connection Knows More Than You May Think
38(1)
Talking to a Human
39(2)
Part II: Truly Tempting Tables 41(86)
Chapter 4: Designing and Building a Home for Your Data
43(24)
Database Terms to Know and Tolerate
44(2)
Data (your stuff)
44(1)
Fields (the rooms for your stuff)
45(1)
Records (the rooms in one house)
45(1)
Table (the houses of a neighborhood)
46(1)
Database (a community of neighborhoods)
46(1)
Frolicking through the Fields
46(4)
Flat Files versus Relational Databases: Let the Contest Begin!
50(3)
Flat files: Simple answers for simple needs
51(1)
Relational databases: Complex solutions to bigger problems
51(1)
Figuring out what all this means
52(1)
Great Tables Start with Great Designs
53(2)
Building a Database
55(4)
Creating Tables at the Wave of a Wand
59(4)
Building Tables by Hand, Just like in the Old Days
63(4)
Chapter 5: Relationships, Keys, and Indexes (and Why You Really Do Care)
67(10)
The Joy (and Necessity) of a Primary Key
68(1)
Divulging the Secrets of a Good Relationship
69(2)
Linking Your Tables with the Relationship Builder Thingy
71(3)
Indexing Your Way to Fame, Fortune, and Significantly Faster Queries
74(3)
Chapter 6: New Data, Old Data, and Data in Need of Repair
77(10)
Dragging Your Table into the Digital Workshop
78(3)
Adding Something to the Mix
81(2)
Changing What's Already in a Record
83(1)
Kicking Out Unwanted Records
84(1)
Recovering from a Baaaad Edit
85(2)
Chapter 7: Making Your Table Think with Formats, Masks, and Validations
87(16)
Finding the Place to Make a Change
88(1)
To Format, Perchance to Better See
89(5)
Text and memo fields
90(1)
Number and currency fields
91(1)
Date/time fields
92(1)
Yes/No fields
93(1)
What Is That Masked Data?
94(6)
Using the Input Mask Wizard
95(2)
Making a mask by hand
97(3)
Validations: The Digital Breathalyzer Test
100(3)
Chapter 8: Making Your Datasheets Dance
103(14)
Wandering Here, There, and Everywhere
103(2)
Seeing More or Less of Your Data
105(9)
Changing the column width
106(1)
Changing the row height
107(1)
Reorganizing the columns
108(2)
Hiding a column
110(2)
Freezing a column
112(2)
Fonting around with Your Table
114(1)
Giving Your Data the 3-D Look
114(3)
Chapter 9: Table Remodeling Tips for the Do-It-Yourselfer
117(10)
This
Chapter Can Be Hazardous to Your Table's Design
118(1)
Putting a New Field Next to the Piano
118(3)
Saying Good-bye to a Field (And All Its Data)
121(1)
A Field by Any Other Name Still Holds the Same Stuff
122(7)
Changing a field name in design view
123(1)
Changing a field name in datasheet view
124(3)
Part III: Finding the Ultimate Answer to Almost Everything 127(82)
Chapter 10: Quick Searches: Find, Filter, and Sort
129(14)
Finding Stuff in Your Tables
130(3)
Finding first things first (and next things after that)
130(1)
Tuning a search for speed and accuracy
131(2)
Sorting Out Life on the Planet
133(1)
Filtering Records with Something in Common
134(3)
Filter For
135(1)
Filter by Selection
136(1)
Filter by Form
137(3)
Removing your mistakes (or when good criteria go bad)
140(1)
Filter by excluding selection
141(2)
Chapter 11: Pose a Simple Query, Get 10,000 Answers
143(8)
Database Interrogation for Fun and Profit
144(1)
On Your Way with a Simple Query - Advanced Filter/Sort
144(6)
Peering into the filter window
146(1)
Building a simple query - er, filter
147(3)
Plagued by Tough Questions? Try an Industrial Strength Query!
150(1)
Build a Better Query and the Answers Beat a Path to Your Monitor
150(4)
Toto, Can the Wizard Help?
154
Chapter 12: Searching a Slew of Tables
151(16)
Some General Thoughts about Multiple-Table Queries
157(2)
Calling on the Query Wizard
159(2)
Rolling Up Your Sleeves and Building the Query by Hand
161(6)
Chapter 13: Lions AND Tigers OR Bears? Oh My!
167(8)
Comparing AND to OR
167(1)
Finding Things between Kansas AND Oz
168(2)
Multiple ANDS: AND Then What Happened?
170(1)
Are You a Good Witch OR a Bad Witch?
170(2)
AND and OR? AND or OR?
172(3)
Chapter 14: Teaching Queries to Think and Count
175(12)
Super-Powering Queries with the Total Row
176(2)
Adding the Magical Total Row to Your Queries
178(1)
Putting the Total Row to Work
179(4)
Organizing things with Group By
179(1)
Adding a total with Sum
180(1)
Counting the good count
181(1)
Narrowing the results with Where
182(1)
Choose the Right Field for the Summary Instruction
183(4)
Chapter 15: Calculating Your Way to Fame and Fortune
187(12)
A Simple Calculation
188(3)
Bigger, Better (and More Complicated) Calculations
191(4)
Add another calculation - go ahead, add two!
191(1)
Using one expression to solve a different question
191(2)
Making Access ask nicely for help
193(1)
Working with words
194(1)
Expression Builder (Somewhat) to the Rescue
195(4)
Chapter 16: Automated Editing for Big Changes
199(10)
First, This Word from Our Paranoid Sponsor
199(1)
Quick and Easy Fixes: Replacing Your Mistakes
200(2)
Different Queries for Different Jobs
202(1)
You're Outta Here: The Delete Query
203(2)
Making Big Changes
205(4)
Part IV: Turning Your Table into a Book 209(64)
Chapter 17: AutoReport: Like the Model-T, It's Clunky but It Runs
211(12)
AutoReport Basics for High-Speed Information
212(1)
Putting the Wheels of Informational Progress in Motion
213(1)
Previewing Your Informational Masterpiece
214(3)
Zooming around your report
215(1)
Calling on the pop-up menu
216(1)
Truth Is Beauty, So Make Your Reports Look Great
217(6)
The Margins tab
218(1)
The Page tab
219(1)
The Columns tab
220(3)
Chapter 18: Wizardly Help with Labels, Charts, and Multilevel Reports
223(16)
Creating Labels
223(5)
Using the Chart Wizard in Your Report
228(3)
Creating More Advanced Reports
231(8)
Starting the wizard and choosing some fields
231(2)
Creating new groupings
233(1)
Sorting out the details
234(1)
Choosing a layout style
235(4)
Chapter 19: It's Amazing What a Little Formatting Can Do
239(18)
Taking Your Report to the Design View Tune-Up Shop
240(1)
Striking Up the Bands (and the Markers, Too)
241(2)
Formatting This, That, These, and Those
243(8)
Colorizing your report
244(2)
Moving elements around
246(2)
Bordering on beautiful
248(2)
Tweaking your text
250(1)
Taking a Peek at Your Report
251(1)
AutoFormatting Your Way to a Beautiful Report
252(1)
Lining Up Everything
253(1)
Drawing Your Own Lines
254(1)
Inserting Page Breaks
255(1)
Sprucing Up the Place with a Few Pictures
256(1)
Passing Your Reports around the (Microsoft) Office
256(1)
Chapter 20: Headers and Footers for Groups, Pages, and Even (Egad) Entire Reports
257(16)
Everything in Its Place
258(7)
Grouping your records
261(3)
Changing a section's size
264(1)
Fine-Tuning the Layout
265(4)
Playing with the properties
265(1)
Directing the report and page headings
266(2)
Adjusting individual sections
268(1)
Taking it one item at a time
269(1)
Filling in Those Sections
269(6)
At the head of the class
270(1)
Page numbers and dates
271(2)
Part V: Wizards, Farms, and Other Mystical Stuff 273(52)
Chapter 21: Spinning Your Data onto the Web
275(10)
Access and the Internet: A Match Made in Redmond
275(1)
Building Hyperlinks in Your Table
276(4)
Adding a hyperlink field to your table
277(1)
Typing and using hyperlinks
277(3)
Pushing Your Data onto the Web
280(4)
Advanced Topics for Your Copious Nerd Time
284(1)
Chapter 22: Making Forms that Look Cool and Work Great
285(14)
Tax Forms and Data Forms Are Different Animals
285(2)
Creating a Form at the Wave of a Wand
287(3)
Giving the Form Just the Right Look
290(2)
Mass Production at Its Best: Forms from the Auto Factory
292(1)
Ultimate Beauty through Cosmetic Surgery
293(6)
Taking a form into Design view
294(1)
Moving fields
294(1)
Adding lines and boxes
295(1)
Changing the field tab order
296(3)
Chapter 23: If Love Is Universal, Why Can't I Export to It?
299(2)
Importing Only the Best Information for Your Databases
300(4)
Translating file formats
300(2)
Importing or linking your files
302(2)
Sending Your Data on a Long, One-Way Trip
304
Chapter 24: The Analyzer: Your Data's Dr. Freud, Dr. Watson, and Dr. Jekyll
301(14)
It Slices, It Dices, It Builds Relational Databases!
307(3)
Documentation: What to Give the Nerd in Your Life
310(2)
Performance: Toward a Better Database
312(3)
Chapter 25: Talking to Your Computer
315(10)
What Is Speech Recognition (and What Can I Do with It)?
316(1)
Installing Speech Recognition
316(1)
Sending Access to Voice Training School
317(2)
Speaking to Access
319(5)
"Access, take a letter please"
320(1)
Correcting dictation errors
321(1)
Using command mode
322(2)
Improving Speech Recognition
324(1)
Part VI: The Part of Tens 325(18)
Chapter 26: Ten Timesaving Keyboard Shortcuts
321(10)
Select an Entire Field: F2
327(1)
Insert the Current Date: Ctrl+; (Semicolon)
328(1)
Insert the Current Time: Ctrl+: (Colon)
328(1)
Insert the Same Field Value as in the Last Record: Ctrl+' (Apostrophe)
328(1)
Insert a Line Break: Ctrl+Enter
328(1)
Add a Record: Ctrl++ (Plus Sign)
329(1)
Delete the Current Record: Ctrl+- (Minus Sign)
329(1)
Save the Record: Shift+Enter
329(1)
Undo Your Last Changes: Ctrl+Z
329(1)
Open the Selected Object in Design View: Ctrl+Enter
330(1)
Chapter 27: Ten Common Crises and How to Survive Them
331(6)
You Type 73.725, but It Changes to 74
332(1)
You Run a Query but the Results Look Screwy
332(1)
And When You Looked Again, the Record Was Gone
333(1)
The Validation That Never Was
334(1)
The Sometimes-There, Sometimes-Gone Menus
334(1)
You Can't Link to a dBASE Table
335(1)
You Can't Update a Linked dBASE or Paradox Table
335(1)
You Get a Key Violation While Importing a Table
335(1)
Try as You May, the Program Won't Start
336(1)
The Wizard Won't Come Out of His Keep
336(1)
Chapter 28: Ten Tips from Database Nerds
337(6)
Document As if Your Life Depends on It
337(1)
Don't Make Your Fields Too Big
338(1)
Use Number Fields for Real Numbers
339(1)
Validate Data
339(1)
Use Understandable Names
339(1)
Take Great Care When Deleting Keep Backups
340(1)
Think First and Then Think Again
340(1)
Get Organized and Keep It Simple
340(1)
Know When to Ask for Help
341(2)
Index 343


John Kaufeld has written all previous editions of Access For Dummies as well as several other books. John also operates shippertools.com, an online shipping assistant.