Database processing

Syllabus

Thematic definition of exercises: 1. Introduction to MS Access - orientation in the program. Characteristics of database objects (tables, queries, forms, reports, macros, modules). Design and creation of a database. Normalization of the database. 2. Tables: table design, table creation via wizard, in design view, in data view, table structure, data types and basic properties, primary and foreign key. Creating and modifying relationships (sessions), referential integrity. Table editing. Filters and sorting in tables. 3. Forms: automatic form generation based on an existing table or query. Form creation using wizard and in design view. Other view options - multiple items, data sheet, split form. Layout options. 4. Forms: form format editing, inserting and editing controls in the form: name bar, rectangle, line, command button, tab, image. Graphical formats used in MS Access. 5. Forms: other controls - toggle button, option button, list, unbound object, bound object, bound object, option group, forms with subforms. Form creation in the form of a navigation bar. 6. Queries: creating a selection query using query wizard and in design view. Defining criteria in a selection query. Parametric queries. Summary queries, aggregation functions SUM, MIN, MAX, AVERAGE, COUNT. 7. Queries: calculations in queries - expression creation. Use of basic operators: +,- , * , / , aggregation functions, use of logical IIF function, other functions. Selecting the highest and lowest values from a sample. 8. Queries: creating action queries using wizard and in design view (create, join, delete, update), defining criteria and creating expressions. Importing and exporting data. Cross queries - cross query wizard. 9. Reports: automatic report generation based on an existing table or query. Creating single and multi-level reports using wizard and in design view. Report layout options. 10. Reports: formatting reports, inserting and editing controls in a report. Expression creation and aggregation functions in reports. Label wizard for creating standard or custom labels. Creating name tags (address labels), creating business cards. 11. Macros: catalogue of actions. Adding actions to the macro designer, searching for macro actions, reusing macros. Actions whose execution in databases is considered untrusted. Macro as a command button. 12. Complex example: practical practice of the acquired knowledge and skills on a complex example, from problem definition, through the design and creation of a database and its individual objects, focusing on the solution of a specific business problem. 13. Practical written work: verification of acquired knowledge and skills in the issue of relational databases, specifically the Microsoft Access database program.