Posts

Showing posts with the label 5 - Worksheet

Example: School Database

  1. Tables What It Is : A table stores all the data, like a spreadsheet. Each row is a record (like a student’s details), and each column is a category (like the student’s name, age, or grade). Example Table : Student ID Name Age Grade Class 001 Alice Smith 14 9th Math 002 Bob Johnson 15 10th Science 003 Carla Diaz 16 11th History Explanation : In this table, each student has a unique ID, and the columns show key details about them. The table can be as big as necessary, with hundreds or thousands of students. 2. Queries What It Is : Queries are like questions you ask to get specific information from your database. You can filter data or search for certain details. Example Query : "Show all students in 10th grade." Result of Query : Student ID Name Age Grade Class 002 Bob Johnson 15 10th Science Explanation : The query has filtered the table to show only students in the 10th grade. It helps you find the exact information you need without looking through the whole table. 3. Fo...

G5-Worksheet

 081-05-05          Home Assignment MS-ACCESS # How to create first project on MS-Access? 1.     1. Open 2.   Create with blank document file 3.    Rename the file and click on create 4.    Go to view tab and click on design view for design the layout 5.    Name the table 6.    Go to datasheet view to show the designed result.

Last 7 Days

Creating a Ping Pong Game in mBlock

Unit-1 Computer Network

Grade-3 (KEYBOARD)