UC知道我的it作业，有一项没看明白什么意思，大家帮下忙，在线等，50分。
来源：百度知道 编辑：UC知道 时间：2024/06/28 20:01:29
You are required to create a semi automated invoice using the workbook sales invoice.XLS. Currently, the client has to be typed in manually. This is very unproductive. The client details are currently held in a database. Your job is to modify the invoice so that client data is updated when you enter the client ID. First familiarize yourself with this workbook then modify the workbook as follows.
1. The customer details are in an MS Access database called clients.mdb. It contains clients from all states. As you are preparing this sales invoice for the South Australian branch you will need to create a query that draws out information about South Australian clients. Your first task is to create and save a query that retrieves all SA clients. Name the query qrySAClients. You will be using the data from this query in the invoice workbook.
2. Open the workbook sales-invoice.XLS and import the data from qrySAClients into a new worksheet. Give a name to the new worksheet. T
1. The customer details are in an MS Access database called clients.mdb. It contains clients from all states. As you are preparing this sales invoice for the South Australian branch you will need to create a query that draws out information about South Australian clients. Your first task is to create and save a query that retrieves all SA clients. Name the query qrySAClients. You will be using the data from this query in the invoice workbook.
2. Open the workbook sales-invoice.XLS and import the data from qrySAClients into a new worksheet. Give a name to the new worksheet. T
不知道你的问题是在看不懂英文题还是如何在excel里实现。
如果你是不懂英文题，那不知道你为啥还要继续下去。算了看在50分的份上帮你简单翻译一下好了。按照英文原始段落顺序：
需要你通过工作簿“sales-invoice.XLS”建立一套自动发票系统。现状：客户必须手工输入，效率低下。客户资料存于数据库中。你的任务是将发票更改为当输入客户id时客户资料自动更新。首先熟悉工作簿，然后按以下要求修改之。
1、客户详细信息存于access数据库文件clients.mdb中，包含所有状态信息。你要准备South Australian branch的客户发票，相应就需要查询South Australian branch 的客户资料。使用名为qrySAClients的查询之。此查询数据将被用于后续发票工作簿。
2、打开“sales-invoice.XLS”工作簿，将qrySAClients查询结果导入新建sheet并给新建sheet重命名。此部分数据将用于生成发票。
3、选择名为SalesInvoice的sheet并填写公式，使录入client ID时其余该客户信息自动显示。
4、输入其余公司信息，如公司名，地址，电话之类。
5、使用一些样例数据测试你的发票。然后删除名为SalesInvoice的sheet中其余使用指南描述。
打完收工，50分交出来。
打开工作簿销售invoice.XLS和进口的数据qrySAClients到一个新的工作。给一个名称到新工作。这些数据将被用来当您创建发票。
Google翻译也不行啊
利用销售发票工作单，并创建公式来保存客户资料。当你进入客户的身份验证，客户的其他信息也同时显示出来
大致就是以上的意思。
Australian branch