Ready to go beyond the basics? This course is for users who want intermediate-to-advanced database skills -- building more sophisticated relational structures, handling database maintenance, writing advanced queries, and creating polished forms and reports. Practical and hands-on throughout, with a focus on real-world database work. Prerequisite: MS Access Essentials or equivalent experience
« Data normalization
« Create a junction table
« Improve table structure
« Create query joins
« Relate data within a table
« Work with subdatasheets
« Create parameter queries
« Summarize data
« Create subqueries
« Create action queries
« Create unmatched and duplicate queries
« Include control formatting in a report
« Add a calculated field to a report
« Add a subreport to an existing report
« Add controls to forms
« Enhance navigation of forms
« Enhance organization of forms
« Apply conditional formatting
« Use field validation
« Use form and record validation
« Create a macro
« Restrict records using a condition
« Validate data using a macro
« Automate data entry using a macro
« Manage a database
« Determine object dependency
« Document a database
