Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use database software to complete a master index for subject records files for a small business. Some records have already been entered into the database.

Use database software to complete a master index for subject records files for a small business. Some records have already been entered into the database. You will add records and sort the database, query the database to show only a portion of the master index, and create a report showing the complete index.

1. Download the data file8-1 Master Indexto a computer or a removable storage device, and then open it with Microsoft Access.

2. Enter records into the Master Index table for the remaining files listed below. For records with only main subject titles, enter only the main subject title in the Main field. For records with main titles and subdivisions of main titles, enter the main title in the Main field and the subdivision title in the Sub field. (You will add subdivisions for some main titles already in the index.) Save the table.

Main TitleSubdivisionUtilitiesUtilitiesNatural GasUtilitiesElectricUtilitiesWaterAccountingCredit CardsReportsReportsAnnual ReportsReportsQuarterly ReportsReportsMonthly ReportsAccountingLoans3. Use the Advanced Filter/Sort feature to sort the Master Index table by the Main field, then by the Sub field to place the index into alphabetic order.

4. Create a query based on the Master Index table. The query results should display the Main field in the first column and the Sub field in the second column. The query results should show all records that have Office Equipment in the Main field. Sort the Main field in ascending order and the Sub field in ascending order. Save the query as "Office Equipment Query." Run the query and save the query results.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Governmental And Nonprofit Entities

Authors: Jacqueline Reck, Suzanne Lowensohn, Daniel Neely

19th Edition

1260118851, 9781260118858

More Books

Students also viewed these Accounting questions

Question

What is the formula to calculate the mth Fibonacci number?

Answered: 1 week ago

Question

13. Give four examples of psychological Maginot lines.

Answered: 1 week ago