创建前端和后端数据库 [英] Creating Front end and Back end database

问题描述

你好！

我刚加入我的新工作，公司沉迷于Excel虽然Access在几种情况下都很有效。我有15个人向我汇报。他们将自己的日常活动记录在Excel表格中并邮寄给我。这些电子邮件会垃圾邮件收件箱。我正在实施Access并需要像您这样的专家的帮助。我想为每个人创建一个表格，即15个表格。个人应该只能访问他/她的形式（如果他/她只能看到他们的形式而不是锁定其他形式会更好）。在前端，我希望用户只查看他们的相关表单，而不是表格和报告。谁可以在这方面帮助我？如果您无法理解我的情况，请告诉我。为语法道歉。


提前谢谢！

Hello there!
I just joined my new job and the company is addicted to Excel though Access is efficient in few situations. I have 15 people reporting to me. They record their daily activity in an Excel sheet and mail it to me. These emails would spam my inbox. I am implementing Access and needs assistance from experts like you. I want to create a form for each individual i.e, 15 forms. An individual should have access only to his/her form (it would be better if he/she can see only their form rather than locking the other forms). In the front end I want the users to view only their related form and not the tables and reports. Can anyone help me in this regard? Please let me know if you were not able to understand my situation. Apologies for grammar.

Thank you in advance!

推荐答案

你是说每15个用户有不同的表格界面？他们实际上是否在最后存储相同的信息？


要分割前端和后端，您可以先创建所需的所有表格和查询以及表格。在测试数据库以确认其完成后，您可以在Access 2007中拆分数据库，其数据库工具 - >移动数据 - > Access数据库（一个黄色数据库，2个箭头指向2个较小的黄色数据库）

So are you saying each 15 users have different interface of the form? Do they actually store the same information at the end?

For splitting the front and back ends, you can first create all the tables and queries and forms you need. After testing the database to confirm its done, you can go to split the database, in Access 2007 its Database tools-->Move data--> Access database(a yellow database with 2 arrows pointing to 2 smaller yellow databases)

我无法看到这是关于FE / BE数据库的。在我看来，你有设计考虑因素和安全考虑因素。 15个独立设计的形式的想法似乎是一个非凡的概念，如果那就是你在想的话，不会给你任何安全帮助。


我建议坐下来首先，并密切关注与该项目有关的预期结构和安全问题。不要指望一份5分钟的工作。


当你更清楚地了解自己的目标时，我相信我们可以提供帮助，但我怀疑你的问题不会太过于考虑，甚至没有多大意义。

I fail to see how this is about FE/BE databases. It appears to me that you have design considerations as well as security ones. The idea of 15 separately designed forms seems an extraordinary concept, and won''t give you any help with security if that''s what you were thinking.

I would suggest sitting down first and giving close consideration to the expected structure and security issues that will necessarily be associated with this project. Don''t expect a 5-minute job.

I''m sure we can help when you have a clearer idea what you are after, but I suspect without that your questions will be too ill-considered even to make much sense.

感谢您的建议。实际上我必须创建FE&也是BE数据库，但我想先用表格清除。十五名员工以Excel的形式向我报告他们的日常活动。我用它来评估他们的表现和公司的生产力。这不是主要责任，所以我在一周内更新一次Excel主表。这将是垃圾邮件或我的收件箱将被填满。将数字从单个工作表复制到主工作簿也很费时间。我的一位朋友建议通过向每位员工分发个人表格来实施Access，这将使整个系统自动化。


正如我之前所说，我想为每位员工创建一份表格，即，15种形式。他们应该只能访问他们的表单。如果可能，我希望数据库的前端只有表单和所有相关的表，后端报告。


如果这些信息充足，请告诉我。

thanks for the advice. Actually I have to create FE & BE database too but I wanted to clear with the forms first. Fifteen employees report to me about their daily activity in the form a Excel. I use it to evaluate their performance and company productivity. This is not a major responsibility so I update the master Excel sheet once in a week. This would spam or my inbox would be full by then. And also it is time consuming to copy the numbers from individual sheet to master workbook. A friend of mine suggested to implement Access by distributing individual form to each employee and it would automate the whole system.

Well as I said earlier I want to create a form for each employee i.e, 15 forms. They should be able to access just their form. If it is possible I want the front end to database to have only forms and all the related tables, reports in the back end.

Please let me know if this information is sufficient.

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