No label defined (Q4374747)
From MaRDI portal
!
This is the item page for this Wikibase entity, intended for internal use and editing purposes. Please use the normal view instead:
scientific article; zbMATH DE number 1109434
| Language | Label | Description | Also known as |
|---|---|---|---|
| default for all languages | No label defined |
||
| English | No label defined |
scientific article; zbMATH DE number 1109434 |
Statements
26 January 1998
0 references
forms
0 references
Access 97
0 references
relational database schema design
0 references
SQL expressions
0 references
Visual Basic for Applications
0 references
Dirk Ortman's book cannot be overlooked -- it has 855 pages and is of about 1.5 kg weight. It will take some space on Access 97 user's table but it deserves it as it offers quite a lot of examples and instructions based on its author's experience. It is impossible to discuss in a single review all the material covered in the book. It is primarily meant as a workbook of those database users who are not specialists in programming to help them in safe and fast application creation but it can serve also to an experienced developer as Access 97 handbook. The book starts with an explanation of foundations of the relational data model, of conceptual modelling and relational database schema design, and teaches how to represent objects and relationships in tables, how to define integrity constraints and how to work with triggers. After listing the differences between Access 95 and Access 97 the book discusses in detail table manipulations, index creation and exploiting. The longest two chaptes are devoted to querying a database and to creating and using forms. Users can see the resulting SQL expressions if they wish but the main interface is a graphical one with QBE features. Forms -- their definition, control elements, functions called from them, etc. -- are explained on more than 120 pages with many examples. Then several shorter chapters follow, teaching how to work with objects from other applications (the OLE objects -- sounds, images, Word documents, MSGraph diagrams), to cooperate with a WEB browser, to create a report. The programming language of Access is Visual Basic for Applications (VBA). The book discusses its functions, macros and control elements, SQL embedding and generation of queries using Query by form (QBF) technique. In the last chapters, replication and version management is studied and additional software is described -- Office developer tools (the former Access developer's toolkit) as well as the contents of the supplementing CD: Microsoft Internet Explorer 3.02, case tool Erwin/ERX and 5 example databases. In an appendix some useful methods and procedures are mentioned, e.g. external data importing. The author appreciates any feedback. He presents its e-main address for remarks, questions and criticisms and promisses to answer every mail.
0 references