Question: Please show a step by step process and what the end result should look like EVENTS begin{tabular}{|l|l|l|l|l|} hline multicolumn{1}{|c|}{ Field Name } & multicolumn{1}{c|}{ Type

Please show a step by step process and what the end result should look likePlease show a step by step process and what the end result

should look like EVENTS \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ Field Name } & \multicolumn{1}{c|}{

EVENTS \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ Field Name } & \multicolumn{1}{c|}{ Type } & Length / Size & \multicolumn{1}{c|}{ Index } & \multicolumn{1}{c|}{ Comments } \\ \hline Event_ID & AutoNumber & Long Integer & Yes (No Duplicates) & Primary Key \\ \hline Event_Title & Short Text & 45 & & \\ \hline Event_Description & Long Text & & & \\ \hline Event_Category & Short Text & & & LookupValueListwiththefollowingvalues:Internal,DonorCampaign,CharityRun,Auction,Gala,Workshop \\ \hline Event_Active & Yes/No & & & \\ \hline Event_Date & Date/Time & & & \\ \hline \end{tabular} TASKS \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ Field Name } & \multicolumn{1}{c|}{ Type } & Length / Size & \multicolumn{1}{c|}{ Index } & \multicolumn{1}{c|}{ Comments } \\ \hline Task_ID & AutoNumber & Long Integer & Yes (No Duplicates) & Primary Key \\ \hline Event_ID & Number & Long Integer & & Foreign Key (Lookup-based) \\ \hline Staff_ID & Number & Long Integer & & Foreign Key (Lookup-based) \\ \hline Task_Title & Short Text & 45 & & \\ \hline Task_Description & Long Text & & & \\ \hline Task_Due_Date & Date/Time & & & \\ \hline Task_Complete & Yes/No & & & \\ \hline \end{tabular} Belmont Care Center (BCC) is starting a project management office (PMO) to help manage fundraising events throughout the year. The expected process the PMO will follow is as follows: 1. PMO staff members will propose new events that will generate donations directly, or projects that will lead to recurring donations over time. 2. Each event or project will have various tasks that need to be completed to realize the outcomes of the activity. A single staff member is assigned and becomes responsible for completing the task. BCC PMO has come to you for help with creating and configuring a Microsoft Access database that can be used to track all of these projects and tasks. In determining what the database needs to do for BCC, you sketch the following entity relationship diagram and note their table definitions on the next page: To prepare the database for BCC PMO, you will need to perform the following actions: - create \& populate tables, - link tables together through lookups and relationships, - create queries to display results, - create forms for data entry, - create reports for tables and queries, - create a navigation menu for the database. Each of these are described throughout the rest of the document

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!