Today, we were to add tables to our websites from the example 'Northwind Traders' example database from Microsoft Access. To start with, we had to add the database file into the website folder so it can be used from the database explorer toolbar. I clicked 'Add Connection' on the Database explorer toolbar, then chose the 'Northwind Traders' example database from the file explorer and clicked 'open'.
Due to problems with blogger.com, I can't add any more pictures to this post, but during the class, this is what we done:
We had now opened the database into VWD, so we could use the 'Database explorer' bar on the right hand side of the screen, where we could see all the tables of the database, and drag and drop one onto one of the pages on the website.
For my example, I chose to use the 'Products' table and place it on the 'Products' page.
I then used the 'Autoformat' tool to change the look of the table and to change what appears on the table and to add functionality, such as the ability to edit records, sort records and highlight records.
We also learned of the problem of deleting records. If we add this functionality and try to use it when previewing the website using an internet browser, we get an error message because the system does not allow us to delete records since it is a relational database, meaning records are related to other tables, and deleting them would affect them too - the referential integrity would be affected.
Finally, I used the 'hyperlink' tool to provide a link into each of the tables that I had created.
We had now opened the database into VWD, so we could use the 'Database explorer' bar on the right hand side of the screen, where we could see all the tables of the database, and drag and drop one onto one of the pages on the website.
For my example, I chose to use the 'Products' table and place it on the 'Products' page.
I then used the 'Autoformat' tool to change the look of the table and to change what appears on the table and to add functionality, such as the ability to edit records, sort records and highlight records.
We also learned of the problem of deleting records. If we add this functionality and try to use it when previewing the website using an internet browser, we get an error message because the system does not allow us to delete records since it is a relational database, meaning records are related to other tables, and deleting them would affect them too - the referential integrity would be affected.
Finally, I used the 'hyperlink' tool to provide a link into each of the tables that I had created.
0 comments:
Post a Comment