Access solutions : tips, tricks, and secrets from Microsoft Access MVPs /

Presents a collection of tips and solutions for database problems of Access users, covering such topics as changing the sort order of reports, creating tables for SharePoint applications, implementing Soundex, using ActiveX controls, and adding custom types to forms.

Saved in:
Bibliographic Details
Online Access: Full text (MCPHS users only)
Main Author: Meyer, Arvin
Other Authors: Steele, Douglas J.
Format: Electronic eBook
Language:English
Published: Indianapolis, Ind. : Wiley, 2010
Subjects:
Local Note:ProQuest Ebook Central

MARC

LEADER 00000cam a2200000 a 4500
001 in00000252460
006 m o d
007 cr cn|||||||||
008 101115s2010 inua o 001 0 eng d
005 20240703133938.1
010 |a  2010932451 
015 |a GBB083614  |2 bnb 
016 7 |a 015600312  |2 Uk 
019 |a 729028914  |a 816597819  |a 864893901  |a 872023115  |a 888969394  |a 927493187  |a 961503774  |a 962692670  |a 966232494  |a 988411155  |a 991940371  |a 1037527650  |a 1037921137  |a 1038691322  |a 1045520473  |a 1055359227  |a 1062919496  |a 1081185161  |a 1083560434  |a 1153043267  |a 1153505024  |a 1162042929  |a 1290067768 
020 |a 9780470947548  |q (e-book) 
020 |a 0470947543  |q (e-book) 
020 |a 9780470947562  |q (e-book) 
020 |a 047094756X  |q (e-book) 
020 |a 9780470946626  |q (e-book) 
020 |a 0470946628  |q (e-book) 
020 |a 0470591684 
020 |a 9780470591680 
020 |z 9780470591680 
020 |a 9786612817540 
020 |a 6612817542 
028 0 1 |a EB00061942  |b Recorded Books 
029 1 |a AU@  |b 000053263079 
029 1 |a AU@  |b 000058014270 
029 1 |a CHNEW  |b 000612498 
029 1 |a DEBBG  |b BV041907045 
029 1 |a DEBBG  |b BV044147140 
029 1 |a DEBSZ  |b 396431569 
029 1 |a HEBIS  |b 299814904 
029 1 |a NZ1  |b 14255581 
035 |a (OCoLC)694142732  |z (OCoLC)729028914  |z (OCoLC)816597819  |z (OCoLC)864893901  |z (OCoLC)872023115  |z (OCoLC)888969394  |z (OCoLC)927493187  |z (OCoLC)961503774  |z (OCoLC)962692670  |z (OCoLC)966232494  |z (OCoLC)988411155  |z (OCoLC)991940371  |z (OCoLC)1037527650  |z (OCoLC)1037921137  |z (OCoLC)1038691322  |z (OCoLC)1045520473  |z (OCoLC)1055359227  |z (OCoLC)1062919496  |z (OCoLC)1081185161  |z (OCoLC)1083560434  |z (OCoLC)1153043267  |z (OCoLC)1153505024  |z (OCoLC)1162042929  |z (OCoLC)1290067768 
035 |a (OCoLC)ocn694142732 
040 |a E7B  |b eng  |e pn  |c E7B  |d OCLCQ  |d YDXCP  |d EBLCP  |d OCLCQ  |d B24X7  |d COD  |d OCLCQ  |d REDDC  |d OCLCQ  |d DEBSZ  |d OCLCF  |d DKDLA  |d OCLCO  |d OCLCQ  |d IDEBK  |d RECBK  |d DEBBG  |d OCLCQ  |d AZK  |d LOA  |d CNNOR  |d MOR  |d PIFAG  |d ZCU  |d LIV  |d OCLCQ  |d MERUC  |d OCLCQ  |d OCLCO  |d U3W  |d BRL  |d STF  |d WRM  |d NRAMU  |d ICG  |d INT  |d VT2  |d COO  |d OCLCQ  |d OCLCO  |d WYU  |d OCLCQ  |d A6Q  |d DKC  |d OCLCQ  |d OCLCO  |d UKCRE  |d VLY  |d BRF  |d UKAHL  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OCLCL  |d SXB 
050 4 |a QA76.9.D3  |b M49 2010eb 
082 0 4 |a 005.7565 
100 1 |a Meyer, Arvin. 
245 1 0 |a Access solutions :  |b tips, tricks, and secrets from Microsoft Access MVPs /  |c Arvin Meyer, Douglas J. Steele. 
246 1 4 |a Microsoft Access solutions 
260 |a Indianapolis, Ind. :  |b Wiley,  |c 2010. 
300 |a 1 online resource (xxviii, 541 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a data file  |2 rda 
505 0 |a Tables. Creating tables for web applications ; Alternative to the hyperlink data type ; Fill a table with numbers -- Queries. A single query to do both updates and insertions ; Using a Cartesian product to generate a calendar ; Using a multisect list box as a query parameter -- Forms. Cascading combo boxes ; Cascading combo boxes on continuous forms ; Paired list boxes ; Marquees, scrolling messages, and flashing labels ; Custom tab controls ; Simulating web-style "hover" buttons ; Custom form navigation controls ; Calendar form ; Simulating drag-and-drop in access forms ; Providing visual feedback for drag-and-drop ; Control list boxes with drag-and-drop -- Taking advantage of report capabilities. Page 1 of N for groups ; Always starting a group on an odd page for duplex printing ; Dynamically changing the sort order of a report ; Week-at-a-glance-type report ; Day-at-a-glance-type report -- Using VBA. Useful string functions ; Useful functions ; Rethinking front-end databases to back-end databases in the same folder ; SaveAsText and LoadFromText : undocumented backup and anti-corruption tricks ; Reminders : building tickler forms and utilities ; Using disconnected recordsets ; Implementing soundex -- Automating applications and ActiveX controls. Charting using Excel ; Using TreeView control ; Using the ListView control ; Adding images to the TreeView control ; Using the TreeView and ListView controls together -- Access and the web. Building an access web application ; Embedding a web control in a form ; Building a time picker in a web form : an introduction to web macros ; RSS feeds ; Detecting whether you've got Internet connectivity -- Utilities. Drilling down to data ; Utility for renaming a form's controls ; Document management using access ; Ultra-fast searching. 
520 8 |a Presents a collection of tips and solutions for database problems of Access users, covering such topics as changing the sort order of reports, creating tables for SharePoint applications, implementing Soundex, using ActiveX controls, and adding custom types to forms. 
546 |a English. 
588 0 |a Print version record. 
590 |a ProQuest Ebook Central  |b Ebook Central College Complete 
630 0 0 |a Microsoft Access. 
650 0 |a Database management. 
700 1 |a Steele, Douglas J. 
758 |i has work:  |a Access solutions (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCGkYM8GvxkrQ3GTFG8cr4q  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |a Meyer, Arvin.  |t Access solutions.  |d Indianapolis, Ind. : Wiley, 2010  |w (DLC) 2010932451 
852 |b E-Collections  |h ProQuest 
856 4 0 |u https://ebookcentral.proquest.com/lib/mcphs/detail.action?docID=589128  |z Full text (MCPHS users only)  |t 0 
938 |a Askews and Holts Library Services  |b ASKH  |n AH13356304 
938 |a Books 24x7  |b B247  |n bks00040560 
938 |a EBL - Ebook Library  |b EBLB  |n EBL589128 
938 |a ebrary  |b EBRY  |n ebr10419064 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n 281754 
938 |a Recorded Books, LLC  |b RECE  |n rbeEB00061942 
938 |a YBP Library Services  |b YANK  |n 3492534 
938 |a YBP Library Services  |b YANK  |n 12668025 
947 |a FLO  |x pq-ebc-base 
999 f f |s 261a0c39-705e-439a-97a3-498e7b895b1c  |i 35bc5f08-34a1-48e3-9c45-70aa68194d1e  |t 0 
952 f f |a Massachusetts College of Pharmacy and Health Sciences  |b Online  |c Online  |d E-Collections  |t 0  |e ProQuest  |h Other scheme 
856 4 0 |t 0  |u https://ebookcentral.proquest.com/lib/mcphs/detail.action?docID=589128  |y Full text (MCPHS users only)