Access System Development - 1995~2022 - Major Production Achievements, Production results 100 examples

No.	System Name	Contents	Industry/Company Name (Honorifics omitted)	Introduction Year
	From 1995 to 2005
1	Production equipment Management	Database for managing breakdowns and repair costs of production equipment.	Honda Motor Co., Ltd.	1995
2	Athletes Management	Record management and physical condition management of track and field athletes.	Yutaka Giken Co., Ltd. Ekiden Race Club	1997
3	Printing barcodes	Printing barcodes using MS Access.	Wood product manufacturing	1997
4	Receipt and outbound management	Used Car receipt and outbound management.	Used Car Sales	1998
5	Sales Management	Timber selling, purchasing, and invoicing.	Timber sales	1999
6	Quotations and invoices database	Issuing quotations and invoices.	Wood product manufacturing	2000
7	Employee Biorhythm Management	Employee's Physical condition management by biorhythm.	Honda Motor Co., Ltd.	2002
8	Data aggregation database	Applicant aggregation and analysis.	Newspaper	2002
9	Construction cost control database	Cost control by property (gross margin and cost ratio).	Building demolition work	2002
10	Cost control database	Timber transfers, inventory management and cost control.	Timber sales	2003
11	Cost control	Cost control by property (gross margin and cost ratio)	Mold manufacturing	2003
12	Sales Management database	Selling, purchasing, invoicing and inventory management.	Machine tool sales	2003
13	Inventory management (English Version)	Parts Inventory management using barcode.	Honda Motor Co., Ltd.(Overseas)	2004
14	Production Control	Daily production planning instructions.	Wood product manufacturing	2004
15	Delivery management	Courier delivery management	Delivery	2005
	2006～2010
16	Mold cost control	Cost control by property (gross margin and cost ratio).	Mold manufacturing	2006
17	Inventory management (Chinese version)	Parts Inventory management using barcode.	Honda Motor Co., Ltd.(Overseas)	2006
18	Issuing quotations database	Multiplication rate management and quotations by customer.	Machine tool sales	2007
19	Sales Order Management database	Sales Order Management and cost control per Deal.	Mold manufacturing	2008
20	Sales Order Management database	Sales Order Management, goods receipt and outbound management.	Wholesale business	2008
21	Inventory management (Chinese version)	Remodeling of inventory management (business trip to China).	Honda Motor Co., Ltd.(China)	2009
22	Sales Management	Issuing packing slip and invoices.	Plating	2010
	2011～2015
23	Electronic quotation database	Digitization of quotation and drawing management.	Plating	2011
24	Issuing packing slip database	Improve the handwriting of packing slip.	Wood product manufacturing	2011
25	Sales Management and analysis	Sales analysis graphs by department.	Plating	2012
26	Inventory management	Receipts and issues and Inventory management. Database creation from Excel macros.	Parts processing industry	2012
27	Sake brand search database	Search and display Sake brands by brewery (touch panel method).	Tourism	2012
28	Sales and Inventory Management	Sales management, Deposit management and Inventory management.	Machine tool sales	2012
29	Sales order management	Sales order management per deal, Progress management.	Manufacturing industry	2013
30	Sales Management	Sales Management, Access version upgrade from Access97 to Access2013.	Online shopping	2013
31	Sales and Inventory Management	Sales and Inventory Management, Access version upgrade from Access2002 to Access2013.	Timber sales	2013
32	Issuing quotations database	Issuing quotations, Access version upgrade from Access2002 to Access2013.	Machine tool sales	2013
33	Receipts ,issues and Inventory Management	Remodeling of inventory management, Improve inventory database.	Manufacturing industry	2013
34	Printing barcode labels database	Access version upgrade from Access97 to Access2013.	Wood product manufacturing	2014
35	Sales, Inventory Management	Remodeling of set up sales tax rates.	Timber sales	2014
36	Customer Management	Changed to allow Customer's data sharing on the company LAN.	Marriage Information Services	2014
37	Sales, purchase Management	Remodeling of set up sales tax rates.	Plating	2014
38	Sales Management	Remodeling to a new invoice printing software.	Online shopping	2014
39	Accounting Data Processing	Create Excel macro VBA to output text from accounting software and convert data.	Foreign Capital Company	2015
40	Construction site management	Staffing and fleet management by construction site.	Construction work	2015
41	Inventory Management	Manage the inventory of construction materials and goods, take inventory, and calculate. Database from Excel.	Electrical work	2015
42	Create Quotation database	Database and manage quotation history.	Parts processing industry	2015
43	Issuing work orders	Coordinate monthly and daily production plans and issue.	Manufacturing industry	2015
	2016 ～ 2017
44	Sales Order Management database	Remodeling to search Orders history.	Manufacturing industry	2016
45	Sales Management	Remodeling to search Invoices history.	Online shopping	2016
46	Funeral Day management	Database for Funeral Day managing appointments and achievements.	Shrine	2016
47	Inventory management	Access version upgrade to Access2016.	Parts processing industry	2016
48	Accounting Data Processing	Create Excel macro VBA to output text from accounting software and convert data.	Foreign Capital Company	2016
49	Sales and quotation management	Access version upgrade to Access2016.	Plating	2016
50	Issuing quotations and Inventory management	Quotations and actual management then we can cost accounting.	Construction work	2017
51	Sales Management	Modifying the Invoicing Process.	Online shopping	2017
52	Warehouse Management, Issue an invoice	Access version upgrade from Access2003 to Access2016, and improved processing speed.	Warehousing	2017
53	Daily Report Management,Issuing invoices database	Enter daily reports and create invoices, receiving and issuing leased goods.	Construction,Leasing business	2017
54	Progress management of sales orders	A system where 30~40 people share information from inquiries to orders.	NTK Ceramics Co., Ltd.	2017
55	Membership Management of Elderly Life Support	Manage thousands of members in this system that works with Access and FileMaker Server. When employees go out, you can search for member data using iPad.	Elderly Life Support	2017
	2018 ～ 2019
56	Facility Information Management	Approximately 10,000 units of equipment information and manage load electrical capacity.	Jatco Plant Tech Co., Ltd.	2018
57	Construction Business Total Management	Total Management database. We prepare quotations, register construction ledgers, and manage employees and subcontractors.	Construction work	2018
58	Customer Management database	We will register the customer's visit record and test results.	Treatment clinic	2018
59	Issuing quotations and invoices	Remodeling of invoices, Added the ability to transfer from quotes to invoices.	Construction work	2018
60	Accounting Data Processing Program	Data conversion program made for Windows10.	Foreign Capital Company	2018
61	Debt Collection database	Can be shared by 10 PCs, and the database is divided to implement measures to speed up.	Judicial Scrivener Office	2018
62	Production Control database	CSV data import function, Create production orders, Inventory management and daily report management.	Manufacturing industry	2018
63	Sales Management database	Access version upgrade from Access2003 to Access2016, and improved processing speed. Changed the macro to VBA to speed up.	Machine tool sales	2019
64	Membership management and aggregation of test results	Access version upgrade from Access2000 to Access2016, Summarize test results and print graphed forms.	Cram School	2019
65	Sales Management database	Annual updates and program remodeling, Changing from Japanese calendar to Western calendar display.	Online shopping	2019
66	Stock Price Calculator Forecast Program	Import CSV data for stock prices, and calculate then output data to Excel.	Stock Trading	2019
67	Membership management system	Issue an monthly invoice and export CSV data for a bank.	Elderly Life Support	2019
68	Issuing invoices	Remodeling of invoices, consumption tax rate from 8% to 10%.	Parts processing industry	2019
69	Production management and core systems for manufacturing industries	Access version upgrade from Access2003 to Access2019. Database uses SQL Server.	Specialty tool manufacturing	2019
70	Preparation of quotations for the manufacturing industry	Remodeling of quotations, add a quote item.	Parts processing industry	2019
71	Member Management database	Access version upgrade from Access2003 to Access2016. Version up to 180 Access files.	Benefit society	2019
72	Warehousing Management database	Access2016 "Inconsistent database.", Fix a fundamental Access glitch that has become a global problem.	Warehousing	2019
73	Membership management database	Remodeling of Modify Database, from Access2019 to FileMaker Pro.	Elderly Life Support	2019
74	Sales Management Document Issuance	Changing Printed Forms and remodeling.	Wholesale business	2019
75	Business Management database	A system for managing the overall operations of new businesses in the manufacturing industry.	Parts processing industry	2019
	2020 ～ 2021
76	Membership management database	Updated to data for the new fiscal year.	Cram School	2020
77	Sales Management database	Access version upgrade from Access2010 to Access2019.	Furniture sales	2020
78	Sales Management database	Access version upgrade from old version Access to Access2019.	Eel Wholesale business	2020
79	Issuing invoices database	Added invoicing function. New system installed on 5 PCs.	Elderly Life Support	2020
80	Management for Chemical Substance Lists	List management of chemical substances used in the manufacturing process.	Parts processing industry	2020
81	Issuing quotations database	Add a export CSV data of quotations.	Parts processing industry	2020
82	Management for Transportation industry linked to core systems	Access version upgrade from old MDB file type Access to Access2019 new ACCDB file type.	Transportation	2020
83	Inventory Management	Added new features and installed them on 3 PCs.	Electrical work	2020
84	Submit sales inputs and invoices	Remodeled to support multiple tax rates and installed them on 5 PCs.	Fresh fish Wholesale business	2020
85	Membership management database	Updated to data for the new fiscal year and installed them on 10 PCs.	Cram School	2021
86	Member Management database	We standardized the data structures of the Access files and installed them on 10 PCs.	Benefit society	2021
87	Circular software for Retrial of Product Defects	The number of people using the system is 100 people, and we have created a system that operates across three prefectures (Aichi, Gifu, and Nagano).	NTK Ceramics Co., Ltd.	2021
88	Sales Management	Added new features and installed them on 3 PCs.	Online shopping	2021
89	Issuing quotations	Added new features to quotations and installed them on 12 PCs.	Construction work	2021
90	Automatic creation of shipping confirmation table system	Access automates the manual process of creating a shipping confirmation table in Excel, and installed them on 4 PCs.	Japanese confectionery shop	2021
91	Stock Price Calculator Forecast Program	Import CSV data for stock prices, and calculate then output data to Excel.	Stock Trading	2021
92	Business Management database	Modified the quotation issuance database.	Parts processing industry	2022
93	Market Quality Information Management	Newly developed Market Quality Information Management database. Installed 40 PCs from Shizuoka Prefecture, Saitama Prefecture, and service bases nationwide.	Honda R&D Laboratories Co., Ltd.	2021
94	Circular software for Retrial of Product Defects	Added new features and installed them on 200 PCs.	NTK Ceramics Co., Ltd.	2021
95	Submit sales inputs and invoices	Remodeled to CSV output of sales data and installed them on 5 PCs.	Fresh fish Wholesale business	2021
	2022 ～ 2023
96	Membership management database	Updated to data for the new fiscal year and installed them on 10 PCs.	Cram School	2022
97	Production Control database	Newly developed Industrial Machinery Manufacturing database. Installed 25 PCs and Manage almost every works.	Industrial Machinery Manufacturing	2022
98	Member Management database	Added new features and standardized the data structures and installed them on 10 PCs.	Benefit society	2022
99	Management System for automatic creation of work schedules	Newly developed Automaticaly creation of work schedules. Installed 10 PCs across three prefectures (Aichi, Gifu, and Nagano).	NTK Ceramics Co., Ltd.	2022
100	Market Quality Information Management	Modified theMarket Quality Information Management database and added a search function. I installed 40 PCs of marine service nationwide.	Honda R&D Laboratories Co., Ltd.	2022
101	Condition change action database	Newly developed Condition change action database. Installed 100 PCs three prefectures (Aichi, Gifu, and Nagano).	NTK Ceramics Co., Ltd.	2022
102	Circular software for Retrial of Product Defects	Added graph display function. You can freely change the aggregation period of the graph and perform dynamic graph analysis.	NTK Ceramics Co., Ltd.	2022
103	Business Management database	Added the order confirmation output function of the Business Management database.	Parts processing industry	2022
104	Production Control database	Added the function to input daily work report of the Production Control database.	Industrial Machinery Manufacturing	2022
105	Production Control database	Added the function of Excel output for billing details.	Mold Manufacturing	2022
106	Inventory management database for jigs and tools	Newly developed Inventory management database for jigs and tools. We changed from existing Excel to Access to centralize data management.	NTK Ceramics Co., Ltd.	2022
107	Member Management database	We Combined distributed programs into an integrated database and installed them on 20 PCs.	Benefit society	2022
108	Issuing quotations, Business Management database	As a countermeasure against data corruption due to an increase in business volume, we have modified it to process non-consolidated data.	Construction work	2022
109	Stock Price Calculator Forecast Program	Import CSV data for stock prices, and calculate then output data to Excel. We performed remote work via the web from the specification meeting to the delivery.	Stock Trading	2022
110	Customer data Management database	We updated the data of the Customer data Management database.	Online shopping	2022
111	Warehousing Management and Invoicing database	Added tax rate and company registration number for eligible invoices.	Warehousing	2022
	Company Name (Honorifics omitted)

Leave it to us!

Call us

Inquiry