Illustrated Access 2019 Modules 1-4 Sam Capstone Project

Illustrated Access 2019 Modules 1 4 Sam Capstone Project 1amidwest

Develop an Access database application to manage and analyze companies, jobs, applicants, and job placements for Midwest Executive Professionals. Modify tables, create and modify queries, forms, and reports according to given specifications. Import data, update records, set table properties, run queries with criteria, and customize forms and reports in layout and design. Finalize by compacting and repairing the database before submission.

Paper For Above instruction

Introduction

Microsoft Access 2019 is a powerful database management system that enables users to efficiently organize, analyze, and report data. The following project demonstrates the comprehensive process of creating a professional database tailored for Midwest Executive Professionals, a firm specializing in connecting job seekers with employment opportunities. This project covers modifications to tables, data import, query creation and adjustment, form and report customization, along with final database maintenance procedures to ensure data integrity and performance.

Database Preparation and Initial Modifications

The first step involves opening the provided database file, renaming it appropriately to preserve original data, and importing supporting data files. The Support_AC19_CS-1-4a_Industries.xlsx file hosts industry data that needs to be appended to the existing Industries table. Identification of the correct table, renaming it from Categories to Industries, ensures the schema accurately reflects the data context, which is crucial for data integrity and ease of use.

Furthermore, the Applications table undergoes structural modification by adding a FollowupDate field to facilitate follow-up scheduling for job applications. Renaming the ID field to ApplicationID improves clarity and consistency across the database schema.

Record Management and Data Entry

Data accuracy is vital; thus, the project tasks include deleting obsolete or test records such as Richard Marlay, editing existing records for clarity like changing John to Jonathan, and adding new records to capture recent data. These operations ensure the database remains current and reflective of actual business data.

Table Design and Data Organization

To enhance data management, a new Employees table is created with designated fields, primary key, input masks, and default values. Fields like Email are set with required properties, enforcing data entry standards. Adjustments such as deleting unnecessary columns and sorting data in the JobSeekers table improve data usability and report generation precision.

Query Development and Data Filtering

Queries are instrumental in extracting meaningful insights. A join query between Companies and Jobs tables with criteria for high starting salaries (greater than or equal to $50,000) is designed to analyze lucrative opportunities. The use of the Query Wizard to create a detailed query retrieving all relevant job seeker and application data supports comprehensive data analysis.

Further filtering is performed using criteria in queries such as ApplicationListing and DirectorSeptember, targeting specific job titles and application dates, allowing tailored insights into applicant trends and departmental activities.

Form and Report Customization

The creation of user-friendly data entry forms and visually appealing reports enhances data engagement. The Jobs form employs a columnar layout for efficient data entry. The CompanyListing report groups companies by industry, providing summarized views that are vital for strategic analysis.

Editing forms to modify labels, reposition fields, and style command buttons improves the user experience and data accuracy. Conditional formatting in reports highlights noteworthy salary data, offering visual cues for managerial decision-making. Grouping and color styling further improve report clarity and professional appearance.

Finalization and Optimization

The project concludes with saving all modifications, closing open objects, and performing database maintenance tasks like compacting and repairing to optimize performance. These steps are crucial for maintaining database integrity and ensuring it functions efficiently over time before submission.

Conclusion

This comprehensive project illustrates the effective application of Access 2019 features to develop a functional and professional database solution tailored for a recruitment firm. Through methodical table management, query design, form and report customization, and final database maintenance, users can create a robust data environment that supports analysis and decision-making essential for business success.

References

  • Bell, L. (2017). Access 2016 Programming by Example: With VBA, XML, and ASP. Pearson Education.
  • Hart-Davis, G. (2018). Microsoft Access 2019 Bible. John Wiley & Sons.
  • Gaskin, B. (2020). Mastering Microsoft Access 2019. Packt Publishing.
  • Walls, S., & Minasi, M. (2019). Microsoft Access 2019: Building & Managing Reports. Microsoft Press.
  • Lexico. (2023). Microsoft Access. https://www.lexico.com/definition/microsoft_access
  • Microsoft. (2023). Create and manage tables in Access. https://support.microsoft.com/en-us/office/create-and-manage-tables-in-access-70803e7d-4e16-4c4f-88a5-f71e6b8204b9
  • Groh, K. (2019). Using Queries in Microsoft Access. TechRepublic.
  • Rogers, M. (2021). Designing Effective Forms and Reports in Access. TechTarget.
  • VBA Guide. (2022). Guidelines for Using VBA in Access. VBAExpress.com.
  • Penfold, P. (2020). Data Import and Export in Microsoft Access. DataQuest Publishers.

Related Assignments