Database Migration Project - Microsoft Access
Preferred learners
- Anywhere
- Academic experience
Categories
Skills
Project scope
- What is the main goal for this project?
-
The main goal for the project is to migrate the existing Microsoft Excel database of customers, class schedules, teachers, and students into Microsoft Access. This will involve understanding the current structure of the Excel database, designing a new database schema in Microsoft Access, and transferring the data from Excel to Access while ensuring data integrity and consistency.
- What tasks will learners need to complete to achieve the project goal?
-
- Analyzing the structure and relationships of the current Excel database.
- Designing a new database schema in Microsoft Access.
- Migrating the data from Excel to Access.
- Testing the migrated database to ensure data integrity and consistency.
- Providing documentation on the new database structure and migration process.
- What is the main goal for this project?
-
The main goal for the project is to migrate the existing Microsoft Excel database of customers, class schedules, teachers, and students into Microsoft Access. This will involve understanding the current structure of the Excel database, designing a new database schema in Microsoft Access, and transferring the data from Excel to Access while ensuring data integrity and consistency.
- What tasks will learners need to complete to achieve the project goal?
-
- Analyzing the structure and relationships of the current Excel database.
- Designing a new database schema in Microsoft Access.
- Migrating the data from Excel to Access.
- Testing the migrated database to ensure data integrity and consistency.
- Providing documentation on the new database structure and migration process.
- How will you support learners in completing the project?
-
Students will connect directly with us for mentorship throughout the project. We will be able to provide answers to questions such as:
- Our database of information
- Input on choices, problems or anything else the students might encounter.
About the company
- https://www.truetraining.ca
- 2 - 10 employees
- Business services, Education, Government, It & computing, Public relations & communications
Project managers providing a variety of goods and services to the provincial and federal governments in Canada.