Авторизация
Поиск по указателям
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
Предметный указатель
properties sheets, customizing images
properties sheets, displaying
properties sheets, limitations of
properties sheets, retrieving report information and
properties, calling functions directly from
properties, changing based on security level
properties, converting databases to replicated
properties, documenting
properties, example storing
properties, for dialog forms
properties, group membership and
properties, handling
properties, hidden
properties, naming conventions
properties, obtaining list of
properties, purpose of
properties, query restrictions
properties, retrieving for reports
properties, steps in assigning
properties, viewing across objects
properties, viewing for queries
Property Get procedure
Property Let procedure
property names
Queries
queries, Action 2nd
queries, adding properties to
queries, aging analysis
queries, basing DAPs on
queries, client/server applications and
queries, communicating without email
queries, creating tables with
queries, Crosstab 2nd 3rd
queries, data definition language (DDL) 2nd
queries, DELETE
queries, design-view
queries, filtering with VBA variables
queries, improving form performance and
queries, list boxes bound to
queries, obtaining field properties with
queries, offloading processing
Queries, parameter 2nd 3rd
queries, pass-through
queries, passing parameters to
queries, prefix for hidden
queries, processing steps
queries, retrieving random samples from
queries, Rushmore and
queries, saving in tables
queries, SELECT 2nd 3rd
queries, self-join
queries, to embedded SQL statements
queries, totals 2nd 3rd
queries, union 2nd 3rd
queries, UPDATE
queries, updating DAP data
queries, using case-sensitive criteria
queries, viewing property settings
Query Builder (Access) 2nd 3rd
Query by Example (QBE) grid
Query Parameters dialog 2nd 3rd
QueryDef objects 2nd
QueryDefs collection
QueryDefs collection, as persistent object
QueryDefs collection, containers instead of
QueryDefs collection, Document objects and
QueryDefs collection, lists of queries
question mark (?)
Quicksort algorithm 2nd
Quit method (Application object) 2nd 3rd
quotes
quotes, Access assumptions
quotes, as zero-length string constant
quotes, combo boxes and
quotes, date/time values and
quotes, embedded
quotes, listing users with blank passwords
quotes, WinFax Pro and
Raise method (Err object)
Random samples
Randomize subroutine
Range method (Excel)
RDS (Remote Data Services)
ReadOnly property (controls)
Recognizer interface and smart tags
record locks
record locks, customizing
record sources 2nd
RecordCount property (recordsets) 2nd
RecordLocks property (forms)
Records
records, bookmarking on forms
records, carrying data forward
records, controls for navigation through
records, determining if new
records, duplicate 2nd
records, finding in linked tables
records, finding sound-alike
records, limiting number in recordsets
records, maximum locking intervals
records, printing only matching
records, saving with editing information
RecordSelectors property (forms)
RecordSelectors property (forms), communicating without email
RecordSelectors property (forms), creating dialog forms
RecordSelectors property (forms), creating multipage forms
RecordSelectors property (forms), creating pop-up calendars
RecordSelectors property (forms), creating status meters
Recordset objects 2nd
RecordSet property (forms)
RecordsetClone property (forms) 2nd
RecordsetLabel property (recordsets) 2nd 3rd
Recordsets
recordsets, as read-only
recordsets, bookmarks and
recordsets, changing default labels
recordsets, client/server applications and
recordsets, combining data with union queries
recordsets, creating 2nd
recordsets, improving form performance
recordsets, linked tables and
recordsets, locking options and
recordsets, multiuser applications and
recordsets, NoMatch property and
recordsets, recordsets)
recordsets, Update method
recordsets, using Find methods on
RecordSource property (forms)
RecordSource property (forms), accepting new entries
RecordSource property (forms), communicating without email
RecordSource property (forms), controls as parameters
RecordSource property (forms), converting queries
RecordSource property (forms), creating multipage forms
RecordSource property (forms), multiple databases and
RecordSource property (forms), multiuser applications 2nd
RecordSource property (forms), navigation buttons
RecordSource property (forms), saving queries in tables
RecordSource property (forms), SQL statements and
RecordSource property (forms), supplying input parameters
RecordSource property (reports) 2nd
recursive relationships
ReDim statement
references
references, creating
references, deleting 2nd
references, internationalizing messages
references, locating unknown
references, object references 2nd
references, setting 2nd
referencing data from multiple databases
Referential integrity
referential integrity, cleaning out test data and
referential integrity, improving form performance and
referential integrity, indexes and
referential integrity, recursive relationships and
RegAsm utility 2nd
Regedit.exe
Regedt32.exe
Registry 2nd
Relation objects
relationships
Relationships container
relationships, adding properties to
relationships, as container objects
relationships, cleaning out test data and
relationships, recursive
Remote Data Services (RDS)
RemoveItem method (Print object)
Repaint method (forms) 2nd
RepaintObject method (DoCmd object)
RepeatSection property (reports)
replicas/replication
replicas/replication, resolving conflicts
Report Wizard (Access)
reports
Reports collection 2nd
Reports container
reports, alternating gray bars on
reports, as container objects
reports, bar graphs
reports, changing paper source
reports, changing settings
reports, controlling page breaks
reports, custom templates for
reports, customizing grouping
reports, debugging
reports, exporting to ASP or HTML
reports, hiding in design view
reports, limitations of adding properties to
reports, line numbers
reports, multiple columns
reports, printing based on conditions
reports, printing from .NET Windows Form application
reports, printing from Excel
reports, processing order 2nd
reports, retrieving properties of
reports, set to default printer
reports, smart tags and
reports, suppressing printing
Resize event 2nd 3rd
resizing
resizing, buttons
resizing, disabling for bitmaps
resizing, DoMenuItem method and
resizing, forms and screen flashing
resizing, recovering from accidental
Response argument
restrictions (forms)
ReturnsRecords property (queries)
RightMargin property (Printer object)
Rnd (random number) function
row sources
row sources, building from scratch
row sources, caveats for using queries in
row sources, SQL statements for
Rows
rows, AddNew method
rows, alternating gray bars
rows, avoiding unwanted
rows, control over movement
rows, determining if new
rows, form performance and number of
rows, manipulating buttons
rows, replication and exchange of
RowSource property (combo boxes)
RowSource property (combo boxes), accepting new entries
RowSource property (combo boxes), communicating without email
RowSource property (combo boxes), controls as parameters
RowSource property (combo boxes), customizing report grouping
RowSource property (combo boxes), improving form performance
RowSource property (combo boxes), selecting <N/A>
RowSource property (combo boxes), SQL statements and
RowSource property (combo boxes), unbound form with controls and
RowSource property (list boxes)
RowSource property (list boxes), filling 2nd 3rd
RowSource property (list boxes), modifying
RowSource property (list boxes), object inventory 2nd
RowSource property (list boxes), searching
RowSource property (list boxes), setting
RowSource property (list boxes), to Null
RowSource property (list boxes), using with Seek method
RowSource property (reports)
RowSourceType property (combo boxes)
RowSourceType property (combo boxes), accepting new entries
RowSourceType property (combo boxes), communicating without email
RowSourceType property (combo boxes), selecting <N/A>
RowSourceType property (combo boxes), unbound form with controls and
RowSourceType property (controls)
RowSourceType property (list boxes)
RowSourceType property (list boxes), adding items and
RowSourceType property (list boxes), tracking open shared databases
RowSpacing property (Printer object) 2nd
Rowversion fields
RunCode action
RunCommand statement
RunnerCalculator web service
RunningCalculator web service
RunningCalculator web service, DataSet
RunningSum property (reports) 2nd
RunPermissions property (queries)
runtime callable wrapper
Rushmore, speeding up queries with
Russell Soundex algorithm 2nd
SaveSetting function
ScaleMode property (reports)
schema information
schemas
schemas, importing XML using XSD
Screens
Scripts
Scripts collection
Scripts container
scrollbars
ScrollBars property (forms)
ScrollBars property (forms), communicating without email
ScrollBars property (forms), dialog forms
ScrollBars property (forms), navigation buttons
ScrollBars property (forms), pop-up calendars
ScrollBars property (forms), status meters
Search criteria
search criteria, asterisk in
search criteria, date variables as
search criteria, string expressions and
Section property (reports)
sections, report
security considerations
security considerations, activating
security considerations, adjusting applications
security considerations, attaching linked tables
security considerations, cautions
security considerations, CurrentUser function and
security considerations, for databases 2nd
security considerations, Hidden property and
security considerations, removing user access to queries
security considerations, sending email
security considerations, views to update data
Security Wizard
Seek method (recordsets)
Seek method (recordsets), linked tables and
Seek method (recordsets), recommendations on usage
Реклама