Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

finallexam for pratical instruction, Exercises of Computer Science

Jigjiga UniversityComputer Science

Description This document is a comprehensive and professionally structured Practical Exam Answer Sheet specifically designed for students undertaking the Microsoft Access 2019 Level 2 course. It serves as a complete guide and reference for learners who are preparing for their practical examinations or working on coursework assignments that require the application of database management skills using Microsoft Access. The document is carefully organized to reflect the official exam format, ensuring that students can clearly understand what is expected in a real assessment environment. It includes a well-defined layout with dedicated sections for entering essential student details such as Name, Student Number, Location, and Date, making it ready for immediate academic submission. At its core, this file provides detailed, step-by-step solutions covering all the key areas required in a Microsoft Access practical exam. These solutions are presented in a clear and logical manner, allowingi

Typology: Exercises

2025/2026

Uploaded on 04/25/2026

caliwayl
caliwayl 🇪🇹

1 document

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1 of 4
ACS19L2(-(Practical(Component(Instructions(
Complete the practical component by following these instructions. You will use your completed Access
database files to answer the 40 questions of the online exam. You will not submit or upload your
completed files in myAOLCC.
Please return these instructions to your Learning Coach once you have completed the online exam.
Please note that these are general and not step-by-step instructions. In this practical component, you
will use Microsoft Access 2019 to perform the following functions:
• Use the primary key
• Create a composite index
• Use auto indexing
• Customize the ribbon
• Create tabs and groups on the ribbon
• Find, add, edit, and delete records in Datasheet View
• Use advanced sorting and filtering options
• Use subdatasheets
• Link an external database using a linked table
• Split an Access database
• Convert a shared table in a table
• Create a macro
• Work with the AutoExec macro
• Run VBA codes and handle errors
• Create an Update query
• Use operators in SQL statements
• Use password encryption and decryption
• Format a field on a form and use format painter
!
pf3
pf4

Partial preview of the text

Download finallexam for pratical instruction and more Exercises Computer Science in PDF only on Docsity!

ACS19L 2 - Practical Component Instructions

Complete the practical component by following these instructions. You will use your completed Access database files to answer the 40 questions of the online exam. You will not submit or upload your completed files in myAOLCC. Please return these instructions to your Learning Coach once you have completed the online exam. Please note that these are general and not step-by-step instructions. In this practical component, you will use Microsoft Access 2019 to perform the following functions:

  • Use the primary key
  • Create a composite index
  • Use auto indexing
  • Customize the ribbon
  • Create tabs and groups on the ribbon
  • Find, add, edit, and delete records in Datasheet View
  • Use advanced sorting and filtering options
  • Use subdatasheets
  • Link an external database using a linked table
  • Split an Access database
  • Convert a shared table in a table
  • Create a macro
  • Work with the AutoExec macro
  • Run VBA codes and handle errors
  • Create an Update query
  • Use operators in SQL statements
  • Use password encryption and decryption
  • Format a field on a form and use format painter

Instructions

Complete the following steps using any technique you wish.

  1. Using the template library, create a database Nutrition_Tracking using the Nutrition tracking template. Once the database is created, if there is a security warning at the top of the window, click Enable Content.
  2. Identify the field with the primary key in the My Profile table in the database. Create a composite index named FoodServing in the Foods table and add the following fields in it: Serving Size and Food. Keep Ascending as the Sort Order for both the fields.
  3. Add diet in the AutoIndex on Import/Create field and test it. Delete diet from the AutoIndex on Import/Create field. Delete the field with diet in the name that you’ve created to test the AutoIndex.
  4. Add a new tab called EDITS to the ribbon and add the group, Quick Formats. Add the Format Painter , Paste , and Paste Special commands to the group. Remove the new tab, group, and commands in the new group.
  5. Sort the Food Type column of the Foods table from A to Z. Remove the sort from the field.
  6. In the same table, sort the Potassium and Zinc columns simultaneously from largest to smallest. Make a note of the top values in the Potassium and Zinc columns you can see after sorting, because you’ll need that information later. Remove sort from the fields.
  7. Filter the Serving Size field in the Foods table of Nutrition_Tracking database to identify 0.1fruit. Remove the filter.
  8. Freeze the first four columns in the Foods table. Unfreeze all the fields.
  9. Attach the FoodLog table as a subdatasheet in the Foods table using the Property Sheet. Expand and collapse the subdatasheet added in the sheet. Remove the Subdatasheet.
  10. Split the Nutrition_Tracking database into front-end and back-end. Save the back-end file to your personal folder.
  11. Create and run the macro, mcrHealthMessage , in the Nutrition_Tracking database with the following details: Message: Inspiring Message Beep: Yes Type: None Title: You are worth it! Convert this macro into a VBA module and name the module, basHealth.
  1. Create another database named Healthy_Foods. Add a table named tblFoodType and include the following fields:
    • ID (AutoNumber)
    • FoodType (Short Text)
    • FoodOrders (Short Text)
    • Source (Short Text)
    • Quantity (Number) Use default properties.
  2. Link the FoodLog table from the Nutrition_Tracking database to the tblFoodType table of the Healthy_Foods database.
  3. Open the FoodLog table in Design View and check if you can edit the fields.
  4. Establish a relationship between the FoodEaten field from the FoodLog field table of the Nutrition_Tracking database and the FoodType field from the tblFoodType table of the Healthy_Foods database.
  5. Save the database file and keep it open. Let your Learning Coach know once you have completed your practical component. Keep the database files open on your desktop so that you will have the information available as you complete the online exam. Your Learning Coach will provide a code for you to access the online exam.