Access 2007: The Missing Manual

Paperback Engels 2007 1e druk 9780596527600
€ 41,11
Levertijd ± 16 werkdagen
Gratis verzonden

Samenvatting

Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or 'Ribbon') that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help.

'Access 2007: The Missing Manual' was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.

Specificaties

ISBN13:9780596527600
Taal:Engels
Bindwijze:paperback
Aantal pagina's:734
Uitgever:O'Reilly
Druk:1
Verschijningsdatum:28-5-2015
Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

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

Inhoudsopgave

The Missing Credits
Introduction

Part 1: Storing Information in Tables
1. Creating Your First Database
Understanding Access Databases
Getting Started
Saving and Opening Access 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
Afgekapt op 59 regels

Managementboek Top 100

€ 41,11
Levertijd ongeveer 16 werkdagen
Gratis verzonden

Rubrieken

Producten

    Auteurs

      Trefwoorden

        Artikelen

          Access 2007: The Missing Manual