The aim of the course is to describe the concepts and the tools necessary to design your own db applications. The topics covered in the course will be supported by practical exercises that help explain even the most difficult concepts.
1. Complex database structure
• Database structure
• Relationships and referential integrity
• Designing an advanced database
2. Queries
• Summary of selection queries
• Queries on multiple tables
• Adding new fields by using a query: basic expressions
• Update query
• Delete query
• Append query
• Table query
3. Operators,
• Calculated fields, expressions, use of operators and functions
• Calculations on texts, on dates, logic calculations
• Reference to database objects and their properties
4. Forms, reports and macros
• Forms: creation, properties, editing tools
• Subforms
• Controls: bound and unbound, properties, typologies
• Creating and editing buttons and controls
• The expression builder
• Report: designing and customizing, order and groups; subreports
• Access macros: event management
Ad hoc
Contatti
