Finishing off

All done, completed, finsihed, finalised..lol, thanks Rachel, nooo more Visual studio

Publishing??

Now I've completed the media, the instructions and applied them to the help menu, I can't understand how to publish it from the blog

Stage one of Party Toonz

I am currently working on the GUI. The database has been completed. The splash page was easy to complete using the example in our text book.
My problems working on the GUI is putting the correct buttons and panels in. I am yet to figure out the media player.
I worked on a design through photoshp for my template.

Array and File Handling Assignments

Using the step by step instructions for these assignments, these were pretty straight forward. Completed and handed in today.. yay! only Party toonz to go!

Databases Cont'

You can use relational operators which are
>
<
<=
>=
<>
=

anything with talking marks is case sensitive.
using % at the beginning of R will show what ends in R
% signs are called a wild card character
you can also put % at beginning and end and it will look at the beginning and end.
'This R% brings up locations starting with R
'%R anything that ends with R
'%R% starting and ending with R
'Use [] where a space has been inserted in name

logical operators
AND
OR
we can also use these in the expressions that we are making

And will only find from one section
Or will find from all sections

Concepts

Connection String - The supermarket
Connection Object - The car
Data Adapter - Mum doing the shopping
Command Object - The shopping list
DataSet Object - Pantry

* in sequel means ALL

SQL means Structured Query Language
Select
Delete
Update
Insert

WHERE filters where(it's a clause)

Database cont'

There are 4 different operations
delete
update
insert
select

2 different types of databases
flat file (excel spreadsheets)
relational (access)

manipulating a database
ID is King, it's all about ID

auto number
go to the data type in access
Access does not renumber id, there all all unique, even if they have been deleted
All of our tables will have an ID column that belongs to the table

Primary key
Suitablility - access is for single users or small business users.
limitation - not suitable for the internet.

SQL - structured query language, when we want to do our insert, update, delete etc

No spaces eva between anything in programming - capital or underscore

Generate reports and quiries with access