Авторизация
Поиск по указателям
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
Предметный указатель
exporting, subset of rows in table
exporting, table data to HTML, selected columns only
exporting, unrelated tables to single XML file
ExportXML method
ExportXML method, optional WhereCondition argument
Extensible Markup Language [See XML]
Extensible Stylesheet Language Transformations (XSLT)
Extensions
extensions, file
extensions, running applications associated with
extensions, sorting filename
Fact function (Excel)
FAT filesystem
Field objects
Fields
fields, adding properties to
fields, allowing null values in
fields, bound fields
fields, converting databases to replicated
fields, current fields
fields, date/time search delimiters
fields, finding median values for
fields, indexing
fields, joining tables on common
fields, listing properties
fields, multiple fields in update queries
fields, numeric fields 2nd
fields, retaining editing information
fields, Rowversion and Timestamp
fields, specifying joins in
File Open/Save dialogs
FileCopy function (Access)
FileDateTime function (Access)
FileDialog object
filenames
filenames, choosing when opening/saving
filenames, DDE interface and
filenames, Shell command and
filenames, sorting
Files
files, choosing filenames 2nd
files, compression utilities
files, connection files
files, filling list boxes with
files, playing sound files
files, running applications
files, setting time stamps
files, storing connection information
Filter property (forms) 2nd 3rd
Filtering
filtering, File Open/Save dialog and
filtering, printing matching records only
filtering, using VBA variables in queries
FilterLookup property (text boxes) 2nd
FilterOn property (reports) 2nd 3rd
Financial Symbol smart tag 2nd
Financial Symbol smart tag, allowable actions
Find method (recordsets) 2nd
FindExecutable function 2nd 3rd
FindFirst method (recordsets) 2nd 3rd
FindLast method (recordsets)
FindNext method (recordsets) 2nd
FindPrevious method (recordsets)
FindWindow function (Windows API)
Flags
flags, bit flags
flags, BOF function
flags, EOF function
flags, File Open/Save dialog
FlashWindow call 2nd
floating-point math
Focus
focus, forms receiving
focus, switching
folders, shared
fonts, highlighting current field
footers
footers, Access calculations in
footers, acFooter constant and
footers, adding to forms
footers, bound controls in
footers, for forms
footers, page-range indicators in
footers, printing different
footers, supplied with template style
For Each...Next statement
For Each...Next statement, array looping with
For Each...Next statement, array processing and
For Each...Next statement, arrays as variants and
For Each...Next statement, object inventory 2nd
For...Next statement
For...Next statement, array looping with
For...Next statement, listing users with blank passwords
For...Next statement, object inventory
For...Next statement, Rushmore query optimization and
ForceNewPage property (reports)
Foreground colors
foreign keys
Form Page wizard
Format event
Format event, adding If...Then statement to
Format event, controlling report page breaks
Format event, different headers/footers
Format event, filtering reports
Format event, Line method limitations
Format event, page totals
Format event, printing based on conditions and
Format event, section layout and
Format event, setting row width with
Format function 2nd
Format property (fields)
Format property (text boxes)
Forms 2nd
Forms collection 2nd
Forms container
forms, accelerating load time
forms, adding footer sections to
forms, adding Person smart tag
forms, as container objects
forms, bookmarking records
forms, building generic status meter
forms, calculated fields logic and
forms, centering
forms, comparing performance
forms, controls upon opening
forms, creating continuous
forms, creating custom templates for
forms, creating key assignment macros for
forms, determining if new record in
forms, disabling menus or toolbars
forms, displaying multiple pages on
forms, driving forms
forms, eliminating menus for
forms, faster performance of
forms, filtering records
forms, handling expanding
forms, limitations of adding properties to
forms, opening multiple instances
forms, parameter queries and
forms, placing code in
forms, posting web form data to Access database
forms, Printer property and
forms, providing navigation buttons
forms, receiving focus
forms, removing system menu
forms, replacing InputBox function
forms, resizing with DoMenuItem method
forms, restricting user to single row
forms, splash forms 2nd
forms, storing size and location of
forms, unbound
forms, user interaction recommendations
FROM clause
FrontPage
FrontPage 2002 and 2003
FrontPage 2003
FrontPage 2003, building XML data-driven web sites with
FrontPage 2003, Data View Web Part and
FrontPage 2003, Data View Web Part and conditionally formatting
FrontPage Database Interface Wizard
FrontPage, collecting from data and sending to Access database
FrontPage, creating Access database
FrontPage, creating web front-end to Access table
Functions
functions, arrays as return values
functions, bookmarking records
functions, called directly from event properties
functions, class names for navigation
functions, creating with Insert -> Procedure
functions, Excel
functions, executing upon enter/exit of controls
functions, Rnd function
functions, statistical functions
functions, VBA variables in queries
Get property procedure
Get property procedure, Calendar control
Get property procedure, features of
Get property procedure, status meters
GetAllSettings function
GetClassName function
GetComputerName function
GetDesktopHWnd function 2nd
GetDiskFreeSpace function 2nd
GetDriveType function
GetExitCodeProcess function 2nd
GetFileTime function
GetKeyboardType function
GetLanguageName function
GetLogicalDriveStrings function 2nd
GetNameSpace method (Namespace object)
GetObject function 2nd
GetOpenFileName function
GetOption method (Application object) 2nd 3rd
GetParent function
GetSaveFileName function
GetSetting function
GetSystemInfo function
GetSystemMetrics function 2nd
GetTickCount function 2nd
GetVersionEx function
GetVolumeInformation function
GetWindow function 2nd
GetWindowLong function 2nd
GetWindowRect function 2nd
GetWindowText function
global modules 2nd 3rd
Global variables 2nd
GlobalMemoryStatus function
GotFocus event (forms)
GoToPage method (forms)
GoToRecord macro action
graphic controls
greater than or equal to (>=) operator
grids, granularity supplied with styles
GridX property (forms)
GridY property (forms)
GroupFooter property (fields)
GroupFooter property (reports)
GroupHeader property (fields)
GroupHeader property (reports)
GROUPING
Grouping dialog (report)
grouping, customizing
grouping, in reports
grouping, mailing labels
GroupInterval property (reports)
GroupOn property (reports) 2nd
groups
Groups collection 2nd
groups, creating custom
groups, group footers
groups, group properties
groups, manipulating shell groups
groups, manually creating
groups, securing users into
groups, tracking programmatically
GrpKeepTogether property (reports)
Headers
headers for forms
headers, page-range indicators in
headers, printing different
headers, supplied with template style
Height property (text boxes)
Help button
helper classes
Hidden property (queries)
Hidden property (tables) 2nd
hpfs filesystem
HTML
HTML source
HTML tables
HTML tables, exporting data to
HTML tables, exporting data to selected columns only
HTML, exporting reports to
HTML, exporting reports to dissecting the HTML
hWnd property (forms) 2nd 3rd 4th
hWndAccessApp property (Application object)
icons
icons, collecting information
icons, flashing
icons, setting
If...Then...Else statement 2nd 3rd 4th 5th 6th 7th
image controls
image controls, determining if new record
image controls, mailing labels and
image controls, usage recommendations
images, customized
immediate If function (IIf)
immediate If function (IIf), + concatenation operator instead of
immediate If function (IIf), grouping mailing labels
immediate If function (IIf), mailing labels and
immediate If function (IIf), usage recommendations
inaccessible classes, calling
inches, twips and 2nd 3rd 4th 5th
Index objects
Indexes
indexes, adding properties to
indexes, creating tables with
indexes, fields and
indexes, finding records in linked tables
indexes, improving form performance and
indexes, recommendations
indexes, Rushmore query optimization and
indexes, search example and
indexes, tracking users/groups
indicators, creating page-range
inequality join
information
information, collecting 2nd
information, displaying
information, retrieving
information, retrieving with DAO
inner join 2nd
Input Parameter dialog
InputBox function
InputParameters property (forms)
Insert menu
Insert menu, ActiveX Control dialog 2nd
Insert menu, Custom Control dialog
Insert menu, Object dialog 2nd
Реклама