Access 2010
Subtitle: the missing manual
By: Matthew MacDonald
Edition: 1st ed.
Series: The missing manual; Missing manual
Publisher: Pogue Press/O'Reilly
Published: 2010
Place of publication: Sebastopol, CA
Language: eng
Number of pages: 812
ISBN-13: 9781449382377
Subjects: Microsoft Access (Computer software); Microsoft Access; Database management; Computer programs
Description: "Go from Access novice to true master with the professional database design tips and crystal-clear explanations in this book. You'll learn all the secrets of this powerful database program so you can use your data in creative ways--from creating product catalogs and publishing information online to producing invoices and reports"--Cover, p. 4.
Notes: Includes index.
Table of contents: title: Storing information in tables. Creating your first database ; Building smarter tables ; Mastering the datasheet : sorting, searching, filtering, and more ; Blocking bad data ; Linking tables with relationships; title: Manipulating data with queries. Queries that select records ; Essential query tricks ; Queries that update records ; Analyzing data with crosstab queries and pivot tables; title: Printing reports. Creating reports ; Designing advanced reports; title: Building a user interface with forms. Creating simple forms ; Designing advanced forms ; Building a navigation system; title: Programming Access. Automating tasks with macros ; Connecting macros to forms and tables ; Automating tasks with Visual Basic ; Writing smarter code; title: Sharing Access with the rest of the world. Sharing a database with multiple user ; Importing and exporting data ; Connecting Access to SQL Server ; Connecting Access to SharePoint ; Building a web database; title: Appendix. Customizing Access.