How to create run time calculation in a Database - Ms Access [Activity 18e]
Автор: Mr Ike ICT
Загружено: 2025-02-19
Просмотров: 515
#igcseict #0417 #4lT1#edexcel #edexcelict #edexcelpapers
This video will guide you on solving the given real-life scenario question using MS Access. You will learn how to perform run-time calculations in a database query. This question is from the Cambridge IGCSE ICT textbook (third edition) by Graham Brown and David Watson. You can download the textbook using the link: https://www.hachettelearning.com/camb....
TIMESTAMP
0:00 - Scenario question
1:35 - Duplicate database query
2:32 - Calculate profit using builder
4:00 - Change the run-time field parameter
4:45 - Format the profit field
5:23 - Calculate percent in database query using builder option
6:53 - Format percent field to percentage
7:35 - Calculate unitprofit using formula
8:54 - Format unitprofit to currency and 2 decimal places in database query
We offer one-on-one tutorials for the following subjects:
ICT
Physics
Chemistry
Biology
Mathematics
English Language
All are taken by seasoned teachers with proven experience and track records.
Kindly send an email for more inquiries.
Email: [email protected]
![How to create run time calculation in a Database - Ms Access [Activity 18e]](https://ricktube.ru/thumbnail/IDE0y5GdLuM/hq720.jpg)
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
![How to present summary data in database queries [task 18q]](https://ricktube.ru/thumbnail/Nd1u2aZHbQ4/mqdefault.jpg)
![How to construct database run-time calculation - Ms Access [Task 18p]](https://ricktube.ru/thumbnail/FyW3OLtJsxU/mqdefault.jpg)
