Read more
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.
List of contents
The Missing Credits
Introduction
Part 1: Storing Information in Tables
Chapter 1: Creating Your First Database
Chapter 2: Building Smarter Tables
Chapter 3: Mastering the Datasheet: Sorting, Searching, and Filtering
Chapter 4: Blocking Bad Data
Chapter 5: Linking Tables with Relationships
Part 2: Manipulating Data with Queries
Chapter 6: Queries That Select Records
Chapter 7: Essential Query Tricks
Chapter 8: Queries That Summarize Data
Chapter 9: Queries That Change Tables
Part 3: Printing Reports
Chapter 10: Creating Reports
Chapter 11: Designing Advanced Reports
Part 4: Building a User Interface with Forms
Chapter 12: Creating Simple Forms
Chapter 13: Designing Advanced Forms
Chapter 14: Building a Navigation System
Part 5: Programming Access
Chapter 15: Automating Tasks with Macros
Chapter 16: Connecting Macros to Forms and Tables
Chapter 17: Automating Tasks with Visual Basic
Chapter 18: Writing Smarter Code
Part 6: Going Large: Access Databases for Many Users
Chapter 19: Sharing a Database on Your Network
Chapter 20: Building an Access Web App
Chapter 21: Linking Access to SQL Server
Chapter 22: Linking Access to SharePoint
Chapter 23: Importing and Exporting Data
Part 7: Appendix
About the author
Matthew MacDonald ist Programmierer und Buchautor. Er hat in unserer Missing Manual-Reihe Handbücher zu Excel, Access und zur Website-Entwicklung verfasst, außerdem ein gutes Dutzend Bücher über die .NET-Programmierung. Irgendwann davor hat er auch einmal Englische Literatur und Theoretische Physik studiert - daran kann er sich aber nur noch dunkel erinnern.
Summary
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.
