Skip to main content
MPCC
Back to Website
Enter your search query
You are currently using guest access (
Log in
)
Year 8 Databases
Home
Courses
Miscellaneous
MoodleShare Archive
MoodleShare Technology
Y8_DB
Topic 2
Importing an Excel spreadsheet into MS Access (pdf)
Importing an Excel spreadsheet into MS Access (pdf)
Click
ImportExcelToAccess.pdf
link to view the file.
Same as the previous link but this is a pdf file.
◄ Importing an Excel Spreadsheet to MS Access (Smart Notebook file)
Jump to...
Jump to...
Download a Copy of this Course
Lesson plan 1
My Tunes
My Tunes database worksheet
Upload the completed worksheet (assignment)
Lesson plan 2
Importing an Excel Spreadsheet to MS Access (Smart Notebook file)
Lesson Plan 3
Searching/querying and Access database (worksheet)
Upload the completed worksheet (assignment)
The myTunes Access database
How to make queries in Access (Smart Notebook file)
How to make queries in Access (pdf file)
Excel vs Access
Forum assignment
Lesson plan 4
More queries worksheet
Upload the completed worksheet here please (assignment 8MB - 1)
8 MB assignment 2
More on queries (Smart Notebook file)
More on queries (pdf )
Lesson plan 5
Making a Homework Diary database (Smart Notebook file)
Making a Homework Diary database (pdf)
Lesson plan 6
How to make the homework due form (Smart Notebook)
How to make the homework due form (PDF)
Additional thoughts
Upload your completed Access Database here (8MB - 3)
Report Grades (please read)
Lesson Plan 3 ►