Child ID Access

In 2000, USC Canada produced a 15 minute educational program exploring the issue of food security. Using examples from our programs in Mali and Nepal, you’ll see how, in the communities where we work, our partners are ensuring everyone has access to enough safe and nutritious Food.

USC would like to thank Kensington Communications (www.kensingtontv.com or youtube.com/user/KensingtonTV) for their generous support in producing this video.

Duration : 0:7:54

(more…)

How to use Microsoft Access ( part 3 of 13 ) Creating a Database and a Table

Duration : 0:7:31

(more…)

How to use Microsoft Access ( part 11 of 13 ) Creating Queries and Reports

Duration : 0:5:34

(more…)

How to use Microsoft Access ( part 1 of 13 )Introductory Skills

Duration : 0:3:25

(more…)

This tutorial is only for beginning Microsoft Access users or beginning users to database software in general. This tutorial shows how to open a new database, set the tables for the database, enter data into the table, and save the database.

If you like this tutorial, or would like to see some more of my work, visit my interactive resume at http://ispace.ci.fsu.edu/~pbm07c/IR

Duration : 0:4:46

(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…)