Review tutorial going over several different types of Access queries in design view. Using text fields, number fields, wildcards, aggregate data, and calculated fields are demonstrated.
You can grab the original Access database file to experiment with at:
http://www.ralphp hillips.com/youtube/ employees-tasks-clie nts-jobslog1.accdb
Set validation rules and validation text for a particular field to improve quality of data entered. This example requires the data entry person to enter a date matches today's date or earlier.
Create a query to find records in one table that don't have entries in a corresponding table. This example looks for clients that have not been serviced during certain period of time.
Create a query to find duplicate entries in an Access table. This example looks for jobs that have been entered into a log involving the same employee on the same date.
Create a crosstab query in Access to analyze numerical data by multiple categories. This example looks at total billable work performed by employees for several different types of work performed.
Create a formula for conditional formatting that looks at the month of a particular date and determines if it is even or odd. Format the cells in the row based on that even/odd date.
Use css transition properties to make a nice photo gallery display involving a list and background images.
Demo File: http://www.ralphphil lips.com/youtube/css 3-transitions.html
Photos: http://www.flickr.co m/photos/jakez-ar-ga ll/
Use css transition properties to make a nice photo gallery display involving a list and background images.
Demo File: http://www.ralphphil lips.com/youtube/css 3-transitions.html
Photos: http://www.flickr.co m/photos/jakez-ar-ga ll/
Create a new field in an Access database query that is a formula/calculation based off of an existing field. Use aggregate functions like average and sum to display summary data about query results.
Use a combination of functions like left(), lower(), randbetween(), and concatenate() to generate usernames and passwords for a list of people.
This is a solution to a CIS 235 assignment related to text functions.
Use a combination of functions like count(), if(), find(), right(), and trim() to generate usernames and passwords for a list of people.
This is a solution to a CIS 235 assignment related to text functions.
Use a combination of functions like left(), mid(), and find() to display only the street names and cities from provided address information.
This is a solution to a CIS 235 quiz related to text functions.
