Final,,Final post

I forgot to add that I have completed the following:-

• Converted Microsoft Access folder to MYSQL and working on the localhost and double checked everything is in its place.
• Downloaded the Bull zip program
• Downloaded the drive for Bull zip
• Worked in MYSQL tab and checked each and every query
• Worked with the codes

This project was such a burden, and I am thankful we are DONE !
Over and Out,
Alia

Week 17 - 18 ~ Final Post

I am proud to say this is my final post for store you information 2 project.
I have accomplished the following:
• Completed my part of the project .Which is part two out of four parts, and completed my MySQL part. I have uploaded the table online and double checked if everything is in its proper way.
• Double checked the progress of my groups work
• Gathering the group and discussed the finalization of the project, which included how we are going to present the tables, also next week’s oral defense.

Finally, this project was one of the challenging projects that I have completed this year were I spent most of the first couple of days confused of what should be done and how. However, I completed my part with flying colors.

Over and Out ,
Alia

Week 16 - belated

I apologize for not posting late week. It was such a hectic week in which we submitted more than 4 projects. Never the less, I am stuck in my place, I have no clue how to continue in my part in my project, I have asked other groups and members of their progress in their project and they all agree that they are stuck and don’t have an idea how to continue.

Over and out,
Alia

Week 15

This week I have worked on Connecting to the server. However, since the ecommerce websites are still down I wasn’t able to connect. I started working on the tables and the database. I double checked the user name and the password of my administration SQL. It’s been a very busy week with deadline and assignment to be done. However, it seems that I am close to the finish line.

Over and Out ,

Alia

Week 14

As the June is approaching us, which means the assignment is due every soon. This week I meet with my class mates who are responsible for part # 2. We discussed our progress in the project and also I helped them install MySQL drive. Unfortunately the e-commerce was hacked and we could access it to see how we are going to display our database. On Sunday we will meet again to discuss the finalization of the database view

Over and out,
Alia

Week 13

This week I haven’t done much work as I hoped I would, because I was sick all week. But I have made a discussion of creating the database on my e-commerce website. I am currently working with my group in how we are going to design the layout of the database page. This week is going to be a productive week where I will defiantly finalize this project.
Over and out,
Alia

Week 12

This week was a very active week. I meet with Mr. Tridib on Sunday and Thursday. We have discussed where I stand in the project. He also helped me in installing the drive that supports Bill Zip which was a big problem for me.
I have completed the following
· Installed the Bull Zip, which is a program that transfers data from Ms Access to My SQL. This helped me to get a head in the project; however I have a long way to go.
· I have uploaded the database on to MySQL.
· I am still figuring out where I should locate the database. Either my ecommerce server or one of my group members.
· I am currently browsing my e-commerce website Cpanel.
Over and Out ,
Alia

I ♥ tutorials - Week 11

Today I dedicated my whole day to My SQL, where I spend it all reading the tutorials which helped me a lot! However, I can’t seem to mange how to work Xampp! It is so complicated. I am still determined to figure out how to work the program. Tomorrow I will continue my reading of the tutorial hoping for some answers!
Over and Out,
Alia

Week 10

Working on store your information 2 is very complicated. I am still grasping all the information that I have gathered from the book I’m ready. But, after our meeting with Ms. Tridube on Thursday he opened my eyes on many resources that I can use such as online tutorials that gave me step by step guidelines to use XAMPP. This encouraged me in continuing with the project and using both my resources the book and the online tutorials. While surfing the web I have found that many website that provide tutorials for students the main purpose is to enhance students learning.
Over and out,
Alia

Microsoft Access 2003 Fundamentals Reflection

NETG Reflection

As this semester begins we started off by working on the first NETG which is an 8hr long assessment online, which is an introduction to Access. Before I started the tutorial I had doubts that I will be able to understand the feature of access and how things work. I believe I had that thought is mind because it has been a long time since I used access in my studies; I always prefer not to use it. As a beginner it seemed very complicated to use it but when I kept practicing on it I started to get the hang of it. Even though Access seems very difficult at the beginning but I have really benefited from this tutorial.

I started by going throw the tutorial and taking note while having Microsoft Access open to help me go throw it step by step. When I was sure I fully understand the steps I started the first assessment which was Table basic. Table basic talks about methods of managing data in a datasheet view which is mainly about inserting, editing, and saving records in a table. To be entirely honest I spent a lot of time on my first attempt, because I was confused a bit. However, by the third try I managed pretty well.

By the time I got to the second assessment I was well prepared to complete the task. When thinking about table you will never think it would be that complicated. But when I begun Manipulating Tables I learned many skills such as entering data into fields and filtering and sorting throw the field. In addition, I was able to move throw the labels by clicking next, last, and pervious button. Filtering base records was very useful where I learned to find name faster, which saved me a lot of time while I was working on my access project. However the process to filtering wasn’t as simple as it seemed.

Final assessment was about Querying Data. I started off by finding query such as name, summary function, and also fields to display. After that I learned how to crosstab throw query by selecting row headings and column headings. This assessment quizzed me on table, show, criteria elements. I mostly enjoyed the calculator field components which at start I wasn’t able to work with, but I kept on practicing till I was able use the mathematical operators.

As I conclude, I never thought that I will be able to understand the fundamentals of Access properly in this short time period. I always imaged that I will take me months to create a table and work with it. Know when I am starting to work on my access project I realized how important the tutorial was, it helped me in getting ahead and understanding what I am working with. It saved me a lot of time when starting the project. Finally that is a lesson to never under estimate yourself and your abilities.

Word Count: 500

Week 9

I am final getting the hang of MYSQL. It isn’t difficult it just needs time and effort. I am a nearly done with the book I am reading. Hopefully I will start with my part of the project. I have also been using XAMPP while I am reading in order to help me understand the techniques even better.

Over and out,
Alia

Store your information

Week 8
My part: Relational databases and how to split the existing perfume database into two or more relational tables. Expertise with MySQL

Book: Introduction to relational databases and SQL programming.

As begun my search by heading to the Library and likely found one good book which talks about database and MySQL. I checked out the book from the library and in the mean time I am reading through the chapter. Even thought I feel lost in between chapter; however I am managing pretty well up to now.

Over and out,
Alia

Location..

Home Sweet Home

ECOM-217

Well, to being with I was late for today’s class!! For some personal reason and apparently I missed a lot... Chose the wrong day to be late ... oOo well what happened happened.

ECOM-217 is a very interesting class which I seem to enjoy a lot.
However, I don't really like access for some reason..

At the begging of the year I really had doubt about coming to E-Business and meeting new people, but it is turning up to be an interesting and fun experience.

Over and out,
Alia