Description
Overview:
This course provides the basic concepts and skills to use Microsoft Access including how to navigate the Access interface, and how to create and modify tables, queries, forms, and reports. Also learn the concepts and skills for the advanced use of Microsoft Access including how to create advanced queries, forms, and reports, how to create macros, and how to manage your databases.
Prerequisite(s):
At least one year experience using Windows 10, 8, or 7
Audience:
Outline:
Lesson 1: Database fundamentals
- Understanding general database terms
- Relational databases
- Access interface and objects
Lesson 2: Tables
- Creating tables
- Creating fields
- Data Validation
- Relationships and keys
Lesson 3: Queries
- Creating basic queries
- Modifying queries
- Using calculated fields
Lesson 4: Forms
- Creating simple forms
- Form design
- Form controls
Lesson 5: Reports
- Creating Reports
- Report controls
- Formatting reports
Lesson 6: Advanced queries
- Grouping and summarizing
- Updating, deleting, and relationships
- Indexing for performance
Lesson 7: Advanced forms
- Subforms
- Advanced control types
- Specialized form types
Lesson 8: Advanced reports
- Subreports
- Advanced grouping
- Advanced formatting
Lesson 9: Macros
- Creating basic macros
- Using variables
- Troubleshooting macros
Lesson 10: Database management
- Compact & Repair
- Restoring a database
- Other maintenance tasks
Reviews
There are no reviews yet.