UNLOCKING CASH FLOW STATEMENTS: A GUIDE TO DIRECT AND INDIRECT METHODS

The details of this programme are as follows:

🗓️ Date: 28 June 2024 (Friday)

🕒 Time : 3.00 - 4.00 PM

💻 Platform: Cisco Webex

👨🏻‍🏫 Visiting lecturer: Dr. Arie Pratama from Universitas Padjadjaran

📍Open to all.

📍e-certificate will be given to all participants.

SESI MEET & GREET PUiTM 2024

TAKLIMAT DALAM TALIAN - MERUNGKAI AKTA ANTIGANGGUAN SEKSUAL (AKTA 840) & PROSES ADUAN DI TRIBUNAL BAGI ANTIGANGGUAN SEKSUAL

PROPENS - Done

PROPENS

Coffee Break after 3 days of hard work

Step 13: Create Report - Customers Purchase

1. Double click Cust_Purchases in Queries to open it

2. Click on the Create tab in the Ribbon.

3. Click on Report in the Reports group.

4. Save the Query

• Name the query Cust_Purchases_Report when prompted.
• Click OK to save the query with this name.

5. Save the Report

• Ensure all changes are saved by clicking the Save icon on the Quick Access Toolbar or by pressing Ctrl + S.

6. Close the Report

• Close the query by clicking the Close button (X) on the query tab or right-clicking the query tab and selecting Close.

4. To re-open Report

• Double Click Cust_Purchases_Report at Report.

Step 12: Create Queries - City Jengka

1. Single click Customers table

2. Click on the Create tab in the Ribbon.

3. Click on Query Design in the Queries group.

4. Double-click the Manufacturers table and Customers table to add it to the query design grid.

5.Close the Show Table dialog box after adding the table.

6. Add customer’s ID and name, city, price/unit, manufacturer’s name, city and discount available availableto the Query

7. Save the Query

• Name the query City_JGKA when prompted.
• Click OK to save the query with this name.

8. Specify the Criteria to Filter by City

• Set the Criteria for the City:
• In the query grid, find the City column (you might need to scroll right if it's not visible).
• In the Criteria row under the City column, type "JGKA" (including quotes). This ensures the query will only include records where the city is JGKA.

8. Run the Query to Verify the Results

• Run the Query:
• Click on the Run button (red exclamation mark) in the Design tab to execute the query and view the sorted records.

• Or Simply Double click City_JGKA. at Queries

9. Save the Query

• After verifying that the records are sorted correctly, click on the Save button on the Quick Access Toolbar, or press Ctrl + S.

10. Close the Query

• Close the query by clicking the Close button (X) on the query tab or right-clicking the query tab and selecting Close.

Step 11: Create Queries - Customers Purchase

1. Single click Customers table

2. Click on the Create tab in the Ribbon.

3. Click on Query Design in the Queries group.

4. Double-click the Manufacturers table and Customers tableto add it to the query design grid.

5.Close the Show Table dialog box after adding the table.

6. Add customer’s name, quantity, price/unit, manufacturer’s name, and discount availableto the Query

7. Save the Query

• Name the query Customer_Purchases when prompted.
• Click OK to save the query with this name.

8. Run the Query to Verify the Results

• Run the Query:
• Click on the Run button (red exclamation mark) in the Design tab to execute the query and view the sorted records.

• Or Simply Double click Customer_Purchases at Queries

9. Save the Query

• After verifying that the records are sorted correctly, click on the Save button on the Quick Access Toolbar, or press Ctrl + S.

10. Close the Query

• Close the query by clicking the Close button (X) on the query tab or right-clicking the query tab and selecting Close.

Step 10: Create Queries - Manufacturers discount of => 5%

1. Single click Manufacturers table

2. Click on the Create tab in the Ribbon.

3. Click on Query Design in the Queries group.

4. Add the Manufacturers Table to the Query

5. Double-click the Customers table to add it to the query design grid.

6.Close the Show Table dialog box after adding the table.

7. Add manufacturer name, city, and discount, to the Query

7. Save the Query

• Name the query Manufacturers_Above 5% when prompted.
• Click OK to save the query with this name.

8. Set the Criteria for Discounts:

• In the query grid, find the Discount column.
• In the Criteria row under the Discount column, type >= 0.05. (This tells Access to include only those records where the discount is 5% or greater)

9. Run the Query to Verify the Results

• Run the Query:
• Click on the Run button (red exclamation mark) in the Design tab to execute the query and view the sorted records.

• Or Simply Double click Manufacturers_Above 5% at Queries

10. Save the Query

• After verifying that the records are sorted correctly, click on the Save button on the Quick Access Toolbar, or press Ctrl + S.

11. Close the Query

• Close the query by clicking the Close button (X) on the query tab or right-clicking the query tab and selecting Close.