|
Lecturer(s)
|
-
Šilhavý Petr, doc. Ing. Ph.D.
-
Prokopová Zdenka, doc. Ing. CSc.
-
Bajusová Darina, Ing.
|
|
Course content
|
- Introduction to Microsoft Access - basic terms. - Architecture of MS Access. - Database design, table design, table modification. - New records insertion, data uploading and deleting. - Data import and export. - Simple queries. - Queries for several tables. - Aggregations. - Basic forms and advanced functions. - Reports and web reports. - Macros utilization. - Database publication. - Database application area.
|
|
Learning activities and teaching methods
|
Monologic (Exposition, lecture, briefing), Dialogic (Discussion, conversation, brainstorming), Methods for working with texts (Textbook, book), Demonstration, Exercises on PC
- Participation in classes
- 42 hours per semester
- Term paper
- 30 hours per semester
- Home preparation for classes
- 14 hours per semester
- Preparation for course credit
- 22 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| Basic knowledge from fundamentals of computer techniques and office software. |
| Basic knowledge from fundamentals of computer techniques and office software. |
| learning outcomes |
|---|
| list the most common database management systems |
| list the most common database management systems |
| describe the individual components of a user-friendly database management system |
| describe the individual components of a user-friendly database management system |
| characterise the way data is stored in a relational database |
| characterise the way data is stored in a relational database |
| explain the possibilities of retrieving required information from stored data |
| explain the possibilities of retrieving required information from stored data |
| describe the possibilities of inserting data and outputting the required outputs |
| describe the possibilities of inserting data and outputting the required outputs |
| Skills |
|---|
| create tables and relationships between them in a user-friendly database management system |
| create tables and relationships between them in a user-friendly database management system |
| implement inserting, importing or linking data into tables |
| implement inserting, importing or linking data into tables |
| retrieve required information from stored data |
| retrieve required information from stored data |
| create appropriate output reports |
| create appropriate output reports |
| apply appropriate tools to run automated data processing |
| apply appropriate tools to run automated data processing |
| teaching methods |
|---|
| Knowledge |
|---|
| Methods for working with texts (Textbook, book) |
| Dialogic (Discussion, conversation, brainstorming) |
| Dialogic (Discussion, conversation, brainstorming) |
| Monologic (Exposition, lecture, briefing) |
| Methods for working with texts (Textbook, book) |
| Demonstration |
| Demonstration |
| Exercises on PC |
| Exercises on PC |
| Monologic (Exposition, lecture, briefing) |
| assessment methods |
|---|
| Written examination |
| Grade (Using a grade system) |
| Grade (Using a grade system) |
| Conversation |
| Conversation |
| Systematic observation of the student |
| Systematic observation of the student |
| Written examination |
| Analysis of the student's performance |
| Analysis of the student's performance |
|
Recommended literature
|
-
Kruczek, Aleš. Microsoft Access 2010 : podrobná uživatelská příručka. Vyd. 1. Brno : Computer Press, 2010. ISBN 978-80-251-3289-0.
-
PÍSEK, S. Access 2010 ? podrobný průvodce. Praha, 2010. ISBN 978-80-247-3653-2.
-
Riordan, Rebecca M. Vytváříme relační databázové aplikace. Brno : Computer Press, 2000. ISBN 80-7226-360-9.
|