Database notes

This section is database fundamentals: what a database is, how tables, records and fields fit together, the primary key, why a DBMS differs from a spreadsheet, and how to create a simple database…

This section is field properties and table design under Database: choosing data types, setting field size, format, default value, required, validation rules, input masks, confirming the primary key…

This section is queries under Database: designing select queries, using criteria, AND / OR / NOT logic, sorting, showing or hiding fields, and knowing query versus filter. Reports and integration…

This section is reports and integration: create polished reports, use headers and footers, sort output, run calculations in the right place, then import and export so the same data works in other…