Авторизация
Поиск по указателям
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
Предметный указатель
Seek method (recordsets), saving queries in tables
Seek method (recordsets), small tables and
SELECT (SQL) statement 2nd 3rd
select case statement
Select Case statement, bookmarking records
Select Case statement, internationalizing messages
Select Case statement, list-filling functions and
Select Case statement, object existence and
Select queries
select queries, cautions using Update To value
select queries, parameters in
select queries, recursive relationships and
Selected property (list boxes)
self-join queries
semicolon (;)
semicolon (;), multiple columns and
semicolon (;), RecordsetLabel property and
semicolon (;), SQL statements and
SendKeys queue 2nd
SendMessage function 2nd
Serialization
serialized DataSet using MSXML
ServerFilter property (forms)
ServerFilterByForm property (forms)
SetFileTime function (Windows API)
SetOption method (Application object)
SetOption method (Application object), changing global options
SetOption method (Application object), keyboard shortcut 2nd
SetOption method (Application object), support for
Settings
settings, changing defaults
settings, changing margin settings
settings, consistent for objects
settings, storing
SetWindowLong function
shared databases
shared databases, communicating via
shared databases, tracking open
SharePoint Services
SharePoint Services, Data View Web Part [See Data View Web Part]
SharePoint Services, limitations
SharePoint Services, linking to data source
SharePoint Services, working with data from Access
Shell function 2nd 3rd 4th 5th
ShellExecute function (Windows API) 2nd 3rd 4th
Shift-Tab keys, cursor movement and
Shortcut menus
shortcut menus, bookmarking records
shortcut menus, Calendar control
shortcut menus, creating
shortcut menus, disabling on forms
ShortcutMenuBar property (forms) 2nd 3rd
Show Smart Tags on Forms setting
ShowGroup function (Windows shell) 2nd 3rd
ShowToolbar macro action 2nd
Simple Object Access Protocol (SOAP)
SizeMode property (bitmaps)
sizing
sizing, form controls
sizing, screen windows
Skew function (Excel)
slash (/) operator
slides
Slides collection
slides, creating
slides, creating text
Smart Tags
smart tags, conditional processing for
smart tags, creating custom
smart tags, creating custom, DLL
smart tags, creating custom, XML
smart tags, creating DLLs
smart tags, creating on table 2nd
smart tags, creating XML files
smart tags, Date [See Date smart tag]
smart tags, deleting from table
smart tags, displaying when application starts
smart tags, DLLs
smart tags, executing action without displaying smart tag
smart tags, Financial Symbol [See Financial Symbol smart tag]
smart tags, obtaining weather report with
smart tags, Person Name [See Person Name smart tag]
smart tags, saving settings in variable
smart tags, setting viewing options
smart tags, SQL Server and
smart tags, that ship with Access 2003
smart tags, unregistering
smart tags, using multiple
SmartTag objects
sndPlaySound function 2nd
Sorting
Sorting and Grouping dialog
Sorting dialog (report)
sorting, arrays
sorting, AutoNumber fields and
sorting, ORDER BY clause
sorting, reports at runtime
Sound files
sound-alike records
SOUNDEX
SourceControl property (subforms)
SourceObject property (subforms)
Space function
SpecialEffects property (text boxes)
splash forms 2nd
splash screens
SQL property (queries)
SQL Server
SQL Server Profiler
SQL Server, ADP and
SQL Server, client/server applications and
SQL Server, compared with Jet database engine
SQL Server, data types
SQL Server, development environment
SQL Server, dynamic connections
SQL Server, multiple databases
SQL Server, replication services and
SQL Server, smart tag properties
SQL Server, using views to update data
SQL Server, WITH VIEW_METADATA option
SQL statements
SQL statements, accelerating multiuser applications
SQL statements, cleaning out test data with
SQL statements, converting queries to 2nd
SQL statements, improving form performance and
SQL statements, inequality joins and
SQL statements, viewing query's
square brackets [ ]
square brackets [ ], Access interpretation
square brackets [ ], as delimiters
square brackets [ ], embedded spaces and
square brackets [ ], parameters and
square brackets [ ], printing query parameters
Src property (buttons) 2nd
stacks 2nd
stacks, Click events and
stacks, profile
stacks, VBA routines and
Startup dialog 2nd
Startup form
Startup group, adding items to
static keyword
static variables
static variables, bookmarking records and
static variables, capabilities of
static variables, maximum locking intervals
static variables, multitasking and
static variables, tracking form instances with
statistical functions
status meters, creating
StatusBarText property (controls)
Stock Quote on MSN MoneyCentral
StrComp function
StrConv function
string expressions 2nd
string expressions, concatenation limitations
string expressions, embedded quotes and
string expressions, terminating characters for
string expressions, using fixed length
subforms
subforms, debugging
subforms, filtering reports
subforms, form performance and
subforms, multipage forms with
subforms, SourceObject property and
Substitute function (Excel)
Sum function
Switch function
switchboard forms 2nd
SYD function (Excel)
Synchronization
synchronization, height of two controls
synchronization, multiple databases
synchronization, report records with form
Syntax
syntax, Excel Automation object
syntax, object and property 2nd
syntax, SQL Server objects
syntax, Windows 9x shell
SysCmd function
SysCmd function, collecting information
SysCmd function, filtering reports
SysCmd function, language version and
SysCmd function, purpose of
SysCmd function, status meter and
SysRel container
System Identifier (SID)
system objects
system registry
system tables
system tables, excluding from lists
system tables, forms as binary data in
system tables, MSysObjects and 2nd
system tables, naming conventions for
System.mdw 2nd 3rd 4th
SystemParametersInfo function
s_Generation field
Tab controls
Tab controls, capabilities of
Tab controls, form performance and
Tab controls, multipage forms
TAB key
Tab key, cursor movement and
Tab key, Cycle property and
Tab key, searching with
TableDef objects 2nd
TableDefs collection
TableDefs collection, as persistent object
TableDefs collection, Document objects and
TableDefs collection, getting separate lists of tables with
TableDefs collection, using containers instead of
Tables 2nd
Tables collection
Tables container 2nd
tables, adding properties to
tables, as container objects
tables, building structures that match XML data
tables, converting databases to replicated
tables, creating with queries
tables, exporting subset of rows
tables, exporting unrelated tables to single XML file
tables, field properties
tables, importing XML data
tables, importing XML data, into existing tables
tables, index limitations
tables, joining on common fields
tables, list boxes bound to
tables, locked
tables, relationships between
tables, Rushmore query optimization and
tables, saving queries in
tables, TableDef objects for
tables, updating data 2nd
tables, variant fields
TabStop property (controls)
Tag property (controls)
Tag property (controls), carrying data forward
Tag property (controls), internationalizing messages
Tag property (controls), usage
Templates
templates for forms and reports
templates for mail merges
test data, cleaning out
text boxes
text boxes, background colors and
text boxes, carrying data forward
text boxes, Change event and
text boxes, changing into combo boxes
text boxes, Format property and
text boxes, growing or shrinking
text boxes, internationalizing messages
text boxes, limitations of linking labels and
text boxes, page footers
text boxes, page totals
text boxes, report grouping
text fields
text fields, checking for null values
text fields, default lengths in DDL queries
Text property (text boxes)
text strings
text strings, captions as empty
text strings, changing for navigation controls
text strings, Option Compare Binary statement
text strings, parameters
TextAlign property (controls)
tilde (~) 2nd
time stamps
time stamps, client/server applications and
time stamps, communicating without email
time stamps, setting
TimeGetTime function
timeout feature
Timer event
Timer event, animated buttons 2nd
Timer event, capabilities of
Timer event, communicating without email 2nd
Timer event, flashing titlebars
Timer event, maximum locking intervals 2nd
Timer function
Timer function, comparing performance
Timer function, features of
TimerInterval property (forms) 2nd 3rd 4th 5th
titlebars 2nd
toggle buttons
toggle buttons, bookmarking records 2nd 3rd
toggle buttons, carrying data forward 2nd
Toolbars
toolbars, allowing changes to
toolbars, buttons as UI methods
toolbars, creating
toolbars, disabling on forms
toolkits that can be used by Microsoft Office programmers to call web services
Tools menu
Tools menu, bitmap splash screens and
Tools menu, Compact and Repair Database
Tools menu, Create Replica dialog
Tools menu, Database Splitter dialog
Tools menu, GetOption method and
Tools menu, Options dialog 2nd 3rd 4th 5th
Tools menu, preloading forms
Реклама