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

Meer over Matthew MacDonald

Matthew MacDonald

Access 2010: The Missing Manual

Name: Access 2010: The Missing Manual
Price: 46.85 EUR
Availability: InStock
Author: Matthew MacDonald

Paperback Engels 2010 1e druk 9781449382377

Kies uw druk:

1e druk | 2010 € 46,85 1e druk | 2013 € 58,31

€ 46,85

In winkelwagen

Levertijd ± 16 werkdagen

Gratis verzonden

Samenvatting

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.

- Build a database with ease. Store information to track numbers, products, documents, and more
- Customize the interface. Build your own forms to make data entry a snap
- Find what you need fast. Search, sort, and summarize huge amounts of information
- Put your data to use. Turn raw info into printed reports with attractive formatting
- Share your data. Collaborate online with SharePoint and the brand-new Access web database
- Dive into Access programming. Get tricks and techniques to automate common tasks
- Create rich data connections. Build dynamic links with SQL Server, SharePoint, and other systems

Specificaties

ISBN13:9781449382377

Trefwoorden:databases, databasebeheer, Access 2010, Office 2010, Microsoft Access

Taal:Engels

Bindwijze:paperback

Aantal pagina's:832

Uitgever:O'Reilly

Druk:1

Verschijningsdatum:11-4-2020

Hoofdrubriek:IT-management / ICT

Serie:Missing Manual (OReilly)

Thema:

UNS Databanksoftware

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Schrijf een recensie

Uw waardering

?

Log in om uw waardering te geven

Klik om uw waardering te geven

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

Meer over Matthew MacDonald

Inhoudsopgave

The Missing Credits
Introduction

Part 1: Storing Information in Tables
1. Creating Your First Database
-Understanding Access Databases
-Getting Started with Your First Database
-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, Filtering, and More
-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
-Summarizing Data
-Query Parameters

8. Queries That Update Records
-Understanding Action Queries
-Update Queries
-Append Queries
-Delete Queries
-Tutorial: Flagging Out-of-Stock Orders

9. Analyzing Data with Crosstab Queries and Pivot Tables
-Understanding Crosstab Queries
-Creating Crosstab Queries
-Pivot Tables
-Pivot Charts

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: Sharing Access with the Rest of the World
19. Sharing a Database with Multiple Users
-Opening Up Your Database to the World
-Preparing Your Database
-Playing Well with Others
-Data Corruption
-Securing Your Database

20. Importing and Exporting Data
-Case for Importing and Exporting
-Using the Clipboard
-Import and Export Operations
-Access and XML
-Collecting Info by Email

21. Connecting Access to SQL Server
-Should You Switch to SQL Server?
-Getting Started: SQL Server Express
-Creating a SQL Server Database
-Adding Objects to a SQL Server Database

22. Connecting Access to SharePoint
-Understanding SharePoint
-Setting Up SharePoint
-SharePoint and Access

23. Building a Web Database
-Understanding Web Databases
-Your First Web Database
-Publishing a Web Database
-Delving Deeper into Web Objects
-Converting an Existing Database to a Web Database

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

Afgekapt op 60 regels

Managementboek Top 100

Bekijk de volledige Managementboek Top 100

Uw winkelwagen

Access 2010: The Missing Manual

Samenvatting

Specificaties

Lezersrecensies

Over Matthew MacDonald

Andere boeken door Matthew MacDonald

Inhoudsopgave

Managementboek Top 100

Rubrieken

Producten

Auteurs

Trefwoorden

Artikelen