Exercise 1.16: Loading and Previewing a Report. This exercise shows students how to load the existing report rptCustomerInvoices, examine it in Report view, and close it (Figure 1.31).
296 views0 answers0 votes
Exercise 1.15: Creating a Split Form. This exercise shows students how to create a split and altering the size of the panes by moving the form splitter bar. The split form is based on the table tblCustomers and is shown in Figure 1.30.
293 views0 answers0 votes
Exercise 1.14: Editing Data with a Form. This exercise shows students how to edit data using the frmCustomers form. You can change a field by moving to it and then entering a new value. •Remind students that changes made to a record are not posted to the database until you move to another record. In the case of a form, simply press PgDn (or PgUp) or click Tab a sufficient number of times to move to the next record.
335 views0 answers0 votes
Exercise 1.13: Opening an Existing Form. This exercise shows students how to open and move around the frmProducts form found in the Chapter 1 database Ch01.accdb (Figure 1.27).
313 views0 answers0 votes
Exercise 1.12: Forming a Query with “OR” Criteria. This exercise shows students how to form a query involving two different criteria columns of the tblProducts table (Figure 1.25). Walk through this example in class. It is a good example of a relatively complex query involving only one table.
325 views0 answers0 votes
Exercise 1.11: Writing a Query with an “AND” Operator. This exercise shows the students how to use the AND operator to query and display invoice lines with discount percentages greater than zero and less than 11 (Figure 1.22). Be sure to point out to students that numeric criterion values are not enclosed in quotation marks.
305 views0 answers0 votes
Exercise 1.10: Creating a One-Table Query. This exercise shows the students how to search for and select a specific customer from the tblInvoices table and return rows based on a date filter and a shipper filter—all supplied in the criteria row of the QBE grid. (See Figures 1.20 and 1.21.)
313 views0 answers0 votes
Exercise 1.9: Running a Query. This exercise shows students how to open and run an existing query, qryArcataCustomers. Remind students that they can run an existing query—one that is stored in the Queries category on the Navigation Pane. Right-click the query name and click Open or by double-clicking the query name. (We prefer the latter method because it involves fewer actions.) Please refer to the textbook exercise for further details
302 views0 answers0 votes
Exercise 1.8: Sorting and Filtering Table Rows. This exercise shows students ways to sort the tblInvoices table in ascending order by the Shipper column. The column drop-down list is used to select a unique ship date from the list. The filter restricts the rows to that date. Please refer to the textbook exercise.
298 views0 answers0 votes
Exercise 1.7: Changing a Table’s Display Characteristics. This exercise shows students how to change a column’s displayed position and width in the tblInvoices table (Figure 1.17). Remind students that changing a table’s display characteristics including column positions, widths, etc. is a cosmetic change that does not affect the underlying table’s column order or other properties. Please refer to the textbook exercise.
301 views0 answers0 votes
Exercise 1.6: Searching for a Row Containing a Particular String. This exercise shows the student how to quickly locate a customer whose street address contains a particular string. Please refer to the textbook exercise for details of how to do this.
320 views0 answers0 votes
Exercise 1.5: Opening a Table. This exercise shows the students how to open the tblCustomers table (Figure 1.14) and examines the Access’ status bar icons (Figure 1.15). The table tblCustomers contains information about Incredible Cheesecake Company customers.
311 views0 answers0 votes
Exercise 1.1: Displaying Help. This exercise shows students how to locate help. You might want to ensure that they understand how to seek context-specific help so that they can be self-sufficient when expert human advice is unavailable. Search for a couple of different terms to illustrate how help works. Also illustrate that the Access toolbar has ToolTips, which are displayed when the mouse hovers over any of the toolbar icons.
349 views0 answers0 votes
Exercise 1.4: Opening the Chapter 1 Database. This exercise shows the students how locate and open the Chapter 1 database. Although Exercise 1.3 did this already, this serves as an introduction to creating a backup of a database. Please refer to the textbook exercise.
329 views0 answers0 votes