Week 6:
Upload your Completed Excel Worksheet and Access Database with Imported Data and Tables
By the end of this week you will submit your completed Excel worksheet with employee data and created chart. You will also need to submit your Access Database with imported Excel data and two tables containing employee personal information
and workplace information. Now that the information has been entered and formatted in Excel, import the data into Microsoft Access as ADP has requested. Arrange the data into two tables: Personal Information and Workplace Information. Important Note: The employees names (first and last) need to appear in both tables.
Week 7:
Upload your Completed Access Database & One-page Narrative
By the end of this week you will submit your completed Access database with tables, queries, forms, and report. You will also need to submit a one-page narrative that answers the three questions provided below.
Your next steps for Week 7 are to
: • Join the two (2) tables based on the Last Name field with referential integrity enforced.•
Perform a simple query based on the two (2) tables using any criteria you feel appropriate.•
Create a parameter query based on the two (2) tables using any criteria you feel applicable.•
Produce a form based on the records in the Personal Information table. Select a form design you believe represents the data in the most professional manner
Answer:
Timely leadership and communication are important in shaping group culture.
Explanation:
Communication is important in building a culture it helps leader and pioneers to build up a culture of trust and can without much of a stretch form relationship with workers and different business channels that encourage associations to develop. Timely leadership and communication are two important pillars, that can work together to start a culture that will help an organisation to grow. Interaction with employees, starting group conversations and meetings can help employees to gain confidence, that will lead to a health group culture within an organisation.
The answer is addressability. This is where the messages in
the marketing are being customized in means of having to pair or match the
needs of the customers or their specific needs—in order to make their customers
want the product that they produce and sell it to them.
Answer:
Direct material used= $88,600
Explanation:
Giving the following information:
Beginning raw materials inventory$12,000
Raw materials purchase 88,000
Ending raw materials inventory 11,400
<u>To calculate the direct material used in production, we need to use the following formula:</u>
Direct material used= beginning inventory + purchases - ending inventory
Direct material used= 12,000 + 88,000 - 11,400
Direct material used= $88,600
Answer:
P514.70/$
Explanation:
At the beginning the exchange rate was P150/$
The inflation is 250% in Country A and 2% in country B.
The net inflation for the two countries exchange rate will be 125%.
The new exchange rate for the Color-Me-Green will be ;
P150/$ * 125% * fisher effect inflation rate = P514.70
