Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET.

Meer over Matthew MacDonald

Matthew MacDonald

Access 2013: The Missing Manual

Name: Access 2013: The Missing Manual
Author: Matthew MacDonald

The book that should have been in the box

Specificaties

Paperback, 852 blz. | Engels

O'Reilly | 1e druk, 2013

ISBN13: 9781449357412

Rubricering

Hoofdrubriek : Computer en informatica

O'Reilly 1e druk, 2013 9781449357412

Onderdeel van serie Missing Manual (OReilly)

Kies uw druk:

1e druk | 2010 € 44,79 1e druk | 2013 € 55,74

€ 55,74

In winkelwagen

Levertijd ongeveer 16 werkdagen

Gratis verzonden

Samenvatting

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.

Specificaties

ISBN13:9781449357412

Taal:Engels

Bindwijze:paperback

Aantal pagina's:852

Uitgever:O'Reilly

Druk:1

Verschijningsdatum:11-4-2020

Hoofdrubriek:IT-management / ICT

Serie:Missing Manual (OReilly)

Over Matthew MacDonald

Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly). He has also written Excel 2007:The Missing Manual, Excel 2007 for Starters: The Missing Manual, Access 2007:The Missing Manual, and Access 2007 for Starters: The Missing Manual, all from O'Reilly.

Andere boeken door Matthew MacDonald

Bekijk alle boeken

Inhoudsopgave

The Missing Credits
Introduction

Part 1: Storing Information in Tables
1. Creating Your First Database
-Understanding Access Databases
-Starting a Database
-Building Your First Table
-Saving Databases
-Opening Databases
-The Navigation Pane

2. Building Smarter Tables
-Understanding Data Types
-Design View
-Access Data Types
-The Primary Key
-Six Principles of Database Design

3. Mastering the Datasheet: Sorting, Searching, and Filtering
-Datasheet Customization
-Datasheet Navigation
-Advanced Editing
-Printing the Datasheet

4. Blocking Bad Data
-Data Integrity Basics
-Input Masks
-Validation Rules
-Lookups

5. Linking Tables with Relationships
-Relationship Basics
-Using a Relationship
-More Exotic Relationships
-Relationship Practice

Part 2: Manipulating Data with Queries
6. Queries That Select Records
-Query Basics
-Creating Queries
-Queries and Related Tables

7. Essential Query Tricks
-Calculated Fields
-Query Functions
-Query Parameters

8. Queries That Summarize Data
-Totals Queries
-Crosstab Queries

9. Queries That Change Tables
-Understanding Action Queries
-Update Queries
-Append Queries
-Delete Queries
-Tutorial: Flagging Out-of-Stock Orders

Part 3: Printing Reports
10. Creating Reports
-Report Basics
-Printing, Previewing, and Exporting a Report
-Formatting a Report
-Filtering and Sorting a Report

11. Designing Advanced Reports
-Improving Reports in Design View
-The Report Wizard
-The Label Wizard
-Fine-Tuning Reports with Properties
-Expressions
-Grouping

Part 4: Building a User Interface with Forms
12. Creating Simple Forms
-Creating Forms
-Using Forms
-Sorting and Filtering in a Form
-Creating Fancy Forms
-The Form Wizard

13. Designing Advanced Forms
-Customizing Forms in Design View
-Taking Control of Controls
-Forms and Linked Tables

14. Building a Navigation System
-Mastering the Navigation Pane
-Building Forms with Navigation Smarts
-Navigation Forms
-Linking to Related Data

Part 5: Programming Access
15. Automating Tasks with Macros
-Macro Essentials
-Macros and Security
-Three Macro Recipes
-Managing Macros

16. Connecting Macros to Forms and Tables
-Macro-Powered Forms
-Conditional Macros
-Data Macros

17. Automating Tasks with Visual Basic
-The Visual Basic Editor
-Putting Code in a Form
-Understanding Objects
-Using Objects

18. Writing Smarter Code
-Exploring the VB Language
-Dealing with Trouble
-Deeper into Objects
-Using VB to Run a Better Business

Part 6: Going Large: Access Databases for Many Users
19. Sharing a Database on Your Network
-Opening Up Your Database to the World
-Preparing Your Database
-Playing Well with Others
-Data Corruption
-Securing Your Database

20. Building an Access Web App
-Assessing Web Apps
-Preparing for Web Apps
-Building a Simple Web App
-Running Your Web App
-Customizing Views
-Creating More Advanced Views
-Tutorial: Creating a Web App from an Access Database

21. Linking Access to SQL Server
-How Access and SQL Server Can Work Together
-Getting Started with SQL Server Express
-Building a SQL Server Database
-Editing SQL Server Tables in Access
-Migrating an Access Database to SQL Server

22. Linking Access to SharePoint
-Understanding SharePoint
-SharePoint and Access

23. Importing and Exporting Data
-Case for Importing and Exporting
-Using the Clipboard
-Import and Export Operations
-Access and XML

Part 7: Appendix
Appendix: Customizing Access
-Adding Your Favorites to the QAT
-Personalizing the Ribbon

Index