SAKIMIMPACT
Microsoft Access
Detailed college-level relational database notes, 20 projects, examination and separate marking scheme.
Detailed Notes
1. Database Concepts
A database is an organized collection of related information. A DBMS provides tools for storing, retrieving, updating and presenting information. Access is a relational desktop DBMS.
2. Database Objects
Tables store records. Queries retrieve, calculate or modify data. Forms provide user-friendly data entry and navigation. Reports present organized information.
3. Fields and Records
A field is a category such as StudentName or Course. A record is a complete row describing one entity.
4. Data Types
Common Access types include Short Text, Number, Date/Time, Currency, Yes/No and AutoNumber. Select types based on how data will be stored and used.
5. Primary Keys
A primary key uniquely identifies records. It should be unique and normally not blank. AutoNumber can generate identifiers.
6. Relationships
Relationships connect tables. A one-to-many relationship allows one parent record to relate to many child records. Referential integrity helps maintain valid relationships.
7. Tables in Design View
Define field names, data types and properties, set the primary key, save the table and then enter records in Datasheet View.
8. Select Queries
Add tables, select fields, enter criteria, set sorting and run the query. Examples include Marks>=50, Course="ICT" and Marks Between 50 And 79.
9. Calculated Queries
Calculated fields can perform operations such as Total: [Quantity]*[UnitPrice]. Aggregate functions include Sum, Avg, Min, Max and Count.
10. Action Queries
Update queries modify records, append queries add records, delete queries remove records and make-table queries create a new table. Back up data before action queries.
11. Forms and Reports
Forms simplify data entry and reports organize information for presentation. Use meaningful labels, validation, sorting and grouping.
20 Practical Projects
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Task: Complete this project using the skills taught in the module. Plan the work, enter accurate information, apply professional formatting, save the file correctly and submit it to your instructor.
Assessment: accuracy, completeness, formatting, practical skills and final presentation.
Examination – 100 Marks
Section A – Short Answer
Section B – Structured Questions
Section C – Practical Questions
Answers / Marking Scheme – Teacher Section
Marking Scheme
Assess database terminology, Design View procedures, correct criteria, calculations, relationships, forms and reports. Practical work should be checked directly in the database file for accuracy and functionality.