[Yr11 Information Technology] MS Access Learning Resources Help

[Melissa Yuan]

Hi,

I am using this with Y10 elective

https://www.technokids.com/Store/High-School/TechnoPlanner/database-projects.aspx
there is a fair bit about input masks.

The Microsoft videos are okay https://support.office.com/en-us/article/video-what-is-access-f2338765-ff59-4cfc-b8ba-74059fcb1874?ui=en-US&rs=en-US&ad=US

Cheers, Mel


[cid:image001.jpg at 01D44910.49280190]

A CONSISTENTLY HIGH ACHIEVING INDEPENDENT GIRLS' SCHOOL

Melissa

Yuan

IT Teacher


phone:

+61 3 9830 1388

fax:

+61 3 9888 5682

email:

myuan at fintona.vic.edu.au<mailto:myuan at fintona.vic.edu.au>


79 Balwyn Road

Balwyn VIC  3103

www.fintona.vic.edu.au<http://www.fintona.vic.edu.au>



[Book a Tour]<https://www.fintona.vic.edu.au/enrolment/book_a_tour>[Video]<https://youtu.be/HeN-k6iN23w>




From: yr11it <yr11it-bounces at edulists.com.au> On Behalf Of Paul Pascoe
Sent: Thursday, 30 August 2018 12:57 PM
To: yr11it at edulists.com.au; informatics at edulists.com.au
Subject: [Yr11 Information Technology] MS Access Learning Resources Help

HI,

Apologies for any cross posts.

In VCE Computing my classes will be doing the U203 Databases Outcome soon, and we plan to use the Guided Computer Tutorials modules that have been around for a while, and cover the skills needed to learn and use Access very well.

However, I am wondering what resources other people in VCE Computing and Informatics are using to teach MS Access, in particular videos and online courses.

Input from VCE Computing and Informatics teachers would be really appreciated.

There are hundreds of Access Videos on YouTube,
but has anyone found ones that work really well for VCE students?

I have found some okay Videos on Forms and Queries that I have added to the One Note LMS we are using at School,
but I have not found good videos on validation and masking.

Designing a Simple One Table Query
https://www.youtube.com/watch?v=LUL1nnxUz_c

Basic Form with Combo Box Drop Down List
 https://www.youtube.com/watch?v=dEaQIrw3CZY

Video About Using the Property Sheet on Forms:
https://www.youtube.com/watch?v=T8QBDc1o-mo

Video About Formatting and Styling Forms (Colours etc)
https://www.youtube.com/watch?v=5MMLzgfNSlU


Any thoughts, good video or web links links, or advice please.

Thanks,
Paul Pascoe
IT Teacher
St Francis Xavier College Beaconsfield.

The information contained in this e-mail message and any attached files may be confidential information. If you are not the intended recipient any use, disclosure or copying of this e-mail is unauthorized. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and delete all copies of this transmission together with any attachments.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://edulists.com.au/pipermail/yr11it/attachments/20180910/9d9803ba/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 16019 bytes
Desc: image001.jpg
URL: <http://edulists.com.au/pipermail/yr11it/attachments/20180910/9d9803ba/attachment-0003.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 45309 bytes
Desc: image002.jpg
URL: <http://edulists.com.au/pipermail/yr11it/attachments/20180910/9d9803ba/attachment-0004.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 11443 bytes
Desc: image003.jpg
URL: <http://edulists.com.au/pipermail/yr11it/attachments/20180910/9d9803ba/attachment-0005.jpg>