Preserved Topic: Access tutorial! (Page 1 of 1)

Hi, guys! It is me!

Well, would you know good tutorial for Access database? I want to be a web designer so that it is important to know it. Aslo I want to find a forum like this site.

Let me know! Thanks.

Hiroki Kozai

From everything I'm hearing....mySQL and PHP are the way to go for web based databases....FWIW

what are those? I have not heard of them!

Wanting a wee more explanation.

Thanks.

Hiroki Kozai

Hiroki you're kinda jumping into the deep end real quick you may want to learn to float first.

What are you trying to do?



.:[ Never resist a perfect moment ]:.

Yeah, I'd never ever ever ever ever use Access as a serious backend for web based stuff. Stick with PHP and SQL.

But, if you really want to use Access for anything, try reading through the Access help files.

Have you taken the time to see what OS the Server hosting your DB will be running? If it's a Unix or Linux server you won't be able to run your Access db on those platforms...only on one of Microsofts platforms will Access work.

Oh,dear. Well, I am a wee bit confused. cause my totur said I'd better study Access database.

If Access database does work only in Windows operating server, which database software database people use to creat a database for website?

I thoght studying Access would be good to know so that I could understand how to create database.

I understand SQL, PHP or ASP are important to talk to database.

Any advice is certainly appreciated.

Hiroki Kozai

Access will help you understand the ideas behind database design.

However, MySQL will do the same.

In business, Access is sometimes used for smaller projects. For large projects, it's usually Oracle.

For the web, use MySQL. You can interact with MySQL using PHP, ASP, or any other server-side scripting language.

It's a good idea to master HTML or XHTML before learning this sort of thing. However, if you're determined, you can learn both at once.

Yeah...I had Access in my web-design school, as well...and the only thing it really is good for, is what has already been said...learning about DBs...which isn't bad, as things go...learning how to work with a db is a good learning tool...but as said above, Access in web-design? I've never encountered it...

*shrugs*

You've gotten some good advice, from people who are experienced designers...open those ears...hmmm?

Oh, I understand. Thank you for your advice. So mySQL is the most useful to create database for website, right? Studying Access gives me an idea of database.

All right. Again, thanks very much.
I am really happy now.
See ya.

Hiroki Kozai

Well, I've encountered quite a lot of small commercial sites that are built on ASP/Access, be it good or bad (please note that I said "small"...).

The reason as far as I understand is that if you already have an account with a M$-based hosting service (small non-IT business often get an account on windows even before they consider the size of their site because they don't know anything better) their options are limited to upgrading their hosting to MSSQL (costs a lot...) or to use an Access "db" for their product catalog.

The important thing to remember is that Access don't scale up, not at all!
If you know that you will have a small but constant user-base and low traffic, Access can work ok, if you predict a large traffic volume, use something else from the start and eat the extra cost. It' will probably cost you more to migrate later on.

As I see it here it's about doing the best of a clients current situation and requirements.

That your teacher recommended learning Access with the web is probably based on three reasons.
1. The school can provide it with a relatively low cost compared to setting up a MSSQL-db with all the admin that's needed.
2. On an intro level to dynamic websites Access will serve you pretty well to learn the principles of designing databases and getting used to communicating with it through SQL.
3. It's M$ technology, like it or not, but it has been and probably will be a demand for ppl knowing M$ web-technology in different forms in the job-market. Plus there are a lot more certificates and similar stuff that you can get in the M$-area than there are in PHP/MySQL.

As I see it there are three roads to go for serious web-coding (no specific order here).
1. The M$-track with ASP, .NET and MSSQL Server.
2. JSP, Java and Oracle databases.
3. Open source, such as PHP, Perl, Python and so on together with either commercial databases such as Oracle, MSSQL or open source databses such as MySQL, PostgreeSQL and so on.

Personally I think #2 will become the biggest one for large scale applications followed by #1 with my favourite #3 taking care of the smaller to medium sized applications.

And that's my pow
/Dan

{cell 260}
-{ a vibration is a movement that doesn't know which way to go }-

Thank you very much. I understand.
See you later.

Hiroki Kozai

i don't have anything yet! friends here....etc...

Ars Longa Vita Brevis!

I warned you, Yannah, to stay out of threads (i.e. not to post) unless you have something to add that is relevant...

Didn't that get through your thick head?

Now...you are really starting to bother me...stop it. And you are being disruptive...