Microsoft Access
Access is an easy-to-use tool for creating business applications, from templates or from scratch. With its rich and intuitive design tools, Access can help you create appealing and highly functional applications in a minimal amount of time.
Learning Outcomes:
- Explain fundamental database concepts and design a basic database structure using appropriate tables, fields, and relationships
- Create tables and queries, including select queries and advanced multi-table and nested queries using calculations, functions, and grouping
- Develop user-friendly forms and subforms, incorporating navigation controls and conditional formatting to support efficient data entry
- Produce professional reports, including advanced reports with calculated fields and summaries to present data effectively
- Manage data securely, including importing and exporting data while applying data integrity and database security measures
Business Services Organisation