Microsoft Access 2010 in depth
Access 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Access 2010, and get more done in less time. Legendary Access expert Roger Jennings provides specific, tested, proven solutions to the problems Access database users and deve...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified]
Que Pub
2011
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629145406719 |
Tabla de Contenidos:
- Cover
- Contents
- Introduction
- Who Should Read This Book
- How This Book Is Organized
- Printed Parts and Chapters
- Online-Only Parts and Chapters
- Part IX: Programming and Converting Access Applications
- Appendixes
- The Downloadable Sample Files
- How This Book Is Designed
- Typographic Conventions Used in This Book
- Key Combinations, Menu Choices, and Filenames
- SQL Statements and Keywords in Other Languages
- Typographic Conventions Used for VBA
- Typographic Conventions Used for VBScript
- System Requirements for Access 2010
- Other Sources of Information for Access
- Books
- Internet
- I: Getting Acquainted with Access 2010
- 1 Access 2010 for Access 2007 Users: What's New
- What's New in Microsoft Office Access 2010: An Overview
- Changes to the Office 2007 Ribbon User Interface
- Security, Trusted Locations, Packages, and Certificates
- Access Web Databases and SharePoint Lists
- Application Development by Templates
- Access Macros Redux
- SQL Server 2008 [R2] Express Edition Setup
- 2 Building Simple Tracking Applications
- Creating Access Applications from Downloaded Templates
- Touring the Modified Tasks Application
- Importing and Exporting Data from and to Outlook 2010
- Integrating Objects from Other Template Databases
- 3 Navigating the Fluent User Interface
- Defining Access Functions
- Defining Access Operating Modes
- Opening the Northwind.accdb Sample Database
- Understanding Access's Table Windows
- Navigating the Home and Create Ribbons
- Using the Function Keys
- Setting Default Options
- Creating a Customized Template File
- Using Access Online Help
- Spelunking the Database Utilities
- Packaging, Signing, and Distributing an Access 2007 Database
- II: Learning the Fundamentals of Access Databases
- 4 Exploring Relational Database Theory and Practice.
- Moving from Spreadsheets to Databases
- Reliving Database History
- Defining the Structure of Relational Databases
- Conforming to Table Design Rules
- Choosing Primary Key Codes
- Maintaining Data Integrity and Accuracy
- Displaying Data with Queries and Views
- 5 Working with Access Databases and Tables
- Understanding Access Database Files
- Creating a New Access Database from Scratch
- Exploring the Properties of Tables and Fields
- Choosing Field Data Types, Sizes, and Formats
- Preparing to Add a Table Related to the Employees Table
- Setting Default Values of Fields
- Working with Relations, Key Fields, and Indexes
- Altering Fields and Relationships
- Working with Object Dependencies and Access Smart Tags
- Copying and Pasting Tables
- Using the Table Analyzer Wizard
- Generating a Data Dictionary with the Database Documenter
- 6 Entering, Editing, and Validating Access Table Data
- Using Keyboard Operations for Entering and Editing Data
- Adding Records to a Table
- Selecting, Appending, Replacing, and Deleting Table Records
- Validating Data Entry
- Adding Records to the HRActions Table
- Testing Field and Table Validation Rules
- 7 Sorting, Finding, and Filtering Data
- Sorting Table Data
- Finding Matching Records in a Table
- Replacing Matched Field Values Automatically
- Filtering Table Data
- Applying Advanced Filters and Sort Orders
- Customizing Table Datasheet View
- Copying, Exporting, and Mailing Sorted and Filtered Data
- 8 Linking, Importing, and Exporting Data
- Importing and Linking Spreadsheet Files
- Working with Microsoft Outlook and Exchange Folders
- Importing Text Files
- Working with Tables in Other Database File Formats
- Using the Linked Table Manager Add-in to Relink Tables
- Using the Access Mail Merge Wizard
- Exporting Tables to Word, Excel, PDF, and XPS Files.
- Exporting Table Data as Text Files
- Exporting Data in Other File Formats
- III: Transforming Data with Queries and PivotTables
- 9 Designing Queries for Access Databases
- Trying the Simple Query Wizard
- Using the Query Design Window
- Testing the Other Query Wizards
- Creating Other Types of Queries
- 10 Understanding Access Query Operators and Expressions
- Understanding the Elements of Expressions
- Operators
- Literals
- Identifiers
- Functions
- Intrinsic and Named Constants
- Creating Access Expressions
- 11 Creating Multitable and Crosstab Queries
- Joining Tables to Create Multitable Queries
- Using Lookup Fields in Tables
- Adding Subdatasheets to a Table or Query
- Outer, Self, and Theta Joins
- Updating Table Data with Queries
- Making All Fields of Tables Accessible
- Making Calculations on Multiple Records
- Designing Parameter Queries
- Creating Crosstab Queries
- Writing UNION Queries and Subqueries
- Creating Queries from Tables in Other Databases
- 12 Working with PivotTable and PivotChart Views
- Slicing and Dicing Data with PivotTables
- Setting PivotTable Property Values
- Exporting the PivotTable to Excel
- Optimizing Performance of PivotTables
- Formatting and Manipulating PivotCharts
- 13 Creating and Updating Access Tables with Action Queries
- Creating New Tables with Make-Table Queries
- Creating Action Queries to Append Records to a Table
- Deleting Records from a Table with an Action Query
- Updating Values of Multiple Records in a Table
- Testing Cascading Deletion and Cascading Updates
- IV: Designing Forms and Reports
- 14 Creating and Using Access Forms
- Autogenerating a Basic Transaction-Processing Form
- Form Layout View's Contextual Ribbons
- Rearranging the Default Form Layout
- Changing Form View from a Tabbed Document to a Modal Pop-up Window.
- Creating a Master/Child Form with the Form Wizard
- Generating Multiple Items and Split Forms
- Using Transaction-Processing Forms
- Modifying the Properties of a Form or Control After Testing
- 15 Designing Custom Multitable Forms
- Getting Acquainted with Form Design View's Contextual Ribbons
- Working in Form Design View
- Adding Label and Text Box Controls to a Blank Form
- Adding Group Boxes with the Wizard
- Using the Clipboard to Copy Controls to Another Form
- Adding Combo and List Boxes
- Adding an Attachment Control for Images
- Working with Tab Controls
- Optimizing the Form's Design
- Adding a History Subform to a Tab Control Page
- Adding New Records in the HRActionEntry Form
- Using the New Navigation Control and Application Parts
- Using the Web Browser Control
- Overriding the Field Properties of Tables
- Adding Page Headers and Footers for Printing Forms
- 16 Working with Simple Reports and Mailing Labels
- Categorizing Types of Access Reports
- Autogenerating a Simple Tabular Report
- Creating a Grouped Report with the Report Wizard
- Using Access's Report Ribbons
- The Print Preview Ribbon
- Modifying a Basic Wizard Report
- Adjusting Margins and Printing Conventional Reports
- Preventing Widowed Records with the Group Keep Together Property
- Printing Multicolumn Reports as Mailing Labels
- 17 Preparing Advanced Reports
- Grouping and Sorting Report Data
- Working from a Blank Report
- Incorporating Subreports
- Customizing De Novo Reports
- Mailing Reports as Attachments
- 18 Adding Graphs, PivotCharts, and PivotTables
- Generating Graphs and Charts with Microsoft Graph
- Printing Graphs or Charts in Reports
- Creating a Linked Graph from an Access Crosstab Query
- Working with PivotChart Forms
- Substituting or Adding a PivotTable in a Form
- V: Programming Databases with Macros.
- 19 Automating Access Applications with Macros and Procedures
- What Are Access Macros?
- How Do I View a Macro's Actions?
- Why Use Macros Instead of VBA?
- Exploring Access 2010's Event Repertoire
- Generating Embedded Macros with the Command Button Wizard
- Responding to Events from Combo and List Boxes
- Exploring Access 2010's Macro-based Switchboard Manager
- 20 Emulating Table Triggers with Access Data Macros
- Designing Simple Event-Driven Data Macros
- Writing and Invoking Named Data Macros
- VI: Collaborating with Access Data
- 21 Linking Access Front Ends to Access and Client/Server Tables
- Separating Tables from Access Front-End Objects
- Evaluating the Benefits of Migrating to Client/Server Databases
- Choosing a Client/Server Migration Strategy
- Upsizing a Single-File Application to SQL Server 2005 or Later
- Moving the Upsized Database to Another Server
- Linking Client/Server Tables Manually
- Writing and Executing Pass-through Queries
- Adding SQL Server User Logins with SQL Server Management Studio
- Password-Protecting and Encrypting Access Front Ends
- 22 Collaborating with Windows SharePoint Foundation 2010
- Installing SPF 2010 Under 64-Bit Windows Server 2008
- Getting Acquainted with SPF 2010
- Managing Data with Access and SharePoint 2010
- Saving an Existing Access Database in a SharePoint Document Library
- Moving Tables and Saving an Existing Database to SharePoint
- Working Offline and Synchronizing Lists
- Exporting Tables or Queries to a SharePoint List
- Linking a SharePoint List to an Access Table
- 23 Sharing Web Databases with SharePoint Server 2010
- Licensing SharePoint Server 2010
- Understanding the Role of Access Services
- Installing SharePoint Server 2010
- Creating a Web Database from a Template
- Making Design Changes to Web Databases.
- Working with a Hosted SharePoint Site.
