Авторизация
Поиск по указателям
Getz G., Litwin P., Baron A. — Access Cookbook
Обсудите книгу на научном форуме
Нашли опечатку? Выделите ее мышкой и нажмите Ctrl+Enter
Название: Access Cookbook
Авторы: Getz G., Litwin P., Baron A.
Аннотация: Not a reference book, and not a tutorial either, the new second edition of the highly regarded Access Cookbook is an uncommonly useful collection of solutions to problems that Access users and developers are likely to face as they attempt to build increasingly complex applications. Although using any single "recipe" in the book will more than pay back the cost of the book in terms of both hours saved and frustration thwarted, Access Cookbook, Second Edition is much more than a handy assortment of cut-and-paste code. Each of the "recipes" examine a particular problem — problems that commonly occur when you push the upper limits of Access, or ones that are likely to trip up a developer attempting to design a more elegant Access application — even some things you never knew Access could do. The authors then, in a clear, accessible, step-by-step style, present the problems' solution. Following each "recipe" are insights on how Access works, potential pitfalls, interesting programming techniques that are used in the solution, and how and why the solution works, so you can adapt the problem-solving techniques to other similar situations. Fully updated for Access 2003, Access Cookbook, Second Edition is also one of the first books to thoroughly explore new support for .NET managed code and XML. All of the practical, real-world examples have been tested for compatibility with Access 2003, Windows XP, and Windows Server 2003. This updated new edition also covers Access and SharePoint, Access and SmartTags, Access and .NET; and Access and XML. Access power users and programmers at all levels, from the relatively inexperienced to the most sophisticated, will rely on the Access Cookbook for quick solutions to gnarly problems. With a dog-eared copy of Access Cookbook at your side, you can spend your time and energy where it matters most: working on the interesting facets of your Access application, not just the time-consuming ones.
Язык:
Рубрика: Технология /
Статус предметного указателя: Готов указатель с номерами страниц
ed2k: ed2k stats
Издание: 2-nd
Год издания: 2004
Количество страниц: 840
Добавлена в каталог: 05.03.2007
Операции: Положить на полку |
Скопировать ссылку для форума | Скопировать ID
Предметный указатель
Objects
objects, backup of selected
objects, building inventory of
objects, determining existence of
objects, handling properties for
objects, importing
objects, security for selected
objects, templates and
objects, verifying consistent settings
ODBC
ODBCConnectStr property (queries)
ODC
ODE (Office Developer's Edition)
od\: element 2nd
Office 2000
Office 2003 Web Services Toolkit 2nd
Office 2003 Web Services Toolkit, serialized objects
Office Data Connection (ODC)
Office Data Connection (ODC), changing to different locations
Office Data Connection (ODC), creating files
Office Data Connection (ODC), ODC file extension
Office Data Source Control (MSODSC) 2nd
Office Developer's Edition (ODE)
Office Object Library 2nd
Office Web Components 2nd
Office XP 2nd
Office XP Web Services Toolkit 2.0
OLE
OLEDB connection string, hand-coding
OnAction property (forms)
OnActivate property (forms)
OnChange property (text boxes)
OnClick property (buttons)
OnClick property (buttons), adding lock identification
OnClick property (buttons), automation
OnClick property (buttons), cleaning out test data
OnClick property (buttons), communicating without email 2nd
OnClick property (buttons), creating geographical map interfaces
OnClick property (buttons), dynamically linking SQL Server tables
OnClick property (buttons), Excel functions
OnClose property (forms)
OnCurrent property (forms)
OnCurrent property (forms), combo boxes with <N/A> entry
OnCurrent property (forms), controls as parameters
OnCurrent property (forms), determining if new record
OnCurrent property (forms), option groups
OnEnter property (combo boxes)
OnExit property (text boxes)
OnFormat property (reports)
OnFormat property (reports), controlling page breaks
OnFormat property (reports), creating page-range indicator
OnFormat property (reports), different headers/footers
OnFormat property (reports), setting widths with
OnGotFocus property (controls) 2nd 3rd
online help, accessing programmatically
OnLoad property (forms)
OnLoad property (forms), accepting new entries 2nd
OnLoad property (forms), animated buttons
OnLoad property (forms), communicating without email
OnLostFocus property (controls)
OnNoData property (reports) 2nd
OnPrint property (reports) 2nd 3rd
OnTimer property (buttons)
OnTimer property (forms) 2nd
Open Database Connectivity (ODBC)
Open Database Connectivity (ODBC), client/server applications and
Open Database Connectivity (ODBC), linked tables and
Open Database Connectivity (ODBC), seek operations and
Open event
Open event, choosing default printer
Open event, filtering reports
Open event, initializing pop-up forms and
Open event, internationalizing messages
Open event, obtaining correct record count
Open event, OnGotFocus event and
Open event, switchboard form 2nd
OpenArgs property (forms)
OpenArgs property (forms), accepting new entries 2nd
OpenArgs property (forms), Calendar control
OpenArgs property (forms), passing information via
OpenArgs property (forms), preloading forms
OpenConnection method (CurrentProject object)
OpenCurrentDatabase method (Application object) 2nd
OpenDataAccessPages method (CurrentProject object)
OpenDatabase method (Workspace object)
OpenDatabase method (Workspace object), client/server applications and
OpenDatabase method (Workspace object), external databases and
OpenDatabase method (Workspace object), finding records in linked tables 2nd
OpenProcess function 2nd
OpenRecordset method (Recordset object)
OpenReport method (DoCmd object)
OpenReport method (DoCmd object), changing printer options
OpenReport method (DoCmd object), disabling screen display with
OpenReport method (DoCmd object), filtering reports
OpenReport method (DoCmd object), hiding reports
OpenReport method (DoCmd object), printing reports 2nd
OpenReport method (DoCmd object), selecting printer at runtime
Operating systems 2nd
Operators
operators, >= (greater than or equal to) operator
operators, AND operator 2nd 3rd
operators, Between operator
operators, concatenation operators
operators, division operators
operators, Mod operator 2nd
operators, OR operator 2nd
Optimization
optimization, applications
optimization, list-filling function code
Option Base 1 statement
Option Compare Binary statement
Option Explicit statement
option groups
option groups, customizing report grouping
option groups, language version and
option groups, security considerations
option groups, textual information and
Optional keyword
Options dialog
OR operator
OR operator, Rushmore query optimization and
OR operator, window styles and
ORDER BY (SQL) clause
ORDER BY (SQL) clause, improving form performance and
ORDER BY (SQL) clause, similarity to OrderBy property
ORDER BY (SQL) clause, union queries 2nd
OrderBy property (reports)
OrderByOn property (reports)
Orientation property (Printer object) 2nd
outer join
Outlook 2nd
Outlook 2002
Outlook, adding or editing contact information using smart tags
output devices
output devices, choosing at runtime
output devices, retrieving list of installed
output devices, setting default
OutputTo method (DoCmd object) 2nd
page breaks
Page property (reports) 2nd
page ranges
page totals
PageHeader property (reports) 2nd
Pages
pages, different headers/footers
pages, displaying multiple
Painting property (forms) 2nd 3rd
paper sources, controlling
PaperBin property (Printer object) 2nd 3rd
PaperSize property (Printer object) 2nd 3rd
ParamArray keyword 2nd
Parameter queries
parameter queries, creating recordsets based on
parameter queries, printing values
parameter queries, specifying criteria at runtime
parameter queries, using form-based prompts
parameterized constructors
parameterized constructors, calling .NET components containing
Parameters
parameters, controls as
parameters, named parameters
parameters, passed to procedures
parameters, passing arrays as
parameters, passing variable number of
parameters, printing values
parameters, square brackets and
parameters, using across multiple DAPs
parameters, using optional
Parent property (labels)
parentheses ( )
Partition function 2nd 3rd
pass-through queries 2nd
Passwords
passwords for new accounts
passwords, retrieving all blank
passwords, security model and
Paste Special dialog
Pattern matching
Performance Analyzer (Access)
performance considerations
performance considerations, accelerating load time
performance considerations, caching algorithms and
performance considerations, calculating median and
performance considerations, comparing techniques
performance considerations, forms execution
performance considerations, linked tables and
performance considerations, supplying input parameters 2nd
performance considerations, TimeInterval property and
performance considerations, tracking user changes
performance considerations, VBA code
PERMISSIONS
permissions, assigning
permissions, attaching linked tables and
permissions, granted to Users group
permissions, inheriting through groups
permissions, recommendations for assigning 2nd 3rd
permissions, Security Wizard and
permissions, updating data with views
persistence, user-defined properties and
Person Name smart tag
Person smart tag
Person smart tag, adding or editing contact information in Outlook
Person smart tag, allowable actions
Person smart tag, using with Date smart tag
Personal Identifier (PID) 2nd 3rd 4th
pessimistic locking
pessimistic locking, setting maximum locking interval for record
PgDn key
PgUp key
PHP
Picture Builder Wizard (Access)
Picture property (buttons)
Picture property (buttons), animated buttons 2nd
Picture property (buttons), Build button and
Picture property (forms)
Picture property (forms), communicating without email 2nd
Picture property (forms), removing form watermarks
PictureAlignment property (forms)
PictureData property (buttons) 2nd
PictureData property (controls)
PictureSizeMode property (forms)
PictureTiling property (forms)
PictureType property (forms)
Pipes (|)
pixels 2nd
plus sign (+) 2nd
points, compared with twips
pop-up forms
pop-up forms, accepting new entries
pop-up forms, creating
pop-up forms, creating generic calendar
pop-up forms, hWnd property and
pop-up forms, improving performance
pop-up forms, initializing 2nd
PopUp property (forms)
PopUp property (forms), creating dialog forms
PopUp property (forms), creating pop-up calendars
PopUp property (forms), creating status meters
PopUp property (forms), window placement and
Port property (Printer object) 2nd
PostMessage function 2nd
PowerPoint 2nd
PowerPoint 10.0 Object Library
PowerPoint 2002
Presentations collection
presentations, creating 2nd 3rd
Preserve keyword
primary interop assembly (PIA)
primary keys
Print event 2nd
PrintArtistReport form
Printer objects
Printer objects, Access 2002 feature
Printer objects, ColumnSpacing property
Printer objects, DataOnly property
Printer objects, information in
Printer objects, ItemLayout property 2nd
Printer objects, output ports and
Printer objects, paper source and
Printer objects, Printer property and
Printer property (Application object) 2nd
Printer property (forms/reports) 2nd 3rd
Printing
printing, adding/canceling connections
printing, based on conditions
printing, changes in Access 2002
printing, changing options
printing, choosing output device at runtime
printing, documents
printing, margin and column settings
printing, matching records only
printing, obtaining list of installed printers
printing, paper sources, controlling
printing, retrieving information about selected printer
printing, setting default printer
printing, suppressing
PrintOut method (DoCmd object)
PrintQuality property (Printer object)
procedure stacks
procedure stacks, creating global
procedure stacks, profiler and
Procedures
procedures, class modules and
procedures, creating to react to events
procedures, exit point recommendations
procedures, passing parameters to 2nd
procedures, property procedures
procedures, stored procedures 2nd 3rd
Product function (Excel)
profile stack
profilers, creating execution time
PROGMAN program 2nd
Program Manager
Project Properties Pages dialog box
Proper function (Excel)
Properties
Properties collection 2nd 3rd 4th
properties sheets
properties sheets, animated buttons
properties sheets, Build button and
Реклама