Child ID Access

Based on the fitness database, shows you how to do a query, sort, and hide a field. Access 2007 is significantly different from previous versions.

Duration : 0:3:34

(more…)

Access Queries To Make Tables, Update Append Delete Records

Duration : 0:5:25

(more…)

This video looks at the relationship between three tables: Customer, Stock and Order. It shows how to create a relationship between these three through Customer_ID, Stock_ID and shows how inside the Query to develop the relationship. Then to set out the subsequent query. Finally it looks to Calculate the Unit price of the stock against the number of stock items ordered.
If you cannot see this calculation then this is what you need to do.
Take an empty column and write the following in the field line – (I will write it in capital letters to be clear what you need to put)
CALCULATE: [EXACT PART OF 1ST CALCULATION]*[EXACT NAME OF 2ND CALCULATION]
After this when you run the query it will have worked out the 1st number times the 2nd number.

Duration : 0:10:40

(more…)

This video looks at the relationship between three tables: Customer, Stock and Order. It shows how to create a relationship between these three through Customer_ID, Stock_ID and shows how inside the Query to develop the relationship. Then to set out the subsequent query. Finally it looks to Calculate the Unit price of the stock against the number of stock items ordered.
If you cannot see this calculation then this is what you need to do.
Take an empty column and write the following in the field line – (I will write it in capital letters to be clear what you need to put)
CALCULATE: [EXACT PART OF 1ST CALCULATION]*[EXACT NAME OF 2ND CALCULATION]
After this when you run the query it will have worked out the 1st number times the 2nd number.

Duration : 0:10:40

(more…)

Learn how to use a crosstab query in Microsoft Access at www.teachUcomp.com. A clip from Mastering Access Made Easy v. 2003. http://www.teachucomp.com/tutoracmain.htm – the most comprehensive Access tutorial available. Visit us today!

Duration : 0:5:19

(more…)

Learn how to use a crosstab query in Microsoft Access at www.teachUcomp.com. A clip from Mastering Access Made Easy v. 2003. http://www.teachucomp.com/tutoracmain.htm – the most comprehensive Access tutorial available. Visit us today!

Duration : 0:5:19

(more…)

This is a simple query. Go to Access Teaching Lesson 5 for a more complex query. See this first – then quickly move on.
What I have done is to move on from the student table and the student form and then started a frontsheet so that i can move from form to form without the user having to go into the design of things. This lesson deals with asking questions of your database.

Duration : 0:4:26

(more…)

This is a simple query. Go to Access Teaching Lesson 5 for a more complex query. See this first – then quickly move on.
What I have done is to move on from the student table and the student form and then started a frontsheet so that i can move from form to form without the user having to go into the design of things. This lesson deals with asking questions of your database.

Duration : 0:4:26

(more…)

In this Microsoft Access tutorial, I will show you how to use an Append Query to track student attendance in classes. We’ll create a couple of tables and a form, then use an Append Query to transfer the data from our student table to our attendance history table. I’ll also throw in a little VBA code just to spice things up.

Duration : 0:9:6

(more…)

In this Microsoft Access tutorial, I will show you how to use an Append Query to track student attendance in classes. We’ll create a couple of tables and a form, then use an Append Query to transfer the data from our student table to our attendance history table. I’ll also throw in a little VBA code just to spice things up.

Duration : 0:9:6

(more…)