帮助尝试在Access 2013中创建数据库 [英] Help trying to create a database in Access 2013

问题描述

您好我正在尝试在Access 2013中创建一个数据库，以跟踪不同结算周期内每位用户的电话结算费用。我真的很新。所以我真的很感激任何帮助。


我有下表


部门

员工

制造商

电话详情

账单明细


部门有两个字段（Dept_ID和Dept_Name）


员工有两（2）个字段（Empl_ID和Empl_Name）


制造商有两（2）个字段（Mfr_ID和Mfr_Name）


电话详情有二十三（23）个字段

ID，描述，制造商，型号，序列号，SIM_Card_Type，SIM_Card_Num，IMEI_Num，Tele_Num，保修，Vaild_True，Assign_To ，部门，收购日期，成本，照片，Mobile_Plan，Mobile_Plan_Cost，CUG，CUG_Cost，允许的计划成本，信用额度，账户状态


账单明细有11个（11个）字段

（Billing_ID，Assigned_To，Tele_Num，Invoice_Num，Invoice_Date，Service_Period_Start_Date，Service_Period_End_Date，Current_Charge，VAT，Total_Ch arge，Under_Over_Stated_Cost


所以我创建了一个表格供用户输入电话详细信息的数据。我还为用户创建了一个用于输入实际发票中的信息账单明细数据的数据。


我现在需要创建一个报告，显示Billing_ID，Assigned_To，Tele_Num，Invoice_Num，Invoice_Date，Service_Period_Start_Date，Service_Period_End_Date，Current_Charge，VAT，Total_Charge，Allowed Plan Cost，Credit Limit和Under_Over_Stated_Cost


允许的计划成本和信用额度可以在电话详细信息表中找到，Under_Over_Stated_Cost等于Current_Charge减去允许的计划成本


有人可以请帮助。


谢谢


Lisa

Hi i am trying to create a database in Access 2013 to tracking telephone Billing Cost per user for different billing periods. I am really new to access. So I would really appreciate any help rendered.

I have the following tables

Departments
Employees
Manufacturer
Phone Details
Billing Details

Department has two Fields (Dept_ID and Dept_Name)

Employee has two (2) Fields (Empl_ID and Empl_Name)

Manufacturer has two (2) Fields (Mfr_ID and Mfr_Name)

Phone Details has twenty-three (23) Fields
ID, Description, Manufacturer, Model, Serial Number, SIM_Card_Type, SIM_Card_Num, IMEI_Num, Tele_Num, Warranty, Vaild_True, Assign_To, Department, Acquisition Date, Cost, Photograph, Mobile_Plan, Mobile_Plan_Cost, CUG, CUG_Cost, Allowed Plan Cost, Credit Limit, Account Status


Billing Details has eleven (11) Fields
(Billing_ID, Assigned_To, Tele_Num, Invoice_Num, Invoice_Date, Service_Period_Start_Date, Service_Period_End_Date, Current_Charge, VAT, Total_Charge, Under_Over_Stated_Cost


So i''ve created a form for user to enter data for the Phone Details. I have also created one for user to enter data for Billing Details for Information from the actual invoice.

I need to create a report now that will show Billing_ID, Assigned_To, Tele_Num, Invoice_Num, Invoice_Date, Service_Period_Start_Date, Service_Period_End_Date, Current_Charge, VAT, Total_Charge, Allowed Plan Cost, Credit Limit and Under_Over_Stated_Cost

Allowed Plan Cost and Credit Limit would be found in Phone Details Table and Under_Over_Stated_Cost is equal to Current_Charge minus Allowed Plan Cost

Can someone please help with this.

Thanks

Lisa

推荐答案

什么字段重叠电话详细信息和帐单明细表之间？为了创建一个从两个单独的表中提取相关信息的报告，您需要一些链接它们的东西。例如，如果数据库将包含多个客户的信息，则Billing_ID字段可能包含在两者中，因此您可以提取相应的记录。然后，创建一个查询，链接两个表并包含每个表的所有相关字段，您可以将其用作报表的来源。


如果我误解了您的问题，请告诉我如何使用这些表格，我可以提供更具体的解决方案。

What field overlaps between the Phone Details and Billing Details Tables? In order to create a report that pulls pertinent information from two separate tables, you need something that links them. For example, if the database will contain more than one customer''s information, the Billing_ID field might be included in both so you can pull the appropriate records. Then it would be simple to create a query, linking the two tables and including all the pertinent fields from each, that you could use as the source for your report.

If I misunderstood your problem, please let me know how the tables are being used and I can offer a more specific solution.

i'我不确定我理解......但是对于这两个表格，我认为分配到字段重叠。

i''m not sure i understand....but for both tables the ASSIGNED TO Field overlaps i think.

因此，ASSIGNED TO字段是您用来选择客户并运行的字段那个报告？如果是这样，我假设它包含一个唯一值（例如，该字段的同一个表中不会有两个SMITH），因此您可以使用电话详细信息和计费详细信息表创建查询并将其与分配到字段。选择此选项仅显示两个表中连接字段相等的行。


您现在可以使用Join Query（而不是表格）作为报告的来源。


再次，我是这里做了一些假设，因为并非所有信息都是清楚的，所以如果您的数据库设置与我描述的不同，请告诉我。

So, the ASSIGNED TO field is what you would use to select a customer and run the report? If so, I''m assuming it contains a unique value (e.g. there wouldn''t be two SMITHs in the same table for that field), so you can create a query using your Phone Details and Billing Details tables and join them with the ASSIGNED TO field. Select to show only the rows where the joined fields from both tables are equal.

You can now use that Join Query (instead of a table) as the source for your report.

Again, I''m making some assumptions here because not all the information is clear, so please let me know if your database is set up differently than I described.

这篇关于帮助尝试在Access 2013中创建数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！