Microsoft Access 2010 All-in-One for Dummies

Name: Microsoft Access 2010 All-in-One for Dummies
Author: Alison Barrows

Specificaties

Paperback, 762 blz. | Engels

John Wiley & Sons | 1e druk, 2010

ISBN13: 9780470532188

Rubricering

Hoofdrubriek : Computer en informatica

Juridisch : Computer en informatica

John Wiley & Sons 1e druk, 2010 9780470532188

Onderdeel van serie Dummies (Engelstalig)

Gratis verzonden | Verwachte levertijd ongeveer 8 werkdagen

40,34

In winkelwagen

Samenvatting

Build powerful custom database solutions to keep your data organized and accessible

What kind of golden nuggets are in your data? This reference shows how to take advantage of Microsoft Access 2010's new features and capabilities so you can, well, access the information you need. You'll breeze through everything from tables, queries, and forms to database administration and Visual Basic for Applications as you learn this program.

- Set the table - follow easy ways to make new tables, create table templates, and utilize the Table Wizard
- Pick and choose your data - learn how to find the information you want and organize it in a way that's more useful
- Get creative with forms - build your own forms using the Form Wizard
- Cut your workload - find out how to write simple instructions that tell Access how to automate steps instead of doing it yourself
- Show it off - see the best ways to design reports and print form letters, mailing labels, numbers with totals and subtotals, and more
- Keep your database clean - discover what you need to do to ensure that your data is neat and tidy
- Go beyond Access - interact with and move data to and from other programs on your computer or computers all over the world

Open the book and find:
- How to easily design your relational database
- Ways to create select queries
- How to design and use forms for editing data
- Techniques for spiffing up reports with charts and graphs
- Methods for making macros smarter
- Steps for securing your database
- Tips for programming in VBA
- How to use Access with SharePoint and SQL Server

Specificaties

ISBN13:9780470532188

Taal:Engels

Bindwijze:paperback

Aantal pagina's:762

Uitgever:John Wiley & Sons

Druk:1

Hoofdrubriek:Computer en informatica

Serie:Dummies (Engelstalig)

Inhoudsopgave

U kunt van deze inhoudsopgave een PDF downloaden

Introduction.

Book 1: Essential Concepts.
1. Introducing Access 2010.
2. Getting Started, Getting Around.
3. Designing Your Database the Relational Way.

Book 2: Tables for Storing Your Data.
1. Creating and Modifying Tables.
2. Refining Your Table in Design View.
3. Sorting, Finding, and Filtering Data in a Datasheet.
4. Importing and Exporting Data.
5. Avoiding "Garbage In, Garbage Out".
6. Relating Your Tables and Protecting Your Data.

Book 3: Queries (or Getting Information from Your Data).
1. Creating Select Queries.
2. Letting Queries Do the Math.
3. Doing Neat Things with Action Queries and Query Wizards.
4. Viewing Your Data from All Angles Using Crosstabs and PivotTables.

Book 4: Forms for Editing Data.
1. Designing and Using Forms (and Reports).
2. Jazzing Up Your Forms (and Reports).
3. Creating Smarter Forms.
4. Doing Calculations in Forms and Subforms (and Reports).

Book 5: Reporting in Words and Pictures.
1. Creating and Spiffing Up Reports.
2. Printing Beautiful Reports.
3. Creating Charts and Graphs from Your Data.

Book 6: Automation with Macros.
1. Making Macros Do the Work.
2. Making Macros Smarter.

Book 7: Database Administration.
1. Database Housekeeping.
2. Sharing the Fun: Managing Multiuser Access.
3. Securing Your Access Database.

Book 8: Programming in VBA.
1. What the Heck Is VBA?
2. Writing Code.
3. Writing Smarter Code.
4. Controlling Forms with VBA.
5. Using SQL and Recordsets.
6. Debugging Your Code.

Book 9: Going Beyond Access.
1. Automation with Other Office Programs.
2. Using Access as a Front-End to SQL Server.
3. Using Access with SharePoint.

Appendix: Installing Microsoft Access.

Index.