Авторизация
Поиск по указателям
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
Предметный указатель
BorderStyle property (forms), pop-up calendars and
BorderStyle property (forms), status meters and
BottomMargin property (Printer object) 2nd
BoundColumn property (combo boxes) 2nd
BoundColumn property (list boxes)
buffers, levels of undo
Build button
BuildCriteria function
built-in properties 2nd 3rd
Button Wizard (Access)
buttons 2nd
buttons, changing captions
buttons, control tips
buttons, creating animated
buttons, enabling/disabling
buttons, lock identification
buttons, maximizing/minimizing
buttons, navigation 2nd 3rd
buttons, resizing considerations
Caching
caching, algorithms
caching, client/server applications and
caching, considerations
caching, object references
Calendar control 2nd 3rd
Call construct
callback functions
callback functions, adding items 2nd
callback functions, cautions with
callback functions, communicating without email
callback functions, creating
callback functions, filling list boxes via
callback functions, PowerPoint presentations
callback functions, required parameters for
callback functions, retrieving information 2nd
callback functions, selecting backup database
callback functions, sorted list of files 2nd
Cancelled property (forms)
CanGrow property (text boxes)
CanGrow property (text boxes), changing lines to match
CanGrow property (text boxes), resizing with
CanGrow property (text boxes), suggestions for
CanShrink property (text boxes)
CanShrink property (text boxes), changing lines to match
CanShrink property (text boxes), conflict with Image control
CanShrink property (text boxes), resizing with
Caption property (buttons) 2nd
Caption property (combo boxes)
Caption property (fields)
Caption property (forms)
Caption property (labels)
Caption property (labels), creating status meters
Caption property (labels), internationalizing messages
Captions
captions, changing Access
captions, changing on buttons
captions, determining window
carry-forward feature
case conversions 2nd
case sensitivity
case sensitivity, converting to uppercase
case sensitivity, determining keypresses
case sensitivity, in queries
centimeters, conversions
Change event
Change event, accelerating multiuser applications
Change event, improving form performance
Change event, searching list boxes and 2nd
Change event, sending email
Change event, Tab control and
characters, keypresses as
Chart object 2nd 3rd
charts (Excel)
Choose function
Chr$(0) value
Chr$(34) value 2nd
class modules
class names
class names for Windows applications
class names, FindWindow function and
Classes
classes, helper
classes, inaccessible
ClassName property (controls) 2nd
Class_Initialize event handler
Click event 2nd
Click event, backing up selected objects
Click event, bookmarking records
Click event, Calendar control
Click event, carrying data forward
Click event, creating geographical map interfaces
Click event, creating status meters
Click event, dialog forms
Click event, displaying system menu
Click event, embedding sound files
Click event, flashing titlebars
Click event, handling form expansion
Click event, improving form performance
Click event, multiuser applications 2nd
Click event, navigation buttons
Click event, online help
Click event, opening multiple instances of form
Click event, passing parameters
Click event, preloading forms 2nd
Click event, recursion and
Click event, setting margins
Click event, tracking open shared databases
client/server applications
ClipCursor subroutine (Windows API)
Close event
Close event, form closing
Close event, keyboard shortcut
Close event, multiple instances of forms 2nd
Close event, preloaded forms
Close event, saving settings with
CloseButton property (forms) 2nd
CloseConnection method (CurrentProject object)
CloseCurrentDatabase method (Application object) 2nd
Cold fusion
collaborative, team-based web sites
collections
collections, multiple form instances 2nd
collections, renumbering
collections, tracking users/groups
ColorMode property (Printer object) 2nd
Colors
colors, built-in constants for
colors, highlighting current field
colors, previewing
colors, supplied with template style
Column property (list boxes)
ColumnCount property (combo boxes) 2nd
ColumnCount property (forms)
ColumnCount property (list boxes) 2nd 3rd 4th
ColumnHeadings property (queries)
ColumnHeads property (combo boxes) 2nd
ColumnHeads property (list boxes)
Columns
Columns tab (Page Setup dialog)
columns, bound columns
columns, changing settings
columns, creating reports with multiple
columns, crosstab query minimum
columns, formatted dates
columns, semicolon and
ColumnSpacing property (Printer object)
ColumnWidths property (combo boxes) 2nd
ColumnWidths property (list boxes) 2nd 3rd
COM programs calling .NET components
Combo Boxes
combo boxes, accepting new entries
combo boxes, adding items 2nd
combo boxes, allowing N/A option
combo boxes, changing text boxes into
combo boxes, choosing default printer with
combo boxes, choosing from fixed lists
combo boxes, client/server applications and
combo boxes, controls as parameters
combo boxes, customizing report grouping
combo boxes, displaying and collecting information
combo boxes, faster loading of
combo boxes, linking values
combo boxes, omitting from templates
combo boxes, performance bottlenecks
Command buttons
command buttons, achieving exact placement
command buttons, as UI method
command buttons, communicating without email 2nd
command buttons, creating geographical map interfaces
command buttons, Name property and
command buttons, omitting from templates
command buttons, parameter queries
command buttons, PictureData property and
command buttons, resizing forms and actions of
command buttons, transparent
COMMAND.COM
COMMDLG.OCX (ActiveX control)
Common Language Runtime
common Windows File Open/Save dialogs
Communication
communication, setting up with Excel
communication, without email
Comparisons
comparisons, case-sensitive string
comparisons, non-equality
complexType XML Schema element
Concatenation
concatenation operators
concatenation, accommodating more fields with
concatenation, AutoNumber fields and
concatenation, string limitations
Connect property (tables)
ConnectionFile property (pages) 2nd
Connections
connections, client/server applications and 2nd
connections, creating and canceling
connections, dynamic to SQL Server
connections, mail merges
connections, storing information in DAPs
ConnectionString property (DataSource control)
Constants
constants for colors
constants, intrinsic Access 2nd
constants, two-quote rule and
constants, zero-length string
constructor
Constructors
constructors, parameterized, calling .NET components containing
contacts, adding
container objects 2nd
Containers collection
Containers collection, list-filling function and
Containers collection, ownership information
Containers collection, saved objects and
containers, documenting 2nd
continuous forms
continuous forms, creating multipage forms as
continuous forms, DefaultView property 2nd 3rd
control sources 2nd
ControlBox property (forms)
ControlBox property (forms), cautions using
ControlBox property (forms), eliminating menus for forms
ControlBox property (forms), preloading forms and
Controls 2nd 3rd 4th
controls, active
controls, as parameters
controls, assigning properties
controls, bound controls 2nd 3rd
controls, creating on all pages
controls, creating simple bar graphs
controls, creating status meters
controls, for page breaks
controls, label controls 2nd
controls, limitations of adding properties to
controls, navigation
controls, omitting on reports
controls, partitioning 2nd
controls, performance bottlenecks
controls, placing data in
controls, setting tab order for
controls, sizing in forms
controls, SmartTags property
ControlSource property (combo boxes)
ControlSource property (controls)
ControlSource property (controls), Calendar control
ControlSource property (controls), concatenation operators
ControlSource property (text boxes)
ControlSource property (text boxes), communicating without email
ControlSource property (text boxes), creating page-range indicator
ControlSource property (text boxes), reports with line numbers
ControlSource property (text boxes), Sum function and
ControlSourceTimerInterval property (text boxes)
ControlTipText property (buttons)
ControlTipText property (message boxes)
Cookies 2nd
Copies property (Printer object) 2nd
CopyObject action 2nd
Count property (Groups collection)
Count(*) expression
CREATE INDEX (SQL) statement
CREATE TABLE (SQL) statement 2nd
CreateGroup function (Windows shell) 2nd
CreateGroupLevel function
CreateObject function 2nd 3rd
CreateProperty method (objects) 2nd
CreateReportControl function
CreateWorkspace method (DBEngine object) 2nd 3rd
Creator user 2nd
crosstab queries
crosstab queries, aging analysis
crosstab queries, correct sorting
crosstab queries, parameters in
Current event
Current event, combo boxes
Current event, determining if new record
Current event, enabling/disabling buttons and
Current event, navigation buttons
Current event, option groups
Current event, sending email
CurrentProject object 2nd
CurrentUser function
CurrentUser function, communicating without email
CurrentUser function, form customization and
CurrentUser function, retaining editing information
CurrentUser function, tracking changes with
CurrentUser function, user-level security and
Cursor property (labels)
CursorLocation property (recordsets)
cursors 2nd
Cycle property (forms)
Cycle property (forms), control over row movement with
Cycle property (forms), creating multipage forms and
Cycle property (forms), features of
Cycle property (forms), restricting cursor movement with
DAO
DAO 3.6 Object Library
DAO and smart tag DLL
DAO type library
DAPs [See Data Access Pages]
DATA
Реклама