The Unofficial Guide to Microsoft Office Access 2007
Buy Rights Online Buy Rights

Rights Contact Login For More Details

More About This Title The Unofficial Guide to Microsoft Office Access 2007

English

Jim Keogh is on the faculty of New York University and Saint Peter's College in Jersey City, New Jersey where he teaches Microsoft Access and other computer courses. He was a member of the faculty at Columbia University where he developed the e-commerce tract. Keogh has spent decades developing applications for major Wall Street corporations and is the author of more than 70 books including Java Database Programming for Dummies, Unix Programming For Dummies, and Linux Programming For Dummies.

English

Acknowledgements.

Introduction.

I Getting Started.

1 Getting In and Out.

2 All About Data.

II Data Design and the Database.

3 Designing a Database.

4 Working with Tables.

5 Entering and Editing Data.

6 Filtering and Sorting.

7 Importing and Exporting Data.

III Creating Queries.

8 Creating a Query.

9 Creating Calculation Queries.

10 Creating Action Queries.

11 Working with Crosstabs and PivotTables.

IV Using Forms.

12 Designing and Using Forms.

13 Using Controls on a Form.

14 Creating Intelligent Forms.

V Creating Reports.

15 Creating a Report.

16 Enhancing and Printing a Report.

17 Generating Charts and Graphs.

VI Working with Macros.

18 Creating a Macro.

19 Using Macro Actions.

VII Database Administration.

20 Managing and Maintaining a Database.

21 Securing a Database.

22 Working with SharePoint Sites.

VIII Programming with VBA.

23 Creating Modules.

24 Writing VBA Code.

25 Using Built-In Functions.

26 Using SQL in a Procedure.

IX Appendixes.

Appendix A: Glossary.

Appendix B: Using Standard Naming Conventions.

Appendix C: Access Database Limitations.

Index.

loading