03 Conditional Logic 11/15/2018

If the grade is below or equal to 90, then I will get Grade A

If the grade is below or equal to 80 but less than 90, then I will get Grade B

If the grade is below or equal to 75 but less than 80, then I will get Grade C

 

  1. The important point that I learned from Conditional Statements is that whenever there is a condition, there will always be a corresponding result.
  2. I will be able to use what I’ve learned in a day to day living through stating or reminding myself that in every condition that I’ll be stating, there’ll be a corresponding result whether it is good or bad.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Functions and Importance of Variables in Visual Basic Programming

CODES IN ORDER TO CREATE THIS FORM

 

12

  • In the form class, I have declared the variables. Two variables are for accepting the numbers for the calculation.
  • The third variable is of type Integer that has used to perform the operation such as Addition, Subtraction, Multiplication, and Division.
  • In the first part, the ” Dim num1 as Integer “, ” Dim num2 as Integer ” and ” Dim answer as Integer ” is to set the terms that will be used all throught out the program code that’ll be used.
  • Then in the next part is for the 2 textbox where you will put the numbers you want to be solved.Where you type ” num1 = Textbox1.Text ” and ” num2 = Textbox2.Text “
  • Then the next one is the ” Answer = num1 + num2 ” for the operation to be applied.
  • The last part is the “Textbox3.Text = Answer ” where you will see the answer.
  • And if you want to change the operation from addition, just change the terms in the first part from sum to difference, product or quotient.

Steps in Creating a Form of an Existing Table

Access makes it easy to create a form from any table in your database. Any form you create from a table will let you view the data that’s already in that table and add new data in the table. Once you’ve created a form, you can also modify it by adding additional fields and design controls such as combo boxes.

To create a form:

1.In the Navigation Pane, select the table you would like to use to create a form.You do not need to open the table.
2.Select the Create tab on the Ribbon, and locate the Forms group. Click the Form Command.
3. Your form will be created and opened in Layout View.
4.To save the form, Save command on the Quick Access toolbar. When prompted, type a name for the form, then click OK.

Which would you use to enter records in a database? table or a form? 

I would use a form to enter records in a database because Forms do not contain any data but they are used because they’re an easy way to guide the user into entering data correctly.Working with extensive tables can be confusing, and when you have connected tables you might need to work with more than one at a time to enter a set of data.

What are the features of form that makes it unique over a table?

Tables can be confusing. However, with forms, it’s possible to enter data into multiple tables at once, all in one place.Restrictions can easily be set on individual form components to ensure all of the needed data is entered in the correct  format.All in all forms keep data consistent and well-organized, which is essential for an accurate and powerful database.”

Sorting and Filtering

OUR BREAD DATABASE

most least sold bread SORT

1.Most/Least sold bread

most least sold bread 2.Customer who bought the most number of bread

Kinds fo bread FILTER

3. Most frequently bought breads

most frequently bought  4. Least frequently bought breads

least frequently bought breads

5.Searching kind of bread (pan)

Kinds fo bread

REFLECTION

Filtering and Sorting are tools that let you customize how you organize and view your data.When you sort data, you are putting it in order.Filtering data lets you hide unimportant data and focus only on the data you’re interested in.Both tools make your data more convinient to work with.