Professor Gleason

Stetson UniversitySchool of Business Administration
Decision and Information Sciences
421 N. Woodland Boulevard (Unit 8398)
 386-822-7464
 pgleason@stetson.edu

 

Atomic Learning - Access Tutorial 4

Access Tutorial 4 – Creating Forms and Reports

Key #

Time

Working with Forms

 

 

Creating a simple form

34561

1:52

Working in Layout view pt. 1

34562

2:43

Working in Layout view pt. 2

34563

1:33

Creating a form using the Form wizard

34564

1:56

Creating a form from scratch

34565

2:55

Adding a field to a form

34566

1:34

Working in Design view

34567

2:47

Using a form to add, modify, and delete records

34568

2:19

Adding a Date-Picker control

35760

2:14

Adding a Combo box

35761

3:30

Adding a List box

35762

2:23

Editing values in a List box

35763

2:03

Creating a Command button

35764

2:28

Creating an Option group

35765

3:00

Using a Toggle button, Option button, and Check box control

35766

2:18

Creating a sub form

37894

2:01

Displaying a sub form calculation

37895

2:19

Opening a sub form in a new window

37896

0:42

Working with Reports

 

 

Creating a report using the Report wizard

34578

3:01

Creating a report in Layout view

35771

2:27

Modifying a report in Layout view

34580

3:03

Creating a report in Design view

34581

2:56

Adding a page header and footer

34582

3:09

Adding a report header and footer

34583

2:20

Adding current date and time to a report

35770

2:28

Inserting a page break

35772

1:39

Sorting a report

35773

2:56

Grouping a report

35774

2:41

Adding a group footer containing summary information

35775

2:05

Keeping a group together on one page

35776

1:45

Forcing a new group onto a seperate page

35777

1:31

Creating a summary report without record details

35778

1:45

Creating a calculated field in a report

35779

1:50

Beautifying Forms and Reports

 

 

Applying an AutoFormat

35781

1:05

Applying AutoFormat elements

35782

1:15

Creating a new AutoFormat

35783

1:25

Customizing an AutoFormat

35784

1:21

Applying a conditional format

35785

2:18

Aligning controls

35788

1:30

Spacing the controls horizontially and vertically

35789

1:34

Adding gridlines to a control layout

35790

1:19

Adding a rectangle and line control

35792

2:32

Adding a picture in Design view

35793

1:25

Setting the Size Mode property of an image

35794

1:52

Tiling a picture

35795

1:05

Applying a 3D effect

29782

1:36

Inserting symbols

29721

0:50