2011 Final matric exam Question 7 Access

In a previous posting I indicated that one should go over old examination papers before the big exams. I will now add go over old examinations papers in the venue which will be used for the examinations. Exams have to have questions on a specific set of skills so exam papers ask those skills. So those skills should be practised in the venue where the exam will be written to check if the computers ‘can’ answer the questions (as well as checking learners’ skills). Most computers centres have some or other feature which is unique to them and although they may be re imaged before an examination, I always suggest ‘use’ the centre, test it. And after this question, I suggest practicing mail merge with different versions of Access and your version of Word.
Have a look at how to solve the question.

Gr 12 PAT and Access

For the Gr 12 PAT in 2011 learners have to collect some information via a survey. It is suggested that all survey information be designed to fit into a cell in a database. Information can easily be analysed using a database. Using a database it is very easy

• to add data
• to add valid data
• to add data which looks as required
• to extract what is needed with a query
• to do calculations with records in a report
• to make report look as we want it.

A group of teachers and I designed this PPT in 2003 and zipped to show learners how Access has features which can help with their PAT and data input, based on pages 165-169 of their textbook.

Gr 11 Access test

The Grade 11s did their first Access test. We all work in different ways and use different ways to get the learners to eventually succeed. So the test was an open book test, they could use the textbook to look up formulaes, etc. and they were permitted to ask 1 question. At the end there was the realisation that some learning was required and that you even have to ‘learn’ about applications!
I am so sorry that I cannot make the test available - it is probably going to be used on the Grade 12 CD for Study Opportunity - I was testing it!

Access - Introduction to

This video clip (as a swf file) or the video clip (as an html file) may be a useful introduction to Access. I do not know which is quicker to download. The html file has a quiz in it. Wait for it to download and have your speakers switched on. You should previously have downloaded and installed free Shockwave from Macromedia. Hope the clip is useful.

Access - Afrikaans Quiz on terms

Have a look at the quizzes on Access terms made by a student doing the ACE course for CAT teachers at Cape Peninsula University of Technology. There is quiz One and Two and Three. Hulle is net in Afrikaans beskikbaar.