This course focuses on optimization of Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries and reports. You will:
- Provide input validation features to promote the entry of quality data into a database
- Organize a database for efficiency and performance, and to maintain data integrity
- Improve the usability of Access tables
- Create advanced queries to join and summarize data
- Use advanced formatting and controls to improve form presentation
- Use advanced formatting and calculated fields to improve reports
When taught in-person, this course is 8 hours in one day, with a 1 hour lunch.