Авторизация
Поиск по указателям
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
Предметный указатель
Tools menu, References dialog
Tools menu, setting caption with
Tools menu, setting default menu bars
Tools menu, Synchronize Now dialog
Tools menu, User and Group Accounts dialog 2nd
Tools menu, User and Group Permissions dialog
Tools menu, User-Level Security Wizard dialog
Top property (text boxes)
TopMargin property (Printer object)
TopValues property (query) 2nd
totals queries
totals queries, parameters in
totals queries, preventing duplicate mailing labels
totals queries, Rushmore query optimization and
Transact-SQL statements 2nd
transaction logs
TransferDatabase action
TransferSpreadsheet method (DoCmd object)
transform (XSLT)
TransformXML method
Transparent property (buttons) 2nd 3rd
twips
twips, converting from inches 2nd 3rd 4th
twips, ScaleMode property and
twips, size equivalents
two-quote rule
two-state buttons 2nd
UBound function 2nd
Ucase function
UCaseArray procedure
undo buffer
Uniform Resource Identifier (URI)
UNION (SQL) statement
UNION ALL clause
UNION queries
union queries, allowing null values
union queries, combining data
union queries, parameters in
UniqueTable property (pages)
UniqueTable property (tables)
universal data link (UDL) files 2nd
Unload event (forms)
Update method (recordsets)
Update queries
Update Smart Tags everywhere option
Update To value (select queries)
uppercase 2nd
URI (uniform resource identifier)
urn\: element
UseDefaultPrinter property (reports) 2nd
user interface (UI) 2nd
user-defined properties 2nd 3rd
UserControl property (Application object)
Usernames
usernames, communicating without email
usernames, considerations
usernames, listing users with blank passwords
usernames, retrieving current 2nd
users
Users collection 2nd 3rd
Users group
Users group, built-in group
Users group, cautions for
Users group, granting selected permissions
Users group, workgroup file and
users, adjusting applications based on
users, cautions for assigning permissions
users, classes of
users, creating security plans for
users, interaction via forms
users, manually creating
users, retrieving blank passwords
users, tracking open shared databases
users, tracking programmatically
USys prefix 2nd
ValidationRule property (fields)
Value property (text boxes)
Values
values, carrying data forward
values, obtaining for properties
Variables 2nd
variables, delimiters in string expressions
variables, filtering queries with
variables, global 2nd 3rd
variables, information requested by Access in
variables, local
variables, Option Explicit statement and
variables, passing
variables, releasing
variables, values in string expressions
variables, Workbook variables
variants
variants, arrays and 2nd 3rd
variants, bookmarks as
variants, Excel function return values as
variants, parameters and 2nd
variants, storing bitmaps as
variants, table support for
variants, usage recommendations
VBA
VBA code, writing to export multiple unrelated tables to single XML file
VBA Editor
VBA Object Browser 2nd 3rd
vbNullChar constant 2nd 3rd
vbNullString constant
VBScript
VDB function (Excel)
Verb property (OLE object)
version (language)
View menu
View menu, Code dialog 2nd
View menu, Datasheet dialog
View menu, Debug Window dialog
View menu, Form Header/Footer dialog
View menu, HTML Source dialog
View menu, Options dialog
View menu, Properties dialog 2nd 3rd
View menu, Sorting and Grouping dialog
View menu, Tab Order dialog
View menu, Toolbars and Customize dialog 2nd
View SQL button 2nd 3rd
ViewsAllowed property (forms)
viruses, threat of
Visible property (Application object)
Visible property (Application object), mail merges
Visible property (Application object), purpose of
Visible property (Application object), sending data to Excel
Visible property (buttons)
Visible property (buttons), animated buttons
Visible property (buttons), creating geographical map interfaces
Visible property (buttons), creating status meters
Visible property (forms)
Visible property (forms), acFooter constant and
Visible property (forms), footer section and 2nd
Visible property (forms), suppressing printing and
Visible property (forms), syntax
Visible property (reports)
Visual Basic 4.0
Visual Basic 6.0, creating smart tag DLL
Visual Basic Editor
Visual Basic for Applications (VBA)
Visual Basic for Applications (VBA), accelerating code
Visual Basic for Applications (VBA), capabilities of
Visual Basic for Applications (VBA), creating recordsets
Visual Basic for Applications (VBA), stacks and
Visual Basic for Applications (VBA), VBA constants
Visual Basic for Applications (VBA), wrapper functions
Visual InterDev
Visual Studio .NET 2nd
Visual Studio .NET 2003
Visual Studio .NET, XSD schema files and
vowels, Soundex algorithm and
Watermarks 2nd
WAV files
WAV files, as OLE objects
WAV files, embedding sound files
WAV files, playing
weather report, creating smart tags to obtain
Weather.XML smart tag
Web
Web Part connection
Web Services
Web Services Description Language (WSDL)
web services, calling from Access
web services, calling from earlier versions of Access
web services, created with Microsoft .NET 1.0
web services, returning a DataSet
Web sites
web sites, building XML data-driven web sites with FrontPage 2003
web sites, collaborative, team-based
web sites, download for monitoring users
web sites, examples and additional information
web sites, Microsoft Access Solutions database
web sites, operating system dependencies
web, Access-connected web pages
web, posting web form data to Access database
WHERE (SQL) clause
WHERE (SQL) clause, inequality joins
WHERE (SQL) clause, obtaining median values
WHERE (SQL) clause, passing parameters to queries
WHERE (SQL) clause, Rushmore query optimizations and
WHERE (SQL) clause, similarity to report filtering syntax
WHERE (SQL) clause, string expressions and
WHERE (SQL) clause, union query restrictions
WhereCondition argument
Width property (controls) 2nd 3rd
Width property (labels)
window handles
window handles, changing Access caption and
window handles, checking if applications are running
window handles, flashing titlebars
WindowMode parameter 2nd 3rd
Windows
Windows API
Windows API, changing Access caption
Windows API, disabling screen updates with
Windows API, File Open/Save dialogs and
Windows API, GetParent function
Windows API, GetTickCount function 2nd
Windows API, IsIconic function
Windows API, navigation functions
Windows API, retrieving information via calls
Windows API, trade-offs of using
Windows API, window styles
Windows Explorer
Windows help file
Windows registry
Windows shell 2nd
Windows, class names for applications
Windows, closing applications
windows, collecting information
Windows, communication mechanisms
Windows, exiting
windows, hiding Access activity
windows, hWnd property and
Windows, languages supported
windows, minimizing flashing
windows, moving and sizing
windows, repainting 2nd
windows, retrieving list of top-level
windows, splash screens
windows, style bits for
windows, styles
Windows, under program control
WinFax Pro
WinHelp API function
WITH VIEW_METADATA option 2nd
With...End With construct 2nd
WM_CLOSE message
WM_NCPAINT message
Word
Word, embedded documents
Word, mail merges from Access to Word
Word, smart tags
Word, Windows class name for
WordPad, Windows class name for
Workgroup Administrator 2nd
workgroup files
workgroup files, consequences of losing
workgroup files, default
workgroup files, security and
workgroup files, user-level security and
Workgroup ID (WID) 2nd 3rd
workgroups
workgroups, database association with
workgroups, security based on
Workspace objects 2nd 3rd
Workspaces collection
wrapper functions
wrapper functions, adding items to Startup group
wrapper functions, adding/canceling connections 2nd
wrapper functions, Calendar control
wrapper functions, returning variable value
wrapper functions, status meters 2nd
wrappers, runtime callable
Wrkgadm.exe
WSDL (Web Services Description Language)
XML
XML schema [See also XSD]
XML Schema standard
XML Schema, primer
XML, attributes
XML, building XML data-driven web sites with FrontPage 2003
XML, elements
XML, files
XML, files, creating with smart tags
XML, files, exporting Access data to
XML, importing data into existing tables
XML, importing simple data into new table
XML, importing with schema (XSD)
XML, integrating web services into Microsoft Office solutions
XML, namespaces
XML, Overview
XML, root elements
XML, tags
xmlns\: element
XSD (XML Schema Definition) 2nd
XSD (XML Schema Definition), schema files and Visual Studio .NET
XSD (XML Schema Definition), using to import XML
XSLT (Extensible Stylesheet Language Transformations)
XSLT transform
[ ] (square brackets)
[ ] (square brackets), Access interpretation
[ ] (square brackets), as delimiters
[ ] (square brackets), embedded spaces and
[ ] (square brackets), parameters and
[ ] (square brackets), printing query parameters
\ (backslash) 2nd
| (pipes)
~ (tilde) 2nd
~TMPCLP prefix
Реклама