Database Fundamentals and Software Design with Microsoft Access
Learn how to use Microsoft Access to build a simple system from database design through to data entry forms and reports. Course fee $50 - $155.
-
Tue 18 Feb
- TEC-subsidised course fee for qualifying learners: $50.00 incl. GST
- $155.00 incl. GST
Sessions
Session 1
Tue 18 Feb 19:00 - Tue 18 Feb 21:00At Selwyn College, Auckland.Session 2
Tue 25 Feb 19:00 - Tue 25 Feb 21:00At Selwyn College, Auckland.Session 3
Tue 04 Mar 19:00 - Tue 04 Mar 21:00At Selwyn College, Auckland.Session 4
Tue 11 Mar 19:00 - Tue 11 Mar 21:00At Selwyn College, Auckland.Session 5
Tue 18 Mar 19:00 - Tue 18 Mar 21:00At Selwyn College, Auckland.Session 6
Tue 25 Mar 19:00 - Tue 25 Mar 21:00At Selwyn College, Auckland.Session 7
Tue 01 Apr 19:00 - Tue 01 Apr 21:00At Selwyn College, Auckland.Session 8
Tue 08 Apr 19:00 - Tue 08 Apr 21:00At Selwyn College, Auckland. -
Tue 29 Jul
- TEC-subsidised course fee for qualifying learners: $50.00 incl. GST
- $155.00 incl. GST
Sessions
Session 1
Tue 29 Jul 19:00 - Tue 29 Jul 21:00At Selwyn College, Auckland.Session 2
Tue 05 Aug 19:00 - Tue 05 Aug 21:00At Selwyn College, Auckland.Session 3
Tue 12 Aug 19:00 - Tue 12 Aug 21:00At Selwyn College, Auckland.Session 4
Tue 19 Aug 19:00 - Tue 19 Aug 21:00At Selwyn College, Auckland.Session 5
Tue 26 Aug 19:00 - Tue 26 Aug 21:00At Selwyn College, Auckland.Session 6
Tue 02 Sep 19:00 - Tue 02 Sep 21:00At Selwyn College, Auckland.Session 7
Tue 09 Sep 19:00 - Tue 09 Sep 21:00At Selwyn College, Auckland.Session 8
Tue 23 Sep 19:00 - Tue 23 Sep 21:00At Selwyn College, Auckland.
Description
Course fee subsidy
This course offers a course fee subsidy through funding from the Tertiary Education Commission (TEC) for NZ citizens, those with residency-class visas, plus their spouses with work visas or visitor visas. To qualify, registrants should be 16 years or older and not currently enrolled in a secondary school. We need to collect extra information such as age, ethnicity, educational achievement and gender for statistical purposes. You must also provide evidence of NZ citizenship, residency or refugee status. A condition of accepting a course fee subsidy is that you commit to at least 80% attendance of your course. The subsidised course fee is $50.
About the course
Come and learn how to use Microsoft Access to build a simple system from database design through to data entry forms and reports.
This course is a great introduction to database development which, with further study, can lead onto roles such as Database Developer, Database Analyst or Data Engineer. Or if you just want to build your own system for managing your recipes or church donations or virtually anything else, this course is a great start.
Course outline
- Database fundamentals 1 – entity relationship modelling
- Database fundamentals 2 – table design
- Writing Queries
- Form design 1 – Customer Maintenance
- Form design 2 – Product Maintenance
- Form design 3 – Invoice form and simple coding
- Report design – Invoice report
- Course wrap up – Extra topics at students' suggestion
Expected learning outcomes
- Understand the most common ways information is stored, structured and manipulated in databases
- Have the confidence to begin building your own software in Microsoft Access
- Get a basic understanding of SQL (Structured Query Language)
- Understanding some of the fundamentals required for database roles in IT
Who should attend?
- Professionals who want to get a better idea how data is managed and analysed in businesses
- People who want to build their own simple systems for managing information
- People who are looking to get into roles based on managing and manipulating data
To join this course, you should be confident using computers.
What to bring
A pen for note-taking, a USB stick if you wish to take your work home to practise on your own device.
About your tutor, Peter Brannan
I have worked 35 years in IT in pretty much every role from training to development, including 15 years as a Microsoft Access developer. I have written over a dozen commercial systems. I really enjoy teaching and passing on my experience and skills and getting people excited about managing data and building systems.
