gogo
Amazon cover image
Image from Amazon.com

Access 2010 : the missing manual / Matthew MacDonald.

By: Material type: TextTextSeries: Missing manualPublication details: Sebastopol, CA : Pogue Press/O'Reilly, 2010.Edition: 1st edDescription: xviii, 812 p. : ill. ; 24 cm. ; pbkISBN:
  • 9781449382377 (pbk.)
  • 1449382371 (pbk.)
  • 9781449382377:
Subject(s): DDC classification:
  • 005.7565
Contents:
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 -- Manipulating data with queries. Queries that select records -- Essential query tricks -- Queries that update records -- Analyzing data with crosstab queries and pivot tables -- Printing reports. Creating reports -- Designing advanced reports -- Building a user interface with forms. Creating simple forms ; Designing advanced forms ; Building a navigation system -- Programming Access. Automating tasks with macros -- Connecting macros to forms and tables -- Automating tasks with Visual Basic -- Writing smarter code -- 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 -- Appendix. Customizing Access.
Summary: "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.
Holdings
Item type Current library Call number Copy number Status Date due Barcode
General Lending Wexford Campus Library Wexford General Lending 005.7565 (Browse shelf(Opens below)) 1 Available 78320

Includes index.

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 -- Manipulating data with queries. Queries that select records -- Essential query tricks -- Queries that update records -- Analyzing data with crosstab queries and pivot tables -- Printing reports. Creating reports -- Designing advanced reports -- Building a user interface with forms. Creating simple forms ; Designing advanced forms ; Building a navigation system -- Programming Access. Automating tasks with macros -- Connecting macros to forms and tables -- Automating tasks with Visual Basic -- Writing smarter code -- 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 -- Appendix. Customizing Access.

"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.

35.00

Powered by Koha