BTEC IT unit 2 controlled assessment May 2019 Watch

suga_cube
Badges: 6
Rep:
?
#21
Report 4 days ago
#21
awe. did u start today??
(Original post by ben_lodge1)
I dont even know what to put in the tables...
0
reply
suga_cube
Badges: 6
Rep:
?
#22
Report 4 days ago
#22
I need help on the 2nd form and the report. Can someone help me out??
0
reply
ben_lodge1
Badges: 3
Rep:
?
#23
Report 4 days ago
#23
(Original post by suga_cube)
awe. did u start today??
Yeah I started today. I’m 3 hours in and have imported the data. What do I put in each table?
0
reply
Ahmedazad
Badges: 2
Rep:
?
#24
Report 4 days ago
#24
Has any1 done the ER diagram ? I have no idea what to do
0
reply
suga_cube
Badges: 6
Rep:
?
#25
Report 4 days ago
#25
(Original post by Graceaww)
How to do the second form and the last query ?
have u done the second form
Last edited by suga_cube; 4 days ago
0
reply
suga_cube
Badges: 6
Rep:
?
#26
Report 4 days ago
#26
(Original post by ben_lodge1)
Yeah I started today. I’m 3 hours in and have imported the data. What do I put in each table?
I could...but i need the second form or report. U know anyone who has it
0
reply
Max747309
Badges: 1
Rep:
?
#27
Report 3 days ago
#27
Please does anybody know how to do the last form, the last query and the report?!...
0
reply
Charlie_kemp99
Badges: 2
Rep:
?
#28
Report Thread starter 3 days ago
#28
I don’t have the exam
0
reply
LunaBonita
Badges: 0
Rep:
?
#29
Report 3 days ago
#29
In design view you need to include event description, NumAdults, NumChild. click totals and make NumChild and NumAdults sum. Event description should be group by. then you make your own field next to NumChild and name it TotalTicketsSold: [NumAdults] + [NumChild]. That should be sum aswell. then you make another field next to TotalTicketsSold and call it TotalTicketsRemaining: 96 - [NumAdults] + [NumChild]. Leave the totals column for TotalTicketsRemaining blank. Then run it.
(Original post by LewisC0505)
How do you do the query when you have to add up adult and child tickets, then subtract that by the maximum amount of tickets. Literally been stuck on that for ages.
0
reply
nehakumar99
Badges: 2
Rep:
?
#30
Report 2 days ago
#30
thank you
(Original post by LunaBonita)
I
0
reply
M.B19
Badges: 1
Rep:
?
#31
Report 2 days ago
#31
neha ?:lol:
(Original post by nehakumar99)
thank you
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

How has 2019 been so far?

Amazing!!! (56)
5.77%
Fairly positive (301)
31.03%
Just another year... (384)
39.59%
Is it 2020 yet? (229)
23.61%

Watched Threads

View All