Dreamweaver

a

Developing Ideas

I currently have narrowed down my three ideas into two:

• The website showcasing the rolling stones or another significant band.
• The website that hosts Dreamweaver tutorials, and gives tips for other people using Dreamweaver.

I think I will look at the website showcasing a band that is no longer prevalent in our society. This will be better as it allows me more time to look at the complex sections of dreamweaver and allow me to experiment more with the html and css coding and was the highest voted for during the survey

Looking at the following two designs:

The second sketch shows a well designed website, it has the ability to contain a lot of complex menu bars, hyperlinks etc. The layout has the ability to have a navigation bar that can be used to navigate the website, this can be a complex rollover menu, with hyperlinks to specified pages. The next page can contain a list of videos of their concerts.

1. The main resources required for such a task would be access to adobe dreamweaver, and access to tutorials showing detailed explanations on how to perform certain complex tasks for the dreamweaver.
2. Navigating the code and design interfaces would require a lot of time so it is requires to start earlier.

Inquiry and Analysing

Our new project will look at using Dreamweaver to create a functional and user friendly website, to show how the world wide web can be used as a tool for advertising.
The World Wide Web is a global network that connects all the computers with servers that give access to information and communication. It is a powerful tool that also allows companies to showcase and advertise their business. Many companies use this to sell their products to a wider range of people as it can reach a international market. There are many types of advertisements that are present on the internet, such as:

Search Engine Marketing - A method at which a certain website's results come more frequently with related searches.
Display Market - A type of Advertising that involves text, audio or flash animation, that can be used in pop up or banner ads.
I have three ideas, as to what my website could be displaying:

A Dreamweaver tutorial website, that shows video tutorials on how to make Dreamweaver based website, and to code in html 5 or CSS. This website will provide assistance in Dreamweaver and give instructions on how to create a beautiful website.
Advantages

• This will benefit the community as it will help people use technology.

Disadvantages

• It will be tedious and time consuming, the project will require a lot of work and may not be up to standards. 

A site that show cases the problem of endangered species. This will spread awareness of near extinct and/or endangered species.
Advantages

• This website will help stop the killing or extinction of certain animals.

Disadvantages

• This will be time consuming and I may not be able to finish within the time frame. 

A website that showcases on of my favorite bands, the rolling stones, using complex html and CSS coding. This will show my passion for music and this band. This website will look at the rolling stones' achievements and their impacts to society. 
Advantages

• This will be a less time consuming task, and allow me to showcase the more complex parts of Dreamweaver

Disadvantage

• This will not affect the social or environmental facotors of my community or city.

I consucted a survey to see which of the three ideas were preffered by other people

I surveyed 20 people and asked them why they chose the option they did.

The overwhelming choice was the band idea with the major response being that the people I had asked had very little knowledge on the band, The Rolling Stones, and wanted to learn more about them.

Evaluating the Solution

Evaluation:

The Database was successfully created with 4 queries and 2; forms, queries and tables and one relationship. The overall appearance of the database looked good, with the aesthetics of the reports and the overall ease of use of the forms. All the systems appeared to be in working condition, being the queries and each of the forms are able to input data into the tables, with minimal extra work. The data can pass through the forms successfully and it enters the tables correctly in the correct fields. I needed to change my form design as it was quite hard to use, the adding of buttons allowed the forms to be more user friendly and made it easier to input data with an efficient use of time for the client. 

Stage 1: Creation of the tables and relationship of supplier code

The creation of the tables were fairly easily as it was a case of following the plan that I had created, regarding each of the fields for both tables. Both tables included the field "supplier code", this was used in the relationship to relate each object to a certain supplier to allow multiple objects to have the same supplier, this brought up supplier information in the queries even though the data is in two different tables. 

Stage 2: Creation of Reports and Forms

The creation of the reports were fairly easy, with little or no problems as the report wizard is pretty straight forward to use. I created the report in a simple table design with a few select fields that are important including product ID, Supplier Name, price etc. The Forms were slightly more complicated as they required the use of buttons and each had to be used for a different button, this was very time consuming.

The topic relates to the global context, globalisation and a sustainability as it shows how everything is connected. Owning or running a shop in this age requires efficient use of technology and this topic highlighted the use of technology in everything we do. This also shows the close link between communities and human-made ICT systems.

