Hello we are going to create a crowd based database driven application crowd stands for create read
or date and delete what that means is that the application will create will be able to create new objects
or new records for that application.
We'd be able to read the data that's inside there.
We'd be also able to update and also delete records from that application.
So I'm going to use my workspace area.
So this is my application express workspace sue to begin I am going to use the sequel workshop or secure
workshop.
Click on drop I am going to select this object browser here.
What this is it for.
Allow me to view the objects inside the schema.
No it is he has got a table listed so it would give me a list of all the tables.
Here is where you create this lot from there to create a table saw.
I have got a list of tables here and this table if you if you are creating a new table this is the option
you're going to use to create a new table.
If you index and SORN sassy option to create I've already got one so I am not going to create another
I'm just going to select mine so this is what I'm going to use.
So I've clicked on it once to show me what's inside a table for one to look at a date and a table.
I click on Data and that will show me all the data in the table.
So let's go back to the actual table structure so this is a table structure.
This is what it looks like he's got a primary key which is the employee idae.
So now that I've seen the table structure.
I am happy with it.
Table structure.
I need to go here way says application builder.
I'll click on that and click on database applications.
Right.
So we've got database applications.
Highlight it are click on Create and you've got three options.
Make sure you've got one database redo bodying checked go next.
Make sure you cook from scratch.
Select it go next.
And this is where you give the name application a name.
So I'm going to call it.
Okay I'll call it employee.
Employees.
Details.
So you can call your application whatever you like it doesn't really matter.
I've just called my employee details.
Every application normally within the workspace will have a name.
And they also will have an application I.D..
Okay so you've got the Air France crash selected and you've got the scheme and this is important what
the right came up my scheme has a chart I'm happy with that I go next.
Okay so I've got this option here.
This this to add a page.
It gives you the various types.
So what we're going to do.
I'm going to say let it report and inform.
So these are deeply type of forms you can add to your page for the application.
So I'm going to check that one report and fall in here is is seeing at a report with an edited form
on a second page.
So what do you do to add a report.
And also you'll create two pages one page will be for it form where you can make some edits so you need
to select the table is coming from so quick on that and select the employees table.
All right.
So it's come in from the Employee table implementation.
You've got options here.
I will leave my interactive.
I want it to be interactive.
Okay.
So all right so what's go that don't click on Had page.
All right sir notice here is great.
Two pages here.
One is a report and one is the form the report page and the form P the form P physically is used to
update entries.
Okay.
In the employee table.
Why the report pay issues to display the data from the employee's table.
So we've also got another here to add additional page to your application.
Okay so we can old school ways.
Got an additional page to your application.
You can however change the name of the print side the more men book pages for the application is called
employees and employees.
Or you can change them if you wish.
So by just clicking on it so you can click on it and just change you can change the name if you wish.
For simplicity I am going to leave my online that are live.
That and if you click on the second one here give you the same.
It shows you the same details so you can change if you want so you can distinguish the pages.
I will leave mine as it is of course is just a demo.
So once you are happy with all the information you click on the create button okay there's some more
information here if you want or read through that.
Feel free to do so.
Click create and when you click on Create it gives you this screen here.
You saw what you do.
Just check out for the final time before you hit the button.
It tells you who requested to create an application with a polin attributes.
This is application.
I see this as a name.
This is a scheme.
English is a default tabs or level of tab and default authentication screen.
Anytime you create an application in a quick breath it all sort of magically adds a logging form to
it.
All right so this is the default scheme theme.
If you want to change the theme you can click on previous.
And if you scroll down these are different teams so you can select any teams you like.
I just looked through see there's one that catches my eye team level.
Team 17.
I'm trying to look for one that catches my eye.
Let's have a look again.
But I once had big dark to watch.
I saw something like bluish colour.
Asked the green one.
I tell you what I'll go for the green just for simplicity.
So I'll select that team
and go next.
So this is a team now displaced.
It gives you the option to save if you want So once you don't just click on create issues create the
application.
So basically that's done it tells you here.
Application creators successfully.
So we have now successfully created a database driven application so these this is what the application
consists of it consists of two pages.
This is the first page Sushi's employees and this is the actual form.
This this this year will display the report and this is the actual form where you can edit.
This is the logging alright.
Logging is added by default to any application you create mound.
If we're to the application we can run the application by using this icon here.
So you click run.
Or you right click angle or pull a link in new window sill are quick on that and he now gives me the
option to pull my password did me.
Password is asking for is the char one.
So type in hey char.
There are so many log in as a password.
Okay it does sound like that to a king.
So as typing had min.
K.
Sorry my error.
The user name should have been blue line which is what I registered for the workspace so the user name
it will be the name for the workspace okays which was blue line.
Got so many passwords and user names.
So now this is our troll application.
So we are successfully.
This is the application running at the moment so we have created a database driven application.
So I'm just going to log out of this one now and that will end this lecture for now because it's gone
on a bit long.
So that's it for this lecture.
Thank you so much for watching.
Take care.
Bye for now.