
School
of Business Administration
Decision and Information Sciences
421 N. Woodland Boulevard (Unit 8398)
386-822-7464
pgleason@stetson.edu
|
Access Tutorial 4 – Creating Forms and Reports |
Key # |
Time |
|
Working with Forms |
|
|
|
Creating a simple form |
1:52 |
|
|
Working in Layout view pt. 1 |
2:43 |
|
|
Working in Layout view pt. 2 |
1:33 |
|
|
Creating a form using the Form wizard |
1:56 |
|
|
Creating a form from scratch |
2:55 |
|
|
Adding a field to a form |
1:34 |
|
|
Working in Design view |
2:47 |
|
|
Using a form to add, modify, and delete records |
2:19 |
|
|
Adding a Date-Picker control |
2:14 |
|
|
Adding a Combo box |
3:30 |
|
|
Adding a List box |
2:23 |
|
|
Editing values in a List box |
2:03 |
|
|
Creating a Command button |
2:28 |
|
|
Creating an Option group |
3:00 |
|
|
Using a Toggle button, Option button, and Check box control |
2:18 |
|
|
Creating a sub form |
2:01 |
|
|
Displaying a sub form calculation |
2:19 |
|
|
Opening a sub form in a new window |
0:42 |
|
|
Working with Reports |
|
|
|
Creating a report using the Report wizard |
3:01 |
|
|
Creating a report in Layout view |
2:27 |
|
|
Modifying a report in Layout view |
3:03 |
|
|
Creating a report in Design view |
2:56 |
|
|
Adding a page header and footer |
3:09 |
|
|
Adding a report header and footer |
2:20 |
|
|
Adding current date and time to a report |
2:28 |
|
|
Inserting a page break |
1:39 |
|
|
Sorting a report |
2:56 |
|
|
Grouping a report |
2:41 |
|
|
Adding a group footer containing summary information |
2:05 |
|
|
Keeping a group together on one page |
1:45 |
|
|
Forcing a new group onto a seperate page |
1:31 |
|
|
Creating a summary report without record details |
1:45 |
|
|
Creating a calculated field in a report |
1:50 |
|
|
Beautifying Forms and Reports |
|
|
|
Applying an AutoFormat |
1:05 |
|
|
Applying AutoFormat elements |
1:15 |
|
|
Creating a new AutoFormat |
1:25 |
|
|
Customizing an AutoFormat |
1:21 |
|
|
Applying a conditional format |
2:18 |
|
|
Aligning controls |
1:30 |
|
|
Spacing the controls horizontially and vertically |
1:34 |
|
|
Adding gridlines to a control layout |
1:19 |
|
|
Adding a rectangle and line control |
2:32 |
|
|
Adding a picture in Design view |
1:25 |
|
|
Setting the Size Mode property of an image |
1:52 |
|
|
Tiling a picture |
1:05 |
|
|
Applying a 3D effect |
1:36 |
|
|
Inserting symbols |
0:50 |