This week...

At the beginning of the week, I summarised Chapter 58 of the textbook, then did part of the mindmap for LANs and WANs. I didn't get anything done after that because I was off Tuesday-Thursday. Today I'm trying to catch up.

On the project front... *tumbleweed rolls by* I'm still trying to get the Analysis done.

Importing a CSV file into Access

First of all, create the CSV files from the table in Excel simply by saving all three worksheets as three Comma Sepearted Variable files.


Next, after creating a blank database in Access, click File > Get External Data > Import... Then select one of the CSV files that was saved earlier. The box below should appear.


Make sure to select a Delimited format, as this this the format that CSV uses. Also ensure at this stage that you have selected the correct data to import.


Now select 'Comma' as the delimiter and make sure that the 'First Raw Contains Field Names' checkbox is checked.


In the next step, specify that the data should be placed in a new table.


This step lets you specify the type of data for each field.


This is the final step. It lets you choose a primary key to identify each record in the table. The table will be created after this step.

My First "Computing is Fun" Blog Post

This is post number one on this blog, Computing is Fun (because it is, obviously). First of all I should probably give you a heads up on my plans for the Module 6 Individual Project...

The (fictional) company I am creating the system for is called Shinka! Couriers. It's a courier comany that transports packages that the postal service cannot handle, also in a quicker time. It's current system is all paper-based and the secretary wants a computerised system, as it would save time, eradicate data redundancy and enable a web-based tracking service for both customers and couriers on the move.

It'll be created in a database program and then it'll use ASP to enable the web-based system.