Computer Applications I
Interactive Syllabus - Unit B
SOFTWARE APPLICATIONS FOR BUSINESS
5.00 Understand databases used in business.
5.01 Understand database tables used in business.
5.02 Understand database queries, forms, and reports used in business.
**Please see your instructor for the user name and password to have access to all assignments and reviews.
Unit Outline
5.01 Outline Database Tables (PDF File, 32 KB)
5.02 Outline Database Queries, Forms, and Reports (PDF File, 26 KB)
Class Notes & Essential Questions **
5.01 Database Tables
Essential Questions:
How is database information used, organized, and managed in business?
For what purposes?
- Slideshow 5.01 Database Fundamentals
- 5.01 Database Fundamentals graphic organizer (PDF File, 10 KB)
- Slideshow 5.01 Data Types and Field Properties
- 5.01 Data Types and Field Properties graphic organizer (PDF File, 24 KB)
- Slideshow 5.01 Database Relationships
- 5.01 Types of Relationships graphic organizer (PDF File, 30 KB)
Essential Questions:
What is a database query, how is it used, and how does it differ from a filter?
What is a form, how is it used and formatted, and how does it differ from a table?
What is a database report? How is it used? What report elements are used to control and enhance the appearance of the report and why?
5.02 Understand database queries, forms, and reports used in business.
- Slideshow 5.02 Queries
- 5.02 Q-F-R graphic organizer - Queries (PDF File,7 KB)
- Slideshow 5.02 Forms
- 5.02 Q-F-R graphic organizer - Forms (PDF File, 7 KB)
- Slideshow 5.02 Reports
- 5.02 Q-F-R graphic organizer - Reports (PDF File, 9 KB)
Activities **
5.01 Database Tables
Guided Practice: Search an Online Database (PDF File, 36 KB)
Review of Database Tables (PDF File, 20 KB)
Guided Practice: Create a Database: Computers (PDF File, 21 KB)
Independent Practice: Create a Database: Scavenger Hunt (PDF File, 30 KB)
Guided Practice: Database Management: Anti-Virus (PDF File, 21 KB)
Independent Practice: Create a Database: Survey (PDF File, 14, KB)
Guided Practice: Create a Database: MusicFun (PDF File, 35 KB)
Independent Practice: Create a Database: B&B (PDF File, 40 KB)
Database Reveiw (PDF File, 38 KB)
Determining Sort Order (PDF File, 23 KB)
Understanding Operators (PDF File, 56 KB)
Guided Practice: Filtering and Sorting a Database (PDF File, 13 KB)
Independent Practice: Filtering and Sorting a Database (PDF File, 21 KB)
Guided Practice: One to Many Relationships (PDF File, 44 KB)
A Little More Guidance (PDF File, 33 KB)
Independent Practice: One-to- Many Relationships (PDF File, 32 KB)
Example of a One to Many Relationship
Guided Practice: Many-to-Many Relationships (PDF File, 40 KB)
Independent Practice: Many-to- Many Relationships (PDF File, 30 KB)
Example of a Many to Many Relationship
Guided Practice: Importing Data (PDF File, 11 KB)
Independent Practice: Importing Data (PDF File, 16 KB)
Database Concept Review (PDF File, 9 KB)
5.02 Queries, forms, and reports
Guided Practice: Query: B&B Database (PDF File, 20 KB)
Independent Practice: Query: Pet Registry (PDF File, 20 KB)
Guided Practice: Forms (PDF File, 50 KB)
Independent Practice: Forms (PDF File, 27 KB)
Guided Practice: Add Subforms (PDF File, 43KB)
Independent Practice: Add Subforms (PDF File, 22 KB)
Guided Practice: Reports (PDF File, 9 KB)
Independent Practice: Reports (PDF File, 8 KB)
Resources
Computer
Applications I Glossary
Learn it Online - Office2007
More Access Resources Online
Reveiw **
| Back to Interactive Syllabus Index | | | Assignments Home | | | Comp App I Assignments Index |