Record Display for the EPA National Library Catalog
RECORD NUMBER: 98 OF 3222Main Title | Access 2010 : the missing manual / | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Author | MacDonald, Matthew. | |||||||||||
Publisher | Pogue Press/O'Reilly, | |||||||||||
Year Published | 2010 | |||||||||||
OCLC Number | 551422122 | |||||||||||
ISBN | 9781449382377; 1449382371 | |||||||||||
Subjects | Database management--Computer programs ; Access 2010--(DE-588)7708347-7 | |||||||||||
Holdings |
|
|||||||||||
Edition | 1st ed. | |||||||||||
Collation | xviii, 812 pages : illustrations ; 24 cm. | |||||||||||
Notes | Includes index. |
|||||||||||
Contents Notes | 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"--Page 4 of cover. |