FIS 318/618 Introduction to MS Access

1
FIS 318/618Introduction to MS Access

• Oakland University
• School of Business Administration
• Accounting and Finance
• Joe Callaghan

2
Figure 2.1 The Open dialog box in the Startup
window.
3
Figure 2.2 Obtaining help.
4
Figure 2.3 Preparing to open a database.
5
Figure 2.4 The Database window.
6
Figure 2.5 Icons and cascaded windows.
7
Figure 2.6 Example table containing employee data.
8
Figure 2.7 Example query and dynaset.
9
Figure 2.8 Example form displaying an Employee
table row.
10
Figure 2.9 Example report.
11
Figure 2.10 Open Database dialog box.
12
Figure 2.11 Database window.
13
Figure 2.12 Two views of the same data.
14
Figure 2.13 The Client table (tblClient).
15
Figure 2.14 Table Datasheet view toolbar.
16
Figure 2.15 Changing a tables display
characteristics.
17
Figure 2.16 Print dialog box.
18
Figure 2.17 Using Documentor to print out table
structure information.
19
Figure 2.18 A query design and resulting dynaset.
20
Figure 2.19 Show Table dialog box.
21
Figure 2.20 One-table query, Design view.
22
Figure 2.21 One-table query dynaset.
23
Figure 2.22 Selection and projection operations
with an and operator used in the criteria.
24
Figure 2.23 Comparison operators.
25
Figure 2.24 Logical operators.
26
Figure 2.25 OR query and dynaset.
27
Figure 2.26 A query calculating a value with an
expression.
28
Figure 2.27 Preparing to print a querys
definition.
29
Figure 2.28 An update query example.
30
Figure 2.29 A delete query example.
31
Figure 2.30 An append query example.
32
Figure 2.31 A client form.
33
Figure 2.32 Form based on the query,
qryStockValue.
34
Figure 2.33 Broker form.
35
Figure 2.34 Filter By Form example.
36
Figure 2.35 Previewing a report.
37
Figure 2.36 Typical AutoReport-style report.
38
Figure 2.37 Report design.