LIS 558 (2001 Fall)
- Topics week by week

(The following lists indicate specific topics
that are expected to be covered in the course.
Topics have been tentatively assigned to particular weeks
on the basis of the general course outline
and the assigned weekly readings.
This document is subject to change,
and additional topics may be introduced in response to requests
or as otherwise appropriate.)

Week 1

Functions and capabilities of database management systems
and Microsoft Access.

Sorting and filtering.
(Note that "Refresh"
does not work for record additions.
Use Shift-F9 instead.)

Choosing fields.

Sorting: ascending or descending.

Filtering: By Form, By Selection, Excluding Selection.

Advanced filter/sort.

Data Entry filter.

Removing filter/sort.

Security: opening a database for exclusive use
("Open Exclusive" menu choice);
adding, changing, and removing a password.
(Note that the "File" menu
remembers databases as opened for exclusive use or not.)

Week 9

Control structures in Visual Basic:
If, While
(or Do [{While|Until}...]...Loop,
which provides for an ExitDo option);
Select Case, For...To.

Running actions from Visual Basic:
DoCmd object.

Handling forms in Visual Basic.

OpenForm and OpenReport methods.

Close method.

Modal, Popup, and Borderstyle properties.

Hourglass method.

OnClose event.

Week 10

DAO (Data Access Objects) Database and Recordset objects.

CurrentDb function.

OpenRecordset method.

With.

Index property.

Seek method;
MoveFirst, MoveLast, MoveNext, MovePrevious methods

NoMatch property.

Delete method.

AddNew and Edit methods.

Field references ("!" operator).

Update method.

Close method.

(ADO: ActiveX Data Objects:
another way of accessing databases,
not properly integrated with Access 2000 objects:
Database is called Connection,
CurrentDb has no equivalent,
OpenRecordset is called Open,
EOF is used instead of NoMatch,
Edit is omitted,
and a Find method is added.)