Theory question 105
Database ManagementPaper 2, Section B: Test of Practical Work
Highlight the steps to perform the following: (a) creating a new table; (b) generating a query; (c) creating a split form; (d) printing a report.
Show the model answer
Model answer
(a) Open the database in MS Access; click Create → Table Design; type the field names and choose data types; set the primary key; save and name the table.
(b) Click Create → Query Design (or Query Wizard); add the table(s); add the fields needed; type any criteria; click Run; save the query.
(c) Select the table or query in the navigation pane; click Create → More Forms → Split Form; adjust the layout; save the form.
(d) Open the report; click File → Print (Ctrl + P); choose the printer, pages and copies; click OK.
Explanation
Each object is started from the Create tab.