Mada za sehemu hiiWorking with presentation applicationsMada 5
- Familiarizing with a database application
- Creating tables and entering data
- Creating queries
- Creating forms
- Creating reports
A database is an organized collection of related data stored electronically so that it can be accessed, managed, and updated easily. In this topic, you will learn about databases, common database software, and how to use Microsoft Access to create and manage simple databases.
A database is a structured set of data held in a computer, especially one that is accessible in various ways. It allows users to store information in an organized way and retrieve it quickly when needed.
Key characteristics of a database:
- Organized data: Information is arranged in tables with rows and columns
- Easy access: Users can quickly find specific information
- Data integrity: Information can be updated without losing consistency
- Shared use: Multiple users can work with the same data
Databases are used everywhere in daily life. Here are some common examples:
- School records: Student information, grades, and attendance
- Bank systems: Customer accounts and transaction history
- Hospital records: Patient information and medical history
- Library system: Book inventory and borrower records
- Mobile phone contacts: Names and phone numbers stored on your phone
Several companies produce database management systems. The most common ones include:
- Microsoft Access — part of Microsoft Office suite, popular for small businesses and personal use
- MySQL — open-source database, widely used for web applications
- Oracle — powerful system for large organizations
- SQL Server — Microsoft's database product for business applications
For this course, we focus on Microsoft Access because it is user-friendly and suitable for learning basic database concepts.
How to Open Microsoft Access
- Click the Start button on your computer
- Scroll through the program list and click Microsoft Access
- The program window will open showing a list of database templates
How to Close Microsoft Access
- Click the File tab in the top-left corner
- Click Close to close the current database
- Click the X button in the top-right corner to exit the program completely
When you open Microsoft Access, you will see these important components:
Tables
Tables are the foundation of a database. They store data in rows and columns, like a spreadsheet.
- Rows represent individual records (e.g., one student)
- Columns represent fields or categories of information (e.g., name, age, grade)
Queries
Queries allow you to ask questions about your data and get specific answers. For example, you can ask "Show all students who scored above 80."
Forms
Forms provide a user-friendly way to enter and view data. Instead of looking at a table, users see a simple form with boxes to fill in.
Reports
Reports format and print data in a professional layout. For example, you can create a printed list of all students in a class.
Imagine a small secondary school in Arusha that wants to keep track of student information. Here is how they could set up a simple database in Microsoft Access:
Step 1: Create a New Database
- Open Microsoft Access
- Select Blank Database
- Type a name for your database, for example "School_Records.accdb"
- Click Create
Step 2: Create a Table
- Click Table Design to create a new table
- Add the following fields (columns):
- StudentID (AutoNumber)
- FullName (Text)
- Gender (Text)
- Age (Number)
- Stream (Text)
- Set StudentID as the Primary Key
- Save the table as "Students"
Step 3: Enter Data
- Switch to Datasheet View
- Enter student information:
- Amina Hassan, Female, 15, Form One
- Rajabu Mwinyi, Male, 16, Form Two
- Grace Michael, Female, 15, Form One
Step 4: Create a Query
- Click the Create tab
- Click Query Design
- Select the Students table
- Add fields you want to see (FullName, Stream)
- Set criteria to show only Form One students: type "Form One" under Stream
- Run the query to see the results
- User-friendly: Easy to learn and use, even for beginners
- Part of Microsoft Office: Works well with Word and Excel
- Visual tools: Forms and reports can be created without programming
- Affordable: Included in some Microsoft Office packages
- Suitable for small databases: Ideal for small businesses and personal projects
In Tanzania, small shop owners can use Microsoft Access to track their inventory and sales. For example, a dukawalla in Mwanza can create a database to record items received from wholesalers, items sold each day, and calculate profit. When a customer buys goods worth TZS 50,000, the shopkeeper can quickly check if the item is in stock and update the quantity sold, making daily record-keeping much easier than using handwritten notebooks.
Jinsi utakavyotathminiwaTathmini ya mchakato
Tathmini ya mchakato
Ability to work correctly with database applications
Swali
What is a database?
Ingia ili kuwasilisha jibu lako na lihesabiwe katika umahiri wako.
Ingia ili kufanya mazoeziMwalimu
Umekwama? Niulize chochote kuhusu mada hii.
Ingia ili kumuuliza Mwalimu wa AI wa Sonza kuhusu swali hili.
Ingia ili kuulizaMajadiliano
Hakuna maswali bado