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 2

Access Tutorial 2 – Building a Database and Defining Table Relationships

Key #

Time

Field Types and Properties

 

 

Adding an input mask to a field

35739

3:21

Making a field required

35740

1:47

Formatting field contents

35741

3:24

Adding fields from an existing table

35743

2:34

Using hyperlink fields

35744

1:22

Editing a hyperlink field

35745

1:23

Changing the field size

35747

3:18

Choosing number formats

35748

2:18

Choosing date/time formats

35749

2:15

Choosing a yes/no format

35750

2:14

Tables and Fields

 

 

Indexing a field

37882

1:37

Indexing multiple fields

37883

1:50

Using Validation rules and text in a table

37884

1:47

Creating a Value list

37886

2:41

Using the Attachment data type

37887

2:46

Relationships and Referential Integrity

 

 

Understanding relationships

37874

1:13

Creating a one-to-many relationship pt. 1

37875

2:08

Creating a one-to-many relationship pt. 2

37876

1:31

Creating a many-to-many relationship

37878

1:38

Enforcing referential integrity

37877

2:40

Editing and deleting relationships

37879

1:21

Modifying the relationship window

37880

2:01

Printing table relationships

37881

1:07

Importing Data

 

 

Importing from another Access database

37935

3:31

Importing spreadsheet data

37936

3:38

Importing text files pt. 1

37937

3:15

Importing text files pt. 2

37947

2:34

Linding tables from other Access database

37938

1:40