Book description
Unlock the secrets of Access 2013 and discover how to use your data in creative ways. With this book’s easy step-by-step instructions, you’ll learn how to build and maintain a full-featured database and even turn it into a web app. You also get tips and practices from the pros for good database design—ideal whether you’re using Access for business, school, or at home.
The important stuff you need to know
- Build a database with ease. Organize and update lists, documents, catalogs, and other types of information.
- Create your own web app. Let your whole team work on a database in the cloud.
- Share your database on a network. Link your Access database to SQL Server or SharePoint.
- Customize the interface. Make data entry a breeze by building your own templates
- Find what you need fast. Search, sort, and summarize huge amounts of data in minutes.
- Put your info to use. Turn raw info into well-formatted printed reports.
- Dive into Access programming. Automate complex tasks and solve common challenges.
Publisher resources
Table of contents
- The Missing Credits
- Introduction
-
1. Storing Information in Tables
- 1. Creating Your First Database
- 2. Building Smarter Tables
- 3. Mastering the Datasheet: Sorting, Searching, and Filtering
- 4. Blocking Bad Data
- 5. Linking Tables with Relationships
-
2. Manipulating Data with Queries
- 6. Queries That Select Records
- 7. Essential Query Tricks
- 8. Queries That Summarize Data
- 9. Queries That Change Tables
- 3. Printing Reports
-
4. Building a User Interface with Forms
- 12. Creating Simple Forms
-
13. Designing Advanced Forms
- Customizing Forms in Design View
- Taking Control of Controls
- Forms and Linked Tables
- 14. Building a Navigation System
-
5. Programming Access
- 15. Automating Tasks with Macros
- 16. Connecting Macros to Forms and Tables
- 17. Automating Tasks with Visual Basic
- 18. Writing Smarter Code
-
6. Going Large: Access Databases for Many Users
- 19. Sharing a Database on Your Network
- 20. Building an Access Web App
- 21. Linking Access to SQL Server
- 22. Linking Access to SharePoint
- 23. Importing and Exporting Data
- 7. Appendix
- Index
- About the Author
- Copyright
Product information
- Title: Access 2013: The Missing Manual
- Author(s):
- Release date: April 2013
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449357412
You might also like
book
Access 2010: The Missing Manual
Unlock the secrets of this powerful database program and discover how to use your data in …
book
Access 2013 Bible
A comprehensive reference to the updated and new features of Access 2013 As the world's most …
book
Professional Access 2013 Programming
Authoritative and comprehensive coverage for building Access 2013 Solutions Access, the most popular database system in …
book
Microsoft® Access® 2013 Step by Step
Experience learning made easy—and quickly teach yourself how to build your own database with Access 2013. …