Intermediate Computer Application

Study Notes

Focus on Learning Outcomes (LOs) for week #10.
Module 7 covers Integration Level 2, including a lecture and lab session.
Upcoming Test in week 11 accounts for 20% of grade, centered on database knowledge.

Use the Fleming Network account responsibly for assignments.
Customize business materials using Microsoft Word to improve professional appearance.
Manage multiple Microsoft Office and Windows applications simultaneously for data sharing.
Utilize functions in Microsoft Office to share, link, or embed data across applications.
Design relational databases with multiple tables and appropriate relationships.
Employ basic database functions for creating and modifying tables, forms, queries, and reports.
Choose the suitable Microsoft Office software application to address business information needs.

Comprises related tables that store and access organized data.
Each table row represents a unique record identified by a primary key.
Table columns represent attributes, allowing easy data relationship establishment.
Non-relational databases do not rely on inter-table relationships for data storage.

Essential elements include:
- Tables and Keys (Primary and Foreign Keys)
- Forms for data entry
- Queries to retrieve specific data
- Reports for data presentation

Previous databases created include Authors with Books and Students with Courses.
Current focus is on creating a database for Customers and Tea Products.
Tea sales data imported from Excel to Access for database processing.
Reports generated in Access can be exported to Word and saved as PDF files.

Important to establish a one-to-many relationship between Customers and Tea Products.
The Foreign Key facilitates this relationship, although primary key details may not always be displayed.

Hands-on creation of the Customers table and importing sales data from Excel to Access.
Learning to create, modify, and manage databases using Microsoft tools through hands-on labs.