Notes

Slide Show

Outline

1	Learning Access By Example
2	Application Design
3	Comp Time Design
4	Storyboard
5	Putting it Together
6	tblTeacher
7	tblAdmin
8	tblTimeEarned
9	Forms Forms can be unbound, bound to a table or bound to query/SQL. Instructions should be on the form or within context help. Menu Bars, or a Menu Screen makes it easy for users to navigate.
10	Main Form
11	Form and Subform
12	Forms and Subforms
13	Form Design View
14	Form Record Source
15	Combo Box
16	Combo Box Format
17	Combo Box Data
18	Combo Box Event
19	Event Procedure
20	Module Design
21	Public Variables and Modules
22	Recordset Query
23	SubForms
24	SubForm Record Source
25	Total a Subform
26	Totals on a Form
27	Total on a Form
28	Subform Controls
29	Linking Master and Child Forms
30	Subform Views
31	Mass Update
32	Listboxes
33	VBA – A Word
34	Listbox Row Source
35	Populate a ListBox
36	Listbox Record Source
37	Posting Data via a Query
38	Reports
39	Report Design
40	Report Sorting
41	AutoNumber Key Fields This a misunderstood topic by new users. In order to create relationships between tables you must have a primary key in the “master” table and a foreign key in the linked tables. The primary key cannot be duplicated, let Access insure this property. The user will never see this number but we will use it over and over.