- AusCERT 2013: Low-level analysis can find, map data deleted from Android phones
- Cybercrime Survey: Almost half of small business victims
- AusCERT 2013: Cloud-based scanner identifies new malware by its ancestry
- AusCERT 2013: What's it like to be a 'Nigerian scam' victim?
- AusCERT 2013: Ashley Deuble: Network Security Monitoring with Security Onion
Access 2003 All-In-One Desk Reference for Dummies®
- Creating and modifying tables and entering and editing data
- Sorting, finding, and filtering data
- Creating queries, including update queries, action queries, and the Query Wizards
- Building forms with AutoForm and Wizards
- Creating charts and graphs from your data
- Maintaining, sharing, and securing your Access database
- Letting Access do the math, whether it’s calculating simple cost per unit or performing complex financial functions
Microsoft Office Access 2003 All-In-One Desk Reference For Dummies was written by three computer gurus: Alan Simpson, author of over 80 computer books; Margaret Levine Young, co-author of several dozen computer books, including The Internet for Dummies; and Alison Barrows, book author and writer and editor of technical documentation and training material. To give you hands-on experience and demonstrate practical applications of database management, there is a Web site that complements the book and features a fully functioning mail order management database used in examples throughout the book. You can download it and follow along as you explore:
- Working with external data sources such as Microsoft SQL Server
- Writing and debugging code
- Using data access pages (DAP) to share information on your intranet
With Access 2003 All-In-One Desk Reference For Dummies, you’ll discover how to put information to work for you.
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 (published by Wiley Publishing, Inc.) and Windows XP Home Edition: The Complete Reference (published by 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. She holds a B.A. in International Relations from Wellesley College and an M.P.P. from Harvard University. In real life she hangs out with her “guys” — Parker, 3, and Mason, 1, and tries to carve out some time to practice yoga. Alison lives with her family in central Massachusetts.
Table of Contents
Book I: Essential Concepts.
Chapter 1: Introducing Access 2003.
Chapter 2: Getting Started, Getting Around.
Chapter 3: 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: Protecting Your Data with Referential Integrity.
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 Multi-User 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.
Chapter 7: Integrating Office Applications.
Book IX: Access on the Web.
Chapter 1: Creating Data Access Pages.
Chapter 2: Creating Access Projects.
Chapter 3: Introducing XML.
Appendix: Installing Microsoft Access.
If business-relevant information is not well managed, secured and analysed, it can become an underutilized asset or—worst case—a legal and competitive liability. Nearly all of the IT and business executives who responded to a recent survey recognise this risk, and say they understand the importance of having an enterprise information management (EIM) strategy. Find out more on how to reduce costs, improve competitiveness and avoid risk by making information management an enterprisewide strategic priority.
Seamonkey includes an Internet browser, email and newsgroup client with an included web feed reader, HTML editor, IRC chat and web development tools. SeaMonkey will ...
Allianz Shared Infrastructure Services SE (ASIC) wanted to replace its current suite of management tools, some of which had been developed in-house, with a standard solution for the management of 600 network components in its data centre, in order to reduce costs and further improve quality. Find out what approach they took download today.
- FTTest Analyst (MS Environment) .netNSW
- FTTest Analyst (MS Environment) .netNSW
- FTTechnical Consulting ManagerNSW
- FTTest EngineerVIC
- FTJob Title: Mac Systems/ Enterprise Systems EngineerNZ
- FTQuality ManagerSA
- FT.NET - Sitecore Developer - Melbourne - PermNSW
- FTR&D EngineerSA
- FTOS Web Applications DeveloperNSW
- FTWeb Analyst - WebTrendsVIC
- FTFlash / ActionScript Developer - ContractNSW
- FTLead Software EngineerSA
- FTSenior Python DeveloperNSW
- Lack of information, skills hinder finance-business partnering: Deloitte
- Rapid-growing mobile payments market is driving a financial fraud marketplace
- HP profit falls 32 per cent as PC and server sales decline
- Google launching new fund for later-stage tech investments
- Apple defends offshore decisions that result in low taxes