Course: Year 8 Databases

Enrol me in this course

	We will look at a large database in Excel and then import it into Access to see the different types of searching and sorting that can be done there. This unit will not cover relational aspects of the Access database but will look at queries and form design.

1	A large database In this unit we look at a database in Excel that has several thousand records and see how to search and sort the data. Lesson plan 1 Word document My Tunes Excel spreadsheet My Tunes database worksheet Word document Upload the completed worksheet (assignment)

2	Is your homework diary a database? This homework question will be debated and discussed. We should also find time to import our My Tunes Excel sheet into MS Access. Lesson plan 2 Word document Importing an Excel Spreadsheet to MS Access (Smart Notebook file) Importing an Excel spreadsheet into MS Access (pdf) PDF document

3	Information from Data Using access queries; comparing Excel and Access for the job of finding data - which one gets the job? Lesson Plan 3 Word document Searching/querying and Access database (worksheet) Word document Upload the completed worksheet (assignment) The myTunes Access database file How to make queries in Access (Smart Notebook file) How to make queries in Access (pdf file) PDF document OK, now we want to hear from you. Please list: one advantage of using Excel to search for information one advantage of using Access to search for information Post your message into the Excel vs Access discussion forum below: Excel vs Access Forum Forum assignment More on Access queries Just to see some of the wonderful things that can be done Lesson plan 4 Word document More queries worksheet Word document Upload the completed worksheet here please (assignment 8MB - 1) 8 MB assignment 2 More on queries (Smart Notebook file) More on queries (pdf ) PDF document

4	The homework diary project In which we investigate the possibility of using MS Access to keep track of your homework (and the time it takes you to complete it). Lesson plan 5 Word document Making a Homework Diary database (Smart Notebook file) Making a Homework Diary database (pdf) PDF document

5	Extending the system We can use forms for navigation - they don't have to have data in them. We can also make forms based upon specific queries - such as homeworks due. Lesson plan 6 Word document How to make the homework due form (Smart Notebook) file How to make the homework due form (PDF) PDF document Additional thoughts Forum Upload your completed Access Database here (8MB - 3) Assignment Report Grades (please read) Assignment