Information Processes and Technology
Home > Information Processes and Technology > Information Systems and Databases > Enrolment database - practical task
Creating an Enrolment Database
- Double Click on Microsoft Access and Click on Blank Database on the Right
hand side of the screen. Save the database as Yr 6 into 7.mdb.
- Click here to
save the file Year7_2006.xls to your my Documents folder.
- To import the File Year7(2006).xls go to the file menu and click File
-> Get
External Data -> Import
- To locate the file Year7(2006).xls. You will need to change the Files
of type to Microsoft Excel.
- Click on file name and click Import.
- A wizard will pop up click on next.
- Check Fist Row Contains Column Headings then click Next.
- Make sure the In a New Table radio button is selected then click
Next.
- Click Next.
- Make sure the Let Access add a primary key is elected then click Next.
- Name the Table Yr 6 into 7 and Click Finish.
- Double Click on the table.
- Click on Form and then Create form by using wizard.
- Select Table from drop box.
- Select all fields by clicking on this
button
- Select Tabular layout then Click Next.
- Choose a layout style and then Click Next.
- Choose Modify the Form’s design then Click Finish.
- Using the Arrow tool from the toolbox, adjust the field headings so that
they fit the page better. Close the Form design window, making sure you
save any changes that you make.
- Double Click on the Yr 6 into 7 icon to view your completed form.
|