Section: Day 13 - Creating Queries in Access | IT5507 - Fundamentals of Data Science - 2025 - XKU | Whitireia&WelTec Moodle

Home Courses Students Staff Library Help

Section: Day 13 - Creating Queries in Access | IT5507 - Fundamentals of Data Science - 2025 - XKU | Whitireia&WelTec Moodle

Main course page

-- School of Information Technology --

Fundamentals of Data Science
IT5507
- Announcements Forum
- Welcome to the Fundamentals of Data Science Course!
  
  We hope you enjoy your learning journey!
- Lecturer: Dr Hamid Mahroeian
  Email: hamid.mahroeian@whitireia.ac.nz
  
  Lecturer: Dr Harvey Ho
  Email: harvey.ho@weltec.ac.nz
- Course aim:
  To provide learners with a basic understanding of how data is modelled, stored, manipulated, and analysed using databases and visualisation techniques.
  
  Learning outcomes:
  By the end of this course, the student will be able to:
  Describe and explain data using a variety of visualization techniques and software tools.
  Analyse the data requirements of simple systems and model those requirements using conceptual and logical data modelling techniques.
  Create a simple database that includes tables, columns, primary keys, foreign keys and simple queries.
  
  Student Resources:
  Learning materials will be provided as required during the course via Moodle.
  Any other reference material will be provided by the lecturer throughout the course.
  Completion criteria:
  Students must attempt all assessments and achieve an overall grade of 50% to be successful in this course.

Day 13 - Creating Queries in Access

Day 13 - Creating Queries in Access

Once we created our database and tables in our database, now it's time to retrieve the data and information using Queries in MS Access!
- Creating Queries in Access File
- Lab 13 File
- Submit your Lab 13 here Assignment
- Exercise 1 - Films Database File
- Exercise 1 - Films Database (Template Answer) File
- Exercise 2 - Wealth File
- Exercise 2 - Wealth Database (Template Answer) File
- Exercise 3 - Films File
- Exercise 3 - Films Database (Template Answer) File
- MSAccess Tutorial 1 File
- MSAccess Tutorial 2 File
- MSAccess Tutorial 3 File
- ----------------------------------------------------------------------------------------------------------------------------------------------------------------
- Additional resources
- Create a simple select query URL
- Video Tutorial: Designing a Simple Query in MS Access File
- Video Tutorial: Using Queries in an Access Database (Comprehensive) File