Unlock the secrets to 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 use it as 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.

Includes index.

pt. 1. Storing information in tables. Creating your first database ; Building smarter tables ; Mastering the datasheet : sorting, searching, and filtering ; Blocking bad data ; Linking tables with relationships -- pt. 2. Manipulating data with queries. Queries that select records ; Essential query tricks ; Queries that summarize data ; Queries that change tables -- pt. 3. Printing reports. Creating reports ; Designing advanced reports -- pt. 4. Building a user interface with forms. Creating simple forms ; Designing advanced forms ; Building a navigation system -- pt. 5. Programming Access. Automating tasks with macros ; Connecting macros to forms and tables ; Automating tasks with Visual Basic ; Writing smarter code -- pt. 6. Going large : Access databases for many users. Sharing a database on your network ; Building an Access web app ; Linking Access to SQL Server ; Linking Access to SharePoint ; Importing and exporting data -- pt. 7. Appendix. Customizing Access.