Электронная библиотека Попечительского совета механико-математического факультета Московского государственного университета
Bluttman K. - Access Hacks: Tips & Tools for Wrangling Your Data
Скачать книгу с нашего сайта нельзя Обсудите книгу на научном форуме
Нашли опечатку? Выделите ее мышкой и нажмите Ctrl+Enter
Название: Access Hacks: Tips & Tools for Wrangling Your Data
Автор: Bluttman K.
Аннотация: As part of the Microsoft Office suite, Access has become the industry's leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is Access Hacks from O'Reilly. This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to master the program's various complexities. For experienced users, Access Hacks offers a unique collection of proven techniques and tools that enable them to take their database skills and productivity to the next level. For Access beginners, it helps them acquire a firm grasp of the program's most productive features. A smart collection of insider tips and tricks, Access Hacks covers all of the program's finer points. Among the multitude of topics addressed, it shows users how to: work with Access in multi-user environments utilize SQL queries work with external data and programs integrate Access with third-party products Just imagine: a learning process without the angst. Well, Access Hacks delivers it with ease, thanks to these down-and-dirty techniques not collected together anywhere else. Part of O'Reilly's best-selling Hacks series, Access Hacks is based on author Ken Bluttman's two decades of real-world experience in database programming and business application building. It's because of his vast experiences that the book is able to offer such a deep understanding of the program's expanding possibilities.
Язык:
Рубрика: Технология /
Статус предметного указателя: Готов указатель с номерами страниц
ed2k: ed2k stats
Год издания: 2005
Количество страниц: 352
Добавлена в каталог: 04.03.2007
Операции: Положить на полку |
Скопировать ссылку для форума | Скопировать ID
Предметный указатель
.bmp files
.jpg files
.tif files
action queries
Actions
Admin user
ADO (ActiveX Data Objects)
ADO library
ADOX library
ADOX library, datatypes
ADOX library, references
ADOX library, table creation
Alignment
And-based criteria
apostrophes
Append query
appending
appending, across databases
appending, apostrophes and
appending, failed operations
appending, Paste Append
appending, records
appending, records to log table
appending, records, log table
applications
applications, personalization
applications, third-party
applications, third-party, MSXML parser
applications, third-party, Total Access Analyzer
Arguments
audit logs
AutoExec macro
AutoExec macro, preferences and
AutoKeys macro
AutoNumber field
AutoNumber field, custom values
AutoNumber field, seeding
Back Style property
back-end databases
backdoor building
Before Update event
Before_Update event
Browsers
browsers, file download
browsers, Web
bulk updates
by letter
Can Shrink property
Cartesian products
Cascading
cascading updates
cascading, updates
cascading, updates, relationships and
case conversion
Characters 2nd 3rd 4th 5th 6th
cleanup, databases
clocks
Code
code library creation
code, arguments and
code, password protection
code, subroutines and
Coding
command-line
Compact on Close option
compacting databases
comparing tables
Compatibility
Conditional
Conditional formatting
Conditional Formatting dialog box
conditional formatting, highlighting and
conditional macro actions
conditional subtotals 2nd 3rd 4th 5th
Constants
Controls
controls, custom
controls, information about
controls, listboxes
controls, listboxes, populating
controls, listboxes, sorting
controls, Tag property and
controls, unbound
copying between tables
CreateObject function
creates
creating, tables
creating, tables, outside Access
creating, tables, with SQL Server scripts
crosstab queries
Crosstab Query Wizard
CurrentUser property
custom functions
data changes
data changes, cascading deletes
Data Definition query
Data entry
Data sources
data summaries
Data transfer
Database Splitter utility
database splitting
Database window
database window, groups 2nd
database window, objects
database window, plain
databases
databases, appending across
databases, compacting
databases, size
databases, size limits
Datatypes
DateDiff function
Dates
dates, functions and
dates, header
deleting
deleting, shortcuts
Descriptions
desktop shortcuts to databases
Dialog boxes
dialog boxes, Conditional Formatting
dialog boxes, Edit Relationships
dialog boxes, New Query
dialog boxes, Sorting and Grouping
DLookup function
Document Compare utility (Word)
domain aggregate functions
domain aggregate functions, aggregate functions and
downloading files
Edit Relationships dialog box
embedded reports
Enter event
entering
entering text
entering text, additional
entering text, tab order
entering, text
entering, text, additional
Enterprise Manager
Enumerations
Events
events, Before Update
events, Enter
events, forms
events, MouseMove
Excel
Excel data
Excel data, importing
Excel data, importing into separate tables
Excel, functions 2nd 3rd 4th
Excel, FV function
Excel, importing from 2nd 3rd 4th 5th
Excel, macro recorder
Excel, Paste Special Transpose feature 2nd
Excel, worksheet imports
execute method
Export Text Wizard
Exporting
exporting to XML 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
Expressions
expressions, subtotals
EZ Application Generator
Favorites group
Fields
fields, AutoNumber
fields, AutoNumber, custom values
fields, default values
fields, Number
fields, number fields
fields, Text
Find Unmatched Query Wizard
Focus
Formatting
Forms
forms, custom controls
forms, events
forms, keyboard shortcuts
forms, lists
forms, personalization
forms, Windows Media Player
frmKeyboardShortcuts form
function keys
Functions
functions, CreateObject
functions, creating
functions, custom
functions, dates
functions, DLookup
functions, domain aggregate
functions, Excel 2nd 3rd 4th 5th
functions, ISNULL
functions, Len
functions, Mid
FV function (Excel)
Graphics
groups
groups, adding
groups, database window
groups, Favorites
groups, macros
hiding objects
HTML
HTML, source code
Images
importing
importing, Excel
importing, Excel, noncontiguous data
importing, Excel, separate tables
importing, Excel, single table
importing, XML data 2nd 3rd 4th 5th 6th 7th 8th 9th
IN operator 2nd
inner joins
Insert operation (SQL)
INSERT statement
inserting
inserting, apostrophes and
insertion point
intellectual property
Interval property
ISNULL function
Join clause
Joins
joins, left
joins, right
junction tables
keyboard shortcuts
keyboard shortcuts, data entry
keystrokes
left join
Len function
libraries creating code libraries
LIKE operator
Limit To List property
line numbers in reports
lines in reports
listboxes
listboxes, populating
listboxes, populating, Union query and
LISTS 2nd
lists, items
lists, Limit To List property
lists, popularity
locking records
log table
lowercase text
macro recorder (Word
macros
macros, AutoExec
macros, AutoExec, personalization and
macros, AutoKeys
macros, conditional actions
macros, groups
macros, Outlook
main form
Many-to-many relationships
many-to-many relationships, exporting to XML and
method
Mid function
MouseMove
MouseMove event
MouseMove, OnTimer
MouseMove, OnTimer, clock and
movie playing
MSXML parser
MSXML parser, XML and
MSXML parser, XSLT transformation and
multiple users
multiple users, record locking
multiple users, time-out feature
multiple users, time-out feature, mouse and
multiple users, usernames
MySQL
MySQL, Access as front end 2nd 3rd 4th
MySQL, linking to tables
MySQL, tools installation
naming conventions 2nd
Navigation
navigation form
network drive
New Query dialog box
NewData argument
NOT operator
NULL values
Number fields
number fields, defaults
number fields, nulls in
object-use log
Objects
objects, descriptions
objects, groups
objects, multiple groups
objects, shortcuts
objects, unused
ODBC
On Timer event
On Timer event, clocks and
On Timer event, slideshows and
On Timer property
OnTimer
Реклама