Devendra Saksena - Access 97 2000 Database Development Outside VBA
Here you can read online Devendra Saksena - Access 97 2000 Database Development Outside VBA full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2001, publisher: Wordware Publishing, Inc., genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:Access 97 2000 Database Development Outside VBA
- Author:
- Publisher:Wordware Publishing, Inc.
- Genre:
- Year:2001
- Rating:3 / 5
- Favourites:Add to favourites
- Your mark:
Access 97 2000 Database Development Outside VBA: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "Access 97 2000 Database Development Outside VBA" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
Devendra Saksena: author's other books
Who wrote Access 97 2000 Database Development Outside VBA? Find out the surname, the name of the author of the book and a list of all author's works by series.
Access 97 2000 Database Development Outside VBA — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Access 97 2000 Database Development Outside VBA" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Font size:
Interval:
Bookmark:
Cover
| title | : | Access 97-2000 Database Development Outside VBA |
| author | : | Saksena, Devendra.; Berkowitz, Neal. |
| publisher | : | Wordware Publishing |
| isbn10 | asin | : | 1556228228 |
| print isbn13 | : | 9781556228223 |
| ebook isbn13 | : | 9780585425443 |
| language | : | English |
| subject | Microsoft Access, Database management. | |
| publication date | : | 2001 |
| lcc | : | QA76.9.D3S234 2001eb |
| ddc | : | 005.75/65 |
| subject | : | Microsoft Access, Database management. |
Page i
Devendra Saksena and Neal Berkowitz
Page ii
Library of Congress Cataloging-in-Publication Data
Saksena, Devendra, 1956
Access 97-2000 database development outside VBA / by Devendra Saksena
and Neal Berkowitz.
p. cm.
Includes index.
ISBN 1-55622-822-8 (pbk.)
1. Microsoft Access. 2. Database management. I. Berkowitz, Neal.
II. Title.
QA76.9.D3 S234 2001
005.75'65--dc21 2001022321
CIP
2001, Wordware Publishing, Inc.
All Rights Reserved
2320 Los Rios Boulevard
Plano, Texas 75074
No part of this book may be reproduced in any form or by
any means without permission in writing from
Wordware Publishing, Inc.
Printed in the United States of America
ISBN 1-55622-822-8
10 9 8 7 6 5 4 3 2 1
0104
Product names mentioned are used for identification purposes only and may be trademarks of their respective companies.
All inquiries for volume purchases of this book should be addressed to Wordware Publishing, Inc., at the above address. Telephone inquiries may be made by calling:
(972) 423-0090
Page iii
Introduction | xvii |
CHAPTER 1 Introducing Access | |
1.1 Why Access? | |
1.2 What is Access? | |
1.3 How is Access Useful? | |
1.4 How to Use This Book | |
1.5 Hardware and Software Issues | |
1.6 Before We Start | |
CHAPTER 2 Tables | |
2.1 Beginning Your Work | |
Creating a Database | |
Creating a Table | |
Entering Data in Tables | |
The Importance of Tables | |
2.2 Fields | |
Classification of Fields | |
Field Properties Explained | |
The Description Property | |
Field Properties for Text Fields | |
Field Properties for Number Fields | |
Field Properties for Currency Fields | |
Field Properties for Date/Time Fields | |
Field Properties for Auto Number Fields | |
Field Properties for Yes/No Fields | |
Field Properties for Memo Fields | |
Field Properties for OLE Object Fields | |
Field Properties for Hyperlink Fields | |
Modifying Field Properties | |
How Does Lookup Work? | |
An Explanation | |
Uses of the Lookup Property | |
2.3 Some Important Topics | |
Design View | |
Mouse Tricks in Datasheet View | |
The Format Menu | |
Primary Key |
Page iv
Indexes | |
Relationships | |
More About Relationships | |
Creating a Relationship | |
2.4 Table Properties | |
Subdatasheets | |
Important Terms | |
2.5 Other Ways of Creating Tables | |
Using Datasheet View | |
Using Import Table | |
Using Drag and Drop | |
Using Table Wizard | |
Using Link Tables | |
The Linked Table Manager | |
Linking to Tables on the Web | |
2.6 Publishing Your Table on the Web | |
2.7 Naming Conventions | |
Dos and Don'ts | |
2.8 Summary | |
2.9 Exercises | |
CHAPTER 3 Queries | |
3.1 Select Queries | |
3.2 Criteria | |
The AND Condition | |
The OR Condition | |
Summing Up | |
Operators Used for Setting Criteria | |
Lesser-Used Date Operators | |
3.3 Calculated Fields | |
Explanation of the Age Expression | |
3.4 The Expression Builder | |
Viewing Functions and Operators | |
3.5 Some Useful Functions | |
Nz Function | |
IIf Function | |
The C Functions | |
DateDiff Function | |
Ampersand (&) Function | |
Plus (+) Function | |
3.6 Joining Tables and Queries | |
Creating a Relationship | |
More About Joins | |
3.7 Multi-table Queries | |
Designing a Multi-table Query |
Page v
Are Multi-table Queries Updatable? | |
3.8 Sorting | |
Selecting Top Values of a Query | |
3.9 Query Wizards | |
Simple Query Wizard | |
Copying a Query Using the Simple Query Wizard | |
Find Duplicates Query Wizard | |
Find Unmatched Query Wizard |
Font size:
Interval:
Bookmark:
Similar books «Access 97 2000 Database Development Outside VBA»
Look at similar books to Access 97 2000 Database Development Outside VBA. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Discussion, reviews of the book Access 97 2000 Database Development Outside VBA and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.