Главная    Ex Libris    Книги    Журналы    Статьи    Серии    Каталог    Wanted    Загрузка    ХудЛит    Справка    Поиск по индексам    Поиск    Форум   
blank
Авторизация

       
blank
Поиск по указателям

blank
blank
blank
Красота
blank
Bluttman K. — Access Hacks: Tips & Tools for Wrangling Your Data
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.


Язык: en

Рубрика: Технология/

Статус предметного указателя: Готов указатель с номерами страниц

ed2k: ed2k stats

Год издания: 2005

Количество страниц: 352

Добавлена в каталог: 04.03.2007

Операции: Положить на полку | Скопировать ссылку для форума | Скопировать ID
blank
Предметный указатель
.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      
1 2
blank
Реклама
blank
blank
HR
@Mail.ru
       © Электронная библиотека попечительского совета мехмата МГУ, 2004-2026
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте