Microsoft Access Video Tutorials

One of the best ways to learn how a software application works is to watch it being used via screen videos. Teach-ICT.com provides many Free Video Tutorials on various software applications. Here are their training videos teaching you how to use the features of Access, Microsoft’s Office Database application. These will help you learn how to perform the following functions using Access: field and input validation, creating simple and complex queries, creating a report from a query, designing and using tables, filtering and sorting tables, and creating and customizing forms and subforms. Using these training videos, you can learn Access by watching what happens on the screen, and then try it yourself. 

Microsoft Access Video Tutorials

	Starting off
	Creating a new database
	Validation
	Validation rule and text - To allow a specific choice of options e.g. male or female
	Required Field
	Basic Input Mask
	Queries
	Creating a query from one table
	Creating a query from more than one table
	Adding a field to an existing query
	Creating an ‘OR’ query
	Creating a ‘NOT’ query
	Creating an ‘IS NULL’ query (to find blank records)
	Creating a query to search between two dates
	Creating a query using a WILDCARD
	Reports
	Creating a report from a query
	Tables
	Creating a table
	Data types – setting appropriate ones
	Design view – change from datasheet view
	Field length
	Indexed Field
	Primary Key
	Drop down list
	Records - adding new
	Relationships - creating
	Relationships - deleting
	Required Field
	Filter
	Sort
	Forms
	Creating a new form using the Wizard
	Customising your form
	Adding macro buttons
	Field - adding a missing one to a form
	Records - adding new
	Subforms
	Creating a Switchboard Form
	Setting the Switchboard to be the opening screen

Popularity: 20% [?]