This project answered the question of what a database is. It showed that Databases are useful organisers of data that allows easy input, output and organisation of data, it is an alternative to having physical records in folders, instead having all the information of products in sorted tables and queries. The advantages of a database's digital records over a regular physical records is that a database can be uploaded and accessed anywhere if need be as opposed to having to physically be there with the records. The Database allows you to easily "access" and search for records as opposed to manual searching of records through files and cupboards.

Peer Assessment:

I was peer assessed by Nathen and as you can see the results are mediocre. The Inquiring and Analysing criteria is lacking quite a bit as it is missing, the important sections, including the research sections, can be filled out and have more information. The analysis could have included three different organizations with advantages and disadvantages. The analysis and the research could have utilised sources and Documented them in a bibliography. Some Questionnaires or surveys could have been used to understand customer tastes and preferences. In Criteria B the designs or plans o f the database, although I included two of the tables, I could have included the forms or the reports and maybe some of the queries. The rest was adequate enough for Nathen to agree with. 

Create

Here is the Product Table with all the records

This is the supplier table with all of the supplier codes which are related to the supplier codes in the product table.

Here is the relationship (one to Many) of supplier code in both tables

Here is the report of the product Table

Here is the Supplier Table

This form is the form that will be used to input data into the supplier table

The form is the form that is used to input data into the product table

These are the buttons that are used to navigate the interface

This is the results of a query that is using the criteria detailing products that are less than or equal to 500 Dollars. The Query uses the relationship to bring up the supplier name even though that data is in a separate table.

Developing Ideas

Solutions:

The easiest solution would be to create a database on Microsoft Access as this will allow them to interact with the data tables easier. It is extremely efficient as it is easy to input data using the data forms that are quite user friendly. The queries make it easier to select and view sets of information grouped by common criteria. This allows for selecting and moderation of information easily and without searching for information. The results of queries can be printed out as a professional report, allowing for easy access of the data as a hard copy.

The other method, involves using Microsoft Excel to create tables and this is less user friendly and does not include the ability to create data entry worksheets and query reports.

The solution that would be the easiest would be to use the Microsoft Access as it has a user friendly interface for the client to use and allows them to create reports of query that they can run.

Gantt Chart:

Step 1: The Learning of Access will begin by experimentation, to understand the many different aspects of it. This will allow self-exploration to figure out how to enter the tables and data into the program.

Step 2: The creation of the tables will take a long time as we have many fields that need to be entered, there will be two tables one for the distributors or sellers and one for the suppliers. One table will keep track of all the sales made by the company using the cashier as the person to input data every time that there is a sale. The other table will keep track of all the supplies that are brought in weekly or monthly, the table will contain data about the suppliers and the stock. 

Step 3: Data input can be implemented by the data entry form which will allow ease of input of data and this will allow me to input the data easier.

Here are my plans for the tables

Database Inquiring and Analyzing

Scenarios:

The Music shop at Mall of the Emirates is struggling to keep track of purchases and customers are taking advantage of that fact and claiming refunds to take more money. I have been approached by the music shop to create a easy and efficient way to organise their records. I have decided that Microsoft Access is the best way to make organised records that can be easily inputed.

Planning:

My Customer is the shop Brooklyn Melodies and he wants an efficient way to maintain sales and organise all of the amounts bought and sold. I have come to the conclusion that the best way to solve this is to use Microsoft Access to maintain the records. The database will be used to track purchases of certain products and to make sure that customers get their product. The cashier will use the database to update it constantly but the administrator will use it to make sure that all products are organised and keep track of all movements. There will be many limits to this project, the skills required to create and use the databases effectively. This will require research into the more complex tools that Microsoft Access has to offer.

Research:

1.) A database is a series of records who's categories are separated into fields. Each record contains information about the product mentioned in it separated into different pieces of information including, date of production, price etc, these are called fields. The databases make it easier for people to organise and locate records and information about certain products.

2.) Using Microsoft Access we can create a Database, the program allows for easy inputting of Data into a data entry form which acts as the interface between the human inputting data and the program's tables. Microsoft Access is a easily navigable interface that allows for ease of use, and makes it easier for people who are not as technologically inclined to create databases. This will make it easier for the store to use and utilise the full potential of it.

3.) It helps my customers keep records as it allows for ease of data input and is an efficient way to store information as it is retrievable.

4.) It also allows the customer to search or query for any set of records by using specific criteria.

5.)  The manual way of keeping records involves using files in a filing cabinet that have to be labelled in order to be easily found.

After the initial complex setup, the level of computing skills is minimal as the data entry forms are quite straightforward.