1 / 37

Figure 2.1 The Open dialog box in the Startup window.

folders on drive C. Open dialog box. Cancel button. Figure 2.1 The Open dialog box in the Startup window. Print button. type form wiz in this text box. help on creating a form. Create a form topic. Figure 2.2 Obtaining help. highlighted database. click to open the highlighted database.

stacey
Download Presentation

Figure 2.1 The Open dialog box in the Startup window.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. folders on drive C Open dialog box Cancel button Figure 2.1 The Open dialog box in the Startup window.

  2. Print button type form wiz in this text box help on creating a form Create a form topic Figure 2.2 Obtaining help.

  3. highlighted database click to open the highlighted database click to cancel open Figure 2.3 Preparing to open a database.

  4. Database window tables, queries, and other database objects on the Object bar four tables comprise this database Figure 2.4 The Database window.

  5. menu bar toolbar three cascaded windows Expand buttons minimized window containing the tblBroker table Figure 2.5 Icons and cascaded windows.

  6. each column holds a different characteristic about the row it describes this value shows the total number of rows in the table the primary key column’s values by definition are unique for each row Figure 2.6 Example table containing employee data.

  7. query design query dynaset Figure 2.7 Example query and dynaset.

  8. text boxes navigation buttons Figure 2.8 Example form displaying an Employee table row.

  9. Figure 2.9 Example report.

  10. the Look in drop-down list database file Figure 2.10 Open Database dialog box.

  11. comments about each table list of tables in the database Figure 2.11 Database window.

  12. Datasheet view Form view Figure 2.12 Two views of the same data.

  13. tblClient table among a list of tables Datasheet view of tblClient Figure 2.13 The Client table (tblClient).

  14. New Record Filter By Selection Cut Save Help Undo Apply Filter Sort Ascending Print Preview Database Window Paste Print Copy Insert Hyperlink Filter By Form Delete Record Spelling View Format Painter Sort Descending New Object Find Figure 2.14 Table Datasheet view toolbar.

  15. Figure 2.15 Changing a table’s display characteristics.

  16. selected (network) printer designates which pages to print number of copies to print Figure 2.16 Print dialog box.

  17. click other tabs to select additional objects four tables are selected select all objects in a window Figure 2.17 Using Documentor to print out table structure information.

  18. dynaset table field roster query design query grid Figure 2.18 A query design and resulting dynaset.

  19. Figure 2.19 Show Table dialog box.

  20. QBE grid Show row selection criteria Figure 2.20 One-table query, Design view.

  21. only rows with 1015 for ClientID are selected for the dynaset Figure 2.21 One-table query dynaset.

  22. dynaset query design selection criteria Figure 2.22 Selection and projection operations with an and operator used in the criteria.

  23. Figure 2.23 Comparison operators.

  24. Figure 2.24 Logical operators.

  25. multiple criteria on two different criteria rows implements an OR between the criteria Figure 2.25 OR query and dynaset.

  26. New Object button dynaset query design calculated expression Figure 2.26 A query calculating a value with an expression.

  27. Figure 2.27 Preparing to print a query’s definition.

  28. BrokerSalary is replaced by the value of this expression only rows containing “F” are updated Figure 2.28 An update query example.

  29. delete criteria Figure 2.29 A delete query example.

  30. append values from this table to tblEmployee field names need not match Figure 2.30 An append query example.

  31. the number of records in the tblClient table current record number Next Record button Figure 2.31 A client form.

  32. no minimize or maximize button is available record count Figure 2.32 Form based on the query, qryStockValue.

  33. Figure 2.33 Broker form.

  34. Apply Filter/Remove Filter ClientID drop-down list Figure 2.34 Filter By Form example.

  35. Figure 2.35 Previewing a report.

  36. Figure 2.36 Typical AutoReport-style report.

  37. Figure 2.37 Report design.

More Related