List of online resources to help home study learners improve their knowledge of Microsoft Access 2013. Includes official Microsoft Office links and videos.

 

Microsoft Online Training

Dealing with read-only queries
Can't change the data returned by a query? This course explains the most common causes and solutions, and provides links to information about other ways to deal with the problem.
http://office.microsoft.com/en-us/access-help/video-dealing-with-read-only-queries-VA104121770.aspx?CTT=5&origin=HA104030993

 

Stop a query from asking for input
To make a parameter query stop asking for input, you remove all parameters, or fix problems (usually typos in field names) in expressions.
http://office.microsoft.com/en-us/access-help/video-stop-a-query-from-asking-for-input-VA104092850.aspx?CTT=5&origin=HA104030993

 

Use parameter queries to filter your results
Learn how to add parameters to your queries so they ask for your input, such as a date or a name, before they run. Parameters are a powerful way to filter your query results.
http://office.microsoft.com/en-us/access-help/video-use-parameter-queries-to-filter-your-results-VA104092851.aspx?CTT=5&origin=HA104030993

 

Using date criteria in queries
Learn how to use date criteria in your queries. This course shows the basics, plus how to use calculated fields and filter for part of a date value, as well as how to use the DateDiff and DateAdd functions to subtract and add date values. You need to be familiar with Access queries to complete this course.
http://office.microsoft.com/en-us/access-help/video-using-date-criteria-in-queries-VA104043073.aspx?CTT=5&origin=HA104030993