Microsoft 数据库(Microsoft Database)或MDB 文件是与(MDB files)Microsoft Access一起出现的最古老的数据库系统之一。MDB文件被替换为类似的ACCDB文件。这些数据库文件可以使用Microsoft Access轻松打开、编辑和查询。但是您可能希望在旅途中对这些文件进行一些更改,因为您不需要在计算机上安装Microsoft Office 。但是,如果您没有它,那么一个名为MDB Viewer Plus的免费软件可以让您随时随地编辑和查看MDB和ACCDB文件的内容。
查看和编辑 Microsoft Access 数据库文件(Edit Microsoft Access Database Files)
MDB Viewer Plus不是Microsoft Access的替代品,但它可以帮助您完成一些任务。该工具是完全可移植的,不需要任何安装或设置。它使用内置于Windows中的(Windows)Microsoft 数据访问组件(Microsoft Data Access Components)来处理数据库文件。该工具使用起来快速且超级简单,可以完成您的工作。
MDB Viewer Plus还允许您从头开始创建数据库。因此,如果您正在寻找一些可以让您创建然后填充数据库的免费软件,那么MDB Viewer Plus是必须的。使用此工具非常简单,您可以轻松打开现有数据库文件并开始编辑它们。
表格管理功能可让您添加新表格、查看表格信息或删除现有表格。在“表格”选项卡中打开表格(Tables )后,您可以添加/修改/删除记录。您还可以修改现有表的表设计或架构。除此之外,在定义数据库时,您甚至可以添加主键并链接不同的表。此外,您甚至可以添加相关的子数据并形成数据之间的关系。
现在来查询您的数据,MDB Viewer Plus允许您从内置查询编辑器运行各种查询。您可以加载现有的SQL代码或在旅途中编写一些代码。然后您可以执行代码,甚至将其保存在单独的文件中。此外,您可以将查询的数据导出或打印为文本文件。此外,还有一个选项可以查看使用查询编辑器执行的SQL命令的历史记录。
查询编辑器(Query Editor)是一个不错的功能,但还有一些更有趣的东西。MDB Viewer Plus还允许您在数据库中搜索某些内容。如果您的数据库有很多记录,这是一个重要的功能。有两种类型的搜索可用,一种是表格搜索,另一种是单词搜索。表搜索允许您在一个表中搜索某个字段的某些值。单词搜索旨在搜索字符串字段中的多个单词。
MDB View Plus还为您提供了一些出色的导出(export)功能,可以帮助您将旧的数据库文件转换为如今更可接受的格式。您可以将数据导出为TXT、PDF、XLS、RTF、WKS、XML、HTML、DBF或CSV文件。这些是当今最常用的一些格式。
还有一个选项可用于将数据导入(import)MDB或ACCDB文件。导入向导支持多种格式,并允许您指定有关如何导入数据的详细信息。导入(Import)完美无缺,是一个非常有用的功能。
MDB Viewer Plus 免费下载
总体而言,如果您正在寻找Microsoft Access的快速替代品,可以让您随时随地编辑数据库文件, MDB Viewer Plus是一个很好的工具。(MDB Viewer Plus)它在功能和其他服务方面无法取代Access,但它肯定可以完成您的工作。单击此处(here)(here)下载 MDB Viewer Plus。
MDB Viewer Plus: View and Edit Microsoft Access Database Files
Microsoft Database or MDB files are one of the oldest database systems that came into existence with Microsoft Access. MDB files were replaced with similar ACCDB files. These database files can be easily opened, edited and queried using Microsoft Access. But you might want to make a few changes to these files on the go, for that you need not have Microsoft Office installed on your computer. But if you do not have it, then a freeware called MDB Viewer Plus lets you edit and view the contents of MDB and ACCDB files on the go.
View and Edit Microsoft Access Database Files
MDB Viewer Plus is not a replacement for Microsoft Access, but it can sort of help you get a few tasks done. The tool is completely portable and does not require any installation or setup. It uses Microsoft Data Access Components which are built into Windows to deal with database files. The tool is quick and super simple to use and can get your job done.
MDB Viewer Plus also lets you create a database from scratch. So, if you are looking for some freeware that lets you create and then populate the database, MDB Viewer Plus is a must then. Using this tool is quite easy, you can easily open existing database files and start editing them.
Table management features let you add new tables, view table info or delete existing ones. Once you have a table opened in the Tables tab, you can add/modify/delete the records. You can also modify the table design or schema for an existing table. Apart from that, while defining your database you can even add primary key and link different tables. Moreover, you can even add related child data and form relationships between the data.
Now coming to querying your data, MDB Viewer Plus lets you run all sorts of queries from the inbuilt query editor. You can load existing SQL code or write some on the go. Then you can execute the code and even save it in a separate file. Moreover, you can export or print the queried data as a text file. Also, there is an option to view the history of SQL commands executed using the query editor.
Query Editor is a nice feature to have, but there is something even more interesting. MDB Viewer Plus also lets you search for something in your database. This is an important feature if your database has quite a lot of records. There are two types of search available, one is the table search and the other is the word search. Table search lets you search for some value for a field in one table. And word search is meant for searching multiple words in a string field.
MDB View Plus also gives you some great export features that can help you convert your old database files to a more acceptable format these days. You can export your data as a TXT, PDF, XLS, RTF, WKS, XML, HTML, DBF or a CSV file. These are some of the most commonly used formats these days.
There is also an option available to import data to the MDB or ACCDB file. The import wizard supports a wide variety of formats and lets you specify details on how you would like to import data. Import works flawlessly well and is a very useful feature.
MDB Viewer Plus free download
Overall, MDB Viewer Plus is a great tool to have if you are looking a quick alternative to Microsoft Access that would let you edit your database files on the go. It cannot replace Access in terms of features and other services but it can surely get your job done. Click here to download MDB Viewer Plus.