Авторизация
Поиск по указателям
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
Предметный указатель
Insert menu, Procedure dialog
InsideHeight property (forms) 2nd
InsideWidth property (forms) 2nd
installations, collecting information
instance handles
Instances 2nd
InStr function
integer division
Interfaces
interfaces, command-string
interfaces, creating geographical map
interop assemblies
interop assemblies for various Office applications
inventory, building
IsArray function
isCharAlpha function
isCharAlphaNumeric function
IsConnected property (CurrentProject object)
IsFormOpen function
IsIconic function
IsLoaded property (AccessObjects)
IsMissing function 2nd
IsNumeric function
ItemLayout property (Printer object) 2nd
ItemsAcross property (Printer object)
ItemSizeHeight property (Printer object) 2nd
ItemSizeWidth property (Printer object) 2nd
Java Server Pages (JSP)
Jet data types
Jet database engine
Jet database engine, Container objects
Jet database engine, creating new properties, support for
Jet database engine, Creator and Engine users
Jet database engine, db.Execute statement and
Jet database engine, metadata and
Jet database engine, multiple users and shared databases
Jet database engine, ownership information and
Jet database engine, record-level locking
Jet database engine, saved queries and
Jet database engine, security model 2nd
Jet database engine, SQL Server and
Join Properties dialog
Joins
joins, equijoins 2nd
joins, inequality joins
joins, not based on equality comparisons
joins, outer and inner joins
KeepTogether property (reports) 2nd 3rd
Key Assignment Macro option
key strokes 2nd
keyboard shortcuts
KeyDown event 2nd 3rd
KeyPress event 2nd 3rd
KeyPreview property (forms) 2nd
Keys
keys, compound primary keys
keys, improving form performance
Kurt function (Excel)
Label property (forms)
labels
labels, background colors for
labels, changing default
labels, internationalizing messages
labels, limitations linking to text box
labels, using as navigation controls 2nd
Language
language, classifying characters
language, determining version
language, importance of optimizing techniques
language, internationalizing messages
LanguageSettings property (Application object)
LBound function 2nd
LCase function
LDB file extension 2nd
least-restrictive rule 2nd
Left function
left outer join
LeftMargin property (Printer object)
Len function
Let property procedure 2nd 3rd 4th
LimitToList property (combo boxes) 2nd 3rd 4th
Line method (reports) 2nd 3rd
line numbers
LinkChildFields property (subforms) 2nd
linked tables
linked tables, finding records in
linked tables, linking data tables
linked tables, linking dynamically
linked tables, options for
Linking
linking, Access and Excel
linking, Excel worksheet to database
linking, servers in SQL Server
linking, SQL Server tables dynamically
LinkMasterFields property (subforms) 2nd
list boxes
list boxes, adding items 2nd
list boxes, bound to queries
list boxes, client/server applications and
list boxes, controls as parameters
list boxes, creating permanently open
list boxes, filling with lists of files
list boxes, multiselect
list boxes, performance bottlenecks
list boxes, restrictions with binding
list boxes, selecting multiple items
ListCount property (controls)
ListFields method (fields)
ListRows property (combo boxes) 2nd
LISTS
lists, choosing from fixed lists
lists, displaying and collecting information
lists, filling drop-down
lists, obtaining tables/queries
ListWidth property (combo boxes) 2nd
Load event
Load event, adjusting applications
Load event, animated buttons
Load event, Calendar control 2nd
Load event, choosing default printer
Load event, faster loading of combo boxes and
Load event, highlighting current field
Load event, printer names list
Load event, procedure stack and
Load event, retrieving setting with
Load event, tracking open shared databases
local variables
LocalTimeToFileTime function
Locked property (controls)
Locks
locks, considerations
locks, error handling and
locks, records and
locks, setting maximum intervals
LockWindowUpdate function 2nd
LOGFILE.TXT
Logon method (Namespace)
Long Binary Data
Looping
looping, importance of optimizing when
looping, object inventory
looping, pausing applications and
looping, PowerPoint presentations
looping, retry loops
lowercase
macros
macros, as container objects
macros, AutoExec 2nd 3rd
macros, AutoKeys macro
macros, creating custom menus with
macros, event macros
macros, GoToRecord macro action
macros, key assignment 2nd
macros, keyboard shortcuts
macros, MoveSize macro action
macros, pointing to empty
macros, ShowToolbar macro action
mail merges
Mailing Label Report Wizard (Access) 2nd
Mailing labels
mailing labels, avoiding unwanted blank rows
mailing labels, graphics on
mailing labels, preventing duplicate
mailing labels, union queries
MailMerge method (Document object)
make-table queries
margin settings
mark-and-return feature
MaxButton property (forms)
Mean value
Median function (Excel) 2nd 3rd
median values
memo fields 2nd
Memory
memory, collecting information
memory, preloading forms and
memory, releasing 2nd
memory, sorting algorithm and use of
menu forms
MenuBar property (forms) 2nd
Menus 2nd
merge codes
Messages
messages, condition-based printing
messages, internationalizing
messages, sending without email
messages, SendMessage function
Metadata
Microsoft DAO 3.6 Type Library
Microsoft Data Link
Microsoft Graph 2nd
Microsoft Paint
Microsoft Script Editor
Microsoft SOAP Toolkit 3.0
Microsoft XML v 5.0 type library
MIDI files
MinButton property (forms)
MinMaxButtons property (forms) 2nd 3rd
mod operator 2nd
Modal property (forms) 2nd
Modules
Modules collection
Modules container
modules, adding new
modules, as container objects
modules, creating
modules, declarations 2nd 3rd
modules, placing procedures in
modules, preloaded forms
Mouse
mouse, checking if installed
mouse, restricting movement of
MouseDown event 2nd 3rd
MouseUp event 2nd 3rd
Move method (recordsets)
MoveLast method (recordsets)
MoveWindow function
MsgBox statement
MSNBC web site
MSODSC (Microsoft Office Data Source Control) 2nd
MSXML
MSysObjects system table 2nd
multipage forms
MultiSelect property (list boxes)
Multitasking 2nd
multiuser applications
Name property (buttons) 2nd 3rd
Name property (combo boxes) 2nd
Name property (list boxes) 2nd
Name property (objects) 2nd
Name property (reports)
Name property (text boxes) 2nd
named parameters
names, finding sound-alike
namespace declaration (XML)
NameSpace object
naming conventions
naming conventions, event properties
naming conventions, labels and controls
naming conventions, Soundex code
naming conventions, system tables and
naming conventions, usernames
navigation buttons 2nd 3rd
navigation controls
NavigationButtons property (forms)
NavigationButtons property (forms), communicating without email
NavigationButtons property (forms), creating dialog forms
NavigationButtons property (forms), creating pop-up calendars
NavigationButtons property (forms), creating status meters
NavigationButtons property (forms), navigation buttons
NET Windows Form application, printing reports from
network applications
network connections
New keyword 2nd
NewCol property (reports)
NewCurrentDatabase method (Application object)
NewRecord property (forms)
NewRecord property (forms), determining if new record 2nd
NewRecord property (forms), maximum locking intervals
NewRecord property (forms), purpose of
NewRow property (reports)
Newsgroups
NoMatch property (recordsets)
Normal form (template)
Notepad
Notepad, editing ODC files in
Notepad, VBScript and
Notepad, Windows class name for
NotInList event 2nd
Now function
Now function, communicating without email
Now function, DefaultValue property and
Now function, GetTickCount function
Now function, tracking changes with
ntfs filesystem
NULL values
null values, allowing input of
null values, as terminator
null values, checking text fields for
null values, Chr$(0)
null values, median values and
null values, plus sign and
null values, RowSource property and 2nd
number sign (#) 2nd
numeric fields 2nd
Object Browser (VBA) 2nd 3rd
Object Linking and Embedding (OLE)
Object Linking and Embedding (OLE), fields 2nd 3rd
Object Linking and Embedding (OLE), form performance and
Object Linking and Embedding (OLE), limitations of
Object Linking and Embedding (OLE), optimizing performance
Object Linking and Embedding (OLE), storing bitmaps as
Object Linking and Embedding (OLE), usage recommendations
Object Linking and Embedding (OLE), WAV files as
object variables
object variables, DAO
object variables, listing users with blank passwords
object variables, recommendations
object variables, tracking users/groups
object variables, usage recommendations
Реклама