搜索表单以进行访问 [英] search form for access

问题描述

我正在创建一个包含各种员工培训的数据库。我按工作类型分类培训。我需要创建一个搜索表单，允许用户键入作业类别，然后显示与该作业类别相关的所有培训。

到目前为止我创建了作业类别表，其中特定的职称作为这些表中的项目。例如，我创建了一个名为"Management_jobcategory"的表。在该表格下，我有各种特定职位，属于
类别的管理层，如;主管，部门主管和副主管。 

另外，如果您认为有更好的方法来构建表格，请告诉我。 （我正在使用Access 2016）

解决方案

我正在创建一个包含各种员工培训的数据库。我按工作类型分类培训。我需要创建一个搜索表单，允许用户键入作业类别，然后显示与该作业类别相关的所有培训。

到目前为止，我已经创建了作业类别表将特定职位名称作为这些表格中的项目。例如，我创建了一个名为"Management_jobcategory"的表。在该表格下，我有各种特定职位，属于
类别的管理层，如;主管，部门主管和副主管。 

另外，如果您认为有更好的方法来构建表格，请告诉我。

I am creating a database that contains various employee trainings. I have the trainings categorized by job type. I need to make a search form that will allow a user to type in a job category and then show all of the trainings associated with that job category.

So far I have created job category tables with the specific job titles as items within those tables. For example I have created a table named "Management_jobcategory" and under that table I have the various specific job titles that fall under the category of Management such as; supervisor, division chief, and deputy administrator. 

Also, if you think there is a better way to structure the tables please let me know. ( I am using Access 2016)

解决方案

I am creating a database that contains various employee trainings. I have the trainings categorized by job type. I need to make a search form that will allow a user to type in a job category and then show all of the trainings associated with that job category.

So far I have created job category tables with the specific job titles as items within those tables. For example I have created a table named "Management_jobcategory" and under that table I have the various specific job titles that fall under the category of Management such as; supervisor, division chief, and deputy administrator. 

Also, if you think there is a better way to structure the tables please let me know.

这篇关于搜索表单以进行访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！