Microsoft Access?

[Viper]

Does anyone know how to use this?

think im going to have to use it for one of my uni assignments but havnt got a clue how to use it.

[laura_g]

Its quiet easy to be honest it has like more options on what you can do like has a planner and so fourth but also has the database that you will prob be using, dont worry it has tutorials to follow anyway

[TU-Tuning]

Its easy until you have to start forming relational databases with lots of foreign keys, you have to create extra tables and make SQL Queries which takes ages and sucks ass

[Mystic]

Blaurgh, done a course on it in 1st year at Uni. It was OK once i got into it. As long as you dont go too far down Normalisation street.

Having to setup a fairly complex database system at work atm though and though "Hey Access has those wizards for setting up forms and databases, it shouldnt take long at all"

4 weeks later and im now staring at a half finished database using PHP & MySQL, Access is a joke IMO ;)

[Clouds_mate]

SQL is the devil. *sivvers*

[Viper]

what are you sivving?

[Clouds_mate]

sh*....

[Robb]

I did this for A Level Computing.

However I dont know how to use it, hence why I didnt go to the exam.

[shooorn94]

What will the Uni assessment involve? I have done a tiny bit in the past-creating a database, using mailmerge in word to create a letter to send to all the members in the database. Used access and excel to keep on top of stock-that sort of thing.

Or will it be a little more complex then that?

[srcnix]

Its easy until you have to start forming relational databases with lots of foreign keys, you have to create extra tables and make SQL Queries which takes ages and sucks ass

Not really, depends if you know what you're doing with SQL.

[srcnix]

SQL is the devil. *sivvers*

For a first database to learn it isn't too bad and is widely used in the web development area for its ease of use and flexibility.

[BenSilverSaxo]

Having to setup a fairly complex database system at work atm though and though "Hey Access has those wizards for setting up forms and databases, it shouldnt take long at all"

4 weeks later and im now staring at a half finished database using PHP & MySQL, Access is a joke IMO ;)

Welcome to my world, getting ready to stab myself tbh - for someone who was a complete noob i can now write code in visual basic for simple commands etc. Most annoying thing is when you thinks its all over and ready to start being used and you are showing it to the boss or a colleague and they are like "hey, why has that got my name in twice" turns out everytime they click out of a combo box it saves the record again. :boxing:

[b0t13]

i hate SQL, access felt like a dream when doing mySQL in uni, relational databases are boring as fuck and our topic at uni goes into some mad detail about them that will actually send u asleep!

[saunders]

Creating databases in sql is easy, using PLSQL is slightly more challenging but nothing too difficult. It's getting a multiple applications to interact which is the fun bit. I have just complete my third year project a relation database in Oracle. Containing 14 tables, 3 triggers, a package, vb.net frontend and Outlook references that allow direct emailing of attachements from the database ;)
It was not easy but I programmed it in two months :fcuk: which was a great achievement, although the write up is like 400+ pages with out source code:geek:

[srcnix]

Creating databases in sql is easy, using PLSQL is slightly more challenging but nothing too difficult. It's getting a multiple applications to interact which is the fun bit. I have just complete my third year project a relation database in Oracle. Containing 14 tables, 3 triggers, a package, vb.net frontend and Outlook references that allow direct emailing of attachements from the database ;)
It was not easy but I programmed it in two months :fcuk: which was a great achievement, although the write up is like 400+ pages with out source code:geek:

God I love playing with databases. SQL is fun :D. What's Oracle like as a relational database?

[saunders]

God I love playing with databases. SQL is fun :D. What's Oracle like as a relational database?

Very good, using table triggers is where the fun comes in. I have used it for about 3 years now but this is the biggest project I have had to do.

[srcnix]

Very good, using table triggers is where the fun comes in. I have used it for about 3 years now but this is the biggest project I have had to do.

Nice, what did your project en tale ?

[TU-Tuning]

SQL is fun :D.

Now I know your on crack :panic:

[srcnix]

Now I know your on crack :panic:

lol, why?

[saunders]

Nice, what did your project en tale ?

Its a proposal for a large recruitment agency, as an example of how sequel can be used to match candidates to jobs, allowing consultants to email matched candidate resumes directly from the database. It also produces email templates for job and interview offers, personalised for the indivdual candidate at the click of a button:A:Plus all the reports etc...
Not bad considering I have never used vb.net as a frontend application until two months ago

[Andy_S]

Access is just a glorified excel database thingy ma jig isnt it?

I could do with learning to use this myself really, cant be arsed though.