About Princeton Design Collaborative

Access Level 3

Advanced Form Design			Time
	Control Layout and Tab Order	Removing Control Layout from a Form and setting Tab order.	5:43
	Adding Command Buttons	Adding Command Buttons to add a new record or close the form.	2:39
	Sub Forms	How to create a subform to display information in a related table.	2:36
	Adding A Tab Control	How to Add a Tab Control to a form to break data into managable chunks.	4:37
	How to create a Navigation control to view forms.		4:25
	Conditional Formatting	How to create conditional formatting for a field in a form.	2:13

Data Validation			Time
	Field Validation	How to add field validation to a table.	3:42
	Form Validation	How to add validation to a field on a Form.	3:36

Using Macros			Time
	Macros	How to create a simple macro to open a form and display a new record	3:09
	Macros - Using conditions	How to create a macro to display records that meet certain condition	3:11
	Macros-Data Validation	How to use a macro to validate data in a form.	4:30
	Macros-Automate Data Entry	How to create a macro to update a field based on input from another field.	2:28
	Macros-Convert to VBA	How to convert a macro to VBA (Module)	1:00

Advanced Database Management			Time
	Linking a database to External Data	How to link a database to an external datasource.	2:23
	Manage a Database	How to open a database in Exclusive Mode, create a database backup and Compacitng and Repairing a database.	3:53
	Determine Object Dependency	How to determine what object a database depends on, or what objects depend on the selected object.	1:39
	Document a Database	How to document the objects of a database.	3:24
	Analyze Performance	How to analyze the Performance of a Database	1:09

Distributing and Securing a Database			Time
	Split a Database	How to split the database for mulitiple useres, creating a backend database and frontend database.	2:02
	Implementing Security: Trust enter	How to add a trust center to the database.	1:29
	Set Password	How to set a password to open the database.	1:10
	Create a Database Template	How to create a database template.	1:37
	Convert Access to Executable File	How to convert an access database to an executable file so users can't modify objects.	1:39
	Package and Sign a database	How to create a digital certificate and apply to the database.	1:41

Manage Switchboards			Time
	Create a switchboard	How to customize the ribbon to add Switchboard manager and create a switchboard.	3:52
	Moday a Switchboard	How to add items to a switchboard and modify appearance.	2:50
	Set Startup Options	How to set the Switchboard to open and hide the Navigation Pane and ribbons.	1:50
...