快速解題~電腦軟體應用乙級術科題組四資料庫處理Office2016

芳華老師的電腦小教室
569 followers
307 Video Views·Jul 13, 2024
快速解題~電腦軟體應用乙級術科題組四資料庫處理Office2016
Computer software application and digital component database operation
First, let's press the right button on the desktop.
Add a new blank to this database.
So what we're doing now is structured
So we named it N04.
Then we opened it.
After opening.
This security warning can be wiped off
Then come and press the button of the window on the screen.
Press the right keys up, down, left and right.
This is the picture of this database.
Put it on the right
The purpose of this topic is stated on the left.
This can facilitate good operation
Again, we're going to take these tables.
Put it in.
So let's get some outside information.
New Sources
Filing the case here.
Then choose the XML file.
Come on, let's go press
Let's take a look at it.
The application of computer software in the West and
We are using Data Set 3.
The first one that went in was the Department.
So let's go here twice.
确定
Good to close.
Then pick it up here.
The second entry is Employee.
Well, then it's going to remit Product.
Then came Quota.
Then again, Sales.
Okay, finally, Customer.
Okay, so we have these information forms here.
After you put it in.
We're going to build the connection again.
So let's go build.
There is a check-up design here.
Let's check the design.
Put these tables together.
Add it in.
Then close
That's what we say here.
Put it in this list and put it in order.
Same as DESCP.
That's because the window is smaller here.
So let's make it a little smaller.
It's the Lord of Sales.
So we put it in the middle
And then this side of Customer
Again, product.
One more Quota here.
So we put it on the right
Then we're from the Lord of Sales.
to establish its connection.
The first is the client's code.
So we pulled it to Customer's account number.
Pull the business name to Employee's name again.
Department of Employee here.
Pull to the Department's Department code
Then come back to Product. The word here is product code.
Pull here.
Then there's a Quota.
Quota is the name of the business.
What is its goal for each business?
So we got this business name from Sales
Pull it over
Well, after the link is established.
Let's look at the position that this attachment wants.
its first attachment
What it wants is the name of the department.
Name of Supervisor
Name of operator
Let's choose here first.
Department Name
Then the name of the supervisor.
Name of the clerk.
We only have business names here.
No operator name.
So it doesn't matter
Let's bring it in first.
Then go to Excel and change its name.
Come to the goal again.
The performance target.
Because what we're doing now is 90 years old.
So let's go and pick a 90-year track record.
Then come back to business.
of achievement.
Look, it's here to say
its formula for achievement
is the unit price of the product multiplied by this amount of it
So let's go here and choose the price.
There are still quantities.
That it these two to multiply it
So I measured it and pressed Ctrl X to cut it.
I'm here to go here to press the new number
Press Ctrl V again
That word here.
The name of this place.
The name of the important position is called achievement performance.
So I'm here on the left to have a little
I'm going to get into business.
Then remember to add another colon of that half type.
Only this can
Then you can check it out.
Well, even if you come out here
It means that your formula is correct.
Well, again, it has a gross profit here.
The Maori.
It has an algorithm that talks about it.
Gross profit is the unit price of each product minus the cost.
Then multiply the number by the number.
It is very similar to this algorithm that we have achieved business results.
So we multiply the price here by the quantity.
Reproduce it.
The words on this side are convenient for us to operate.
We can press right here.
There is a scale here.
Okay, go ahead and open it up.
The name we have here is called Maori.
So here we can directly enter its formula.
We just cut it.
Just copy this formula and paste it.
We'll make some changes after posting it.
The purpose of the topic is that the gross profit is the inclusion of the unit price minus the cost.
When we just elected.
It will automatically add a middle bracket to each position name.
Then let's not remove it here.
We'll just go ahead and make the changes.
Add a bracket to the left here.
Again to the right.
We need to cut costs again.
Then add a right bracket.
Then you don't have to add the middle number to the cost here. It doesn't matter.
Because it will automatically help you add it later.
So all you have to do here is add this gross half bracket.
Re-sign off cost right bracket
That's all right.
Okay, sure.
Then you can go and check it again
All right, there are indications that your formula is OK.
Then let's take a look at it here.
This is the right place for Annex I.
Then we'll look at Annex II.
What is required in Annex 2 is the customer guarantee number.
If the customer guarantees, we are here at Customer.
So let's take two.
Again, the transaction amount.
The transaction amount is our achievement here.
This is the place where the price is multiplied by the quantity.
Every company.
How much does it trade here?
It is calculated here with this industry here.
That's in the company's turnover.
Let's do it here in Excel.
Then come back here with the name of an operator.
The name of the employee is our business name.
Okay, here's the second annex.
Just add a customer guarantee.
Let's look at Annex III.
In Annex 3, it wants departments.
The name of each department.
The name of the department has it.
Well, come again, it needs to be a target.
This is 90 years of the Republic of China.
So we have 90 years of business goals here.
Again, the achievement has already been made.
Then there is also the word Maori.
Therefore, the words in Annex 3 do not need to be added to the table.
Let's look at Annex IV.
The words in Annex IV should also have the name of the department.
There is also the name of the supervisor.
If we have a performance success rate, we will do it in Excel later.
Gross profit also
That's an annual salary.
Let's take a look at the annual salary algorithm.
It is said here that the annual salary is multiplied by 12
So we went over to Employee to bring it out.
Employee has a current monthly salary here.
Okay, so we can double it
What we have in front.
Because its title is called annual salary.
So here we are in front of it.
We pay this annual salary.
Then add a half-colon.
It is the current monthly salary to be multiplied by 12
This one.
Okay, so this is the information required in Annex 4.
Let's go to the Excel place and do it again.
This is OK.
In Annex V, the information it wants has the name of the department.
And then it achieved business here.
So we don't need to add this part to the rest.
That's the subject.
Each of its attachments is a 90-year document for the Republic of China.
So we're going to add another trading year here.
Let's take a look at the trading year here.
It's not just 90 years of trading years here.
It also has this 88, 89, 90
So we only need 90 years of information
Then let's check here again.
We need the next step.
Our rules are 90.
In this case, you go to see it and check it out.
You can see that all the trading years here are 90.
Then we can get this information.
The part that's shown here, this tick, light it off.
No need to see it.
Then we go to check again.
Let's go here in the upper left corner.
Then press Ctrl-C to copy
Then we go back to the table.
Let's press the right key to press add
There is a Microsoft Excel worksheet
After that, because what we are doing now is a composition.
So we called it NO4.
Well, after that.
Let's go here and press the right key to choose the sex pasted value.
Then check this in the first column. It's a lot.
So let's get rid of it.
Then click on the upper left corner to select all the data.
Two points between blue and blue.
Let it automatically adjust the blue
Okay, so let's call this worksheet Data
Then remember to do a deposit again.
The above is an explanation of the operation of the composition database.
