12-13 MS ACCESS, Creating table,forms and report

   HOW TO USE MS ACCESS

Here's a video for the tutorial hope you like it :)

Link for the MS.ACCESS FILE

https://drive.google.com/file/d/1CT8CcX2jj1HhwSjawFh7wXw9_Q2pjTvG/view?usp=sharing

11 Inserting Video, Audio, Screen Record and Voice Narration

Here is the link of my Powerpoint Slide :

https://drive.google.com/file/d/1YyhSjqUwoNvlUJ2KTYKk-0uBY9e3NZod/view?usp=sharing

How to do this powerpoint:

10 Creating / Inserting Hyperlink , Action Buttons in Microsoft Powerpoint

 We will be making a powerpoint by inserting a hyperlink, action buttons.

first just insert a picture then you will see an action icon click that and just go to hyperlink and choose what slide you will go to if you click a certain image or object 

for example:

the enter image click that  and go to insert and click action 

you will repeat the cycle unti l you'll able to come up with a game . 

I am already done with the quiz but when i published it on quizzes.com it's not working .

this is an an example  how to play the game 

this is the link for the quizizz.com, it's just pdf so it's not working. 

https://quizizz.com/admin/quiz/60afdb72668490001d2947dc

and  for the google drive fior you to have an access with my powerpoint, incase you want to have the same  font as the video I have uploaded the font as well it's chicken pie thank you 

https://drive.google.com/file/d/1U9J2WxBnOBdA-S_VkJJZ4ocvZBMsySIW/view?usp=sharing

CREATING VIDEO USING POWERPOINT INSERT IMAGE, MUSIC, automatic SLIDE TRANSITION, and animation

We will be creating a simple animation, 1st searched for background and then I used fade as a transition.

then after creating an aniomation I export it to video


ANIMATION:

gdrive link for the powerpoint will be this: https://drive.google.com/drive/u/0/folders/1AbEjik38wQIBx9VquObfW3ZIzxK9lFXH 

Exercise 8: Chart, Sorting Filter, Subtotal

              1. Sorting DATA by A-Z

2. Sorting names by A-Z

3.Sorting Loan amount From Z-A or highest to lowest 

4.Filtering Item type to Sporting Goods 

Subtotal

Creating and Customizing Charts 

    

All of my files are here: https://drive.google.com/drive/u/1/folders/1AbEjik38wQIBx9VquObfW3ZIzxK9lFXH

7 Functions of Excel (Sum,average,if condition,vlookup,count,max,min,count)

this is my payroll for my JINHIT company 

Payroll 

Payroll Formula

Google Drive Link 

https://drive.google.com/drive/u/0/folders/1AbEjik38wQIBx9VquObfW3ZIzxK9lFXH

Introduction to Excel Computing Budget , Supplies and Customer Invoice

 first of all, what we need to do is to open excel.

after that click the blank worksheet. to create a budget and supply you need to create a company logo. 

so here is one of the tricks I know and I wanted to share to remove the lines or color of  the box just select the certain  cells that you wanted to color

I have highlighted it and now I'll be clicking Alt+H

you will see different letters so if I want to change the color I chose the h so. Enter Alt+H+H

I wanted to color my table so I did this.

as you can see I have adjusted the column and rows so that my text and company logo will not move.

and then for me to enter all the expenses for my company I have inserted a table.

first, highlight the specified cells for your preferred table.

 

and click the table then okay.

after that label your columns row 

so you have to change the unit to peso 

after this, you have to find the product for the quantities and per price

and then you enter the total of everything. this would be the formula for my table 

So for the customer invoice, I created another sheet 

so I just did the same thing as the first sheet which is the budget and supplies 

1. label them
2. Input all the number 
3. Compute it. so under this text is the formula.

and the final input for my activity for today is this.

it was a bit hard but I enjoy making my own company 

btw if you wanted to know the file for my activity 

https://drive.google.com/drive/folders/1AbEjik38wQIBx9VquObfW3ZIzxK9lFXH