Exam

Question 1

Part b

Answer 1

1) Form wizard
2) choose table where it says add a ‘specific table in question’
3) change name to frm_
4) modify the design
5) create combo box
6) choose the specific table where it says ‘the user should be able to select a’
7) choose either double arrows or single
8) store the value in a field
8) rename it cbo then the specific field
9) make a command button
10) record operations, save record
11) make it a text rather than a picture
12) rename cmdsave
13) on save record, go to event in property sheet and click on the 3 dots
14) using the criteria in the question you have to create your own data
15) for example use terms like ElseIf, Else, IsNull. End with End sub
16) click black dot top left and turn on data entry
17) rename the form header and make the detail more neat
18) Make a new form
19) new title add test result
20) Do a new text box
21) go to data area; control source will be dmax

Question 2

Part A queries

Answer 2

1) Add a query design
2) add the tables
3) click on the fields which it says in the activity
4) add a criteria where the 2 ‘things’ are at for example. ‘GCSE Maths’ or BTEC Information Technology’
5) Name the query
Second query
1) Display the different fields
2) make sure to add more info when you do the table
3) make sure to change the total if u need to
4) add a detailed field
Report
1) Display all the fields
2) After doing that go on report wizard
3) Choose the specific query
4) rename the page header with spaces
5) add a specific footer
6) add a report footer
7) Export it

Question 3

Part A q1,2

Answer 3

1) look at Figure 1
2) Create 4 tables with a couple having foreign keys
3) make sure to fit the foreign keys into tables that make sense
4) Name the table and make field names followed by data types. Make sure to change field sizes
5) add primary keys to the table
6) fill in the data
7) Click on relationships and add all the tables
8) Add the relationships
9) done