Tag Archives: Access 2010

AccdbMerge: Compare MS Access Databases, Find Differences & Merge Objects

by on
1
Comparing multiple objects from two separate MS Access databases is not only difficult, but also quite a tedious task, as one needs to first check each data set in databases, and then make required changes to DB objects. If you’re working with multiple versions of Access database, you may be looking for a tool that can help you identify the differences between all major objects of database, including tables, forms, reports, queries and so on. Instead of tallying each dataset and DB objects, you could use AccdbMerge to instantly view the differences, and import & export selected objects from both database versions to easily merge the required sections. AccdbMerge supports both widely used Access database formats, including MDB and ACCDB, allowing you to read all the elements of database without having to install any additional tools. Read More

DataCleaner Is All-in-One Data Analysis And Database Cleaning Software

by on
1
Database analysis tools help DBAs in identifying the discrepancies and illogical connections between data sets, so that they can be removed from the database. However, the capability of database analysis tools depend upon the platform on which database is built. For instance, small-scale relational database created on MS Access needs a whole lot of different DB analysis utility than one created using MySQL. If you’re looking for an all-in-one database analysis tool that can help you identify and clean redundant entries from the database, odds of you coming across a paid utility are high. Today, we discovered an open source, java-based utility called DataCleaner that implements a variety of database analysis and cleaning concepts including Data Quality, Master Data Management, Data Profiling, and Data Quality Monitoring, to remove all superfluous data sets off the specified data store. The application supports a wide range of database platforms and data files including CSV, MS Excel (XLS and XLSX), MS Access, SAS library, DBase database, Fixed Width File, XML, OpenOffice Database, MonoDB, MySQL, Oracle and MS SQL Server. Read More

Transfer MS Access Database To MySQL In 4 Simple Steps

by on
2
Looking for an application that can help you easily migrate your MS Access database to MySQL without having to follow any tedious procedure? Transferring databases from one system to another is always a headache regardless of how big or small the database is. Therefore, database managers and administrators look out for a simple tool that can perform an export and import operations with all the variations involved. If you’re planning to migrate data from Access to MySql, you’d probably have a lot methods in mind to port databases. Before implementing any of them, try MS Access to MySQL. It is an ingeniously simple utility for Windows that is designed to quickly port Access database to user-defined MySql database. It supports a wide range of database formats, including, MDB, MDE, ACCDB, and ACCDE database formats, and also shows you the MySql database hierarchy to choose the destination database path. Furthermore, password protected (encrypted) databases can also be exported on the fly without having to decrypt them. The application supports two transfer modes – Direct transfer and Dump file creation. In direct transfer mode, you need to enter the host address, port, DB username and password along with the DB name where data has to be directly ported, whereas the Dump file creation method lets you choose a local location to create SQL dump file for importing it later. Read More

Access 2010: Export Database Table To Excel 2010

by on
3
Carrying out different operations in Access is not that easy, as RDBMS (Relational Database Management System) requires specific syntax & constraints to be followed. Thus, exporting an Access database table to Excel spreadsheet undoubtedly opens more options for performing different operations over data. Access 2010 lets user export database table promptly to Excel spreadsheet for analyzing database with feature & functionality that Excel contains. Read More

Wildcards Entries In Access 2010

by on
Leave a comment
WHERE is the most used command in SQL, providing easiest way to pull out specific data from table. Even though you can use SQL commands in Access 2010, but CLI (Command Line Interface) brings monotony along and database novices usually get their hands on a tool which offers simple GUI layout. So the best alternative around in Access is to use wildcard entries, aka, Like/Unlike conditions, which offers innumerable ways of pulling out desired info from tables, queries, etc. Read More

Create Hyperlink Field In Access 2010

by on
6
Sometimes there is frantic need to create links in database table to web pages, files, folders, images, etc. Access 2010 provides a convenient way to link up data field values with anything to complement the database in much better way. In this post we will guide you on creating a table field having Hyperlink data type. Read More

Using Expression Builder In Access 2010

by on
1
Applying different conditions over data fields comes in very useful when you need to evaluate data field values based on other fields. Expression Builder in Access 2010 provides you just that with full support of applying functions and formulas. It can be used anywhere in Access 2010 with any database element like; Forms, Reports, Queries and Tables. In this post we will be using expression builder in query for evaluating new data field values. Read More

Setting Query Criteria In Access 2010 Through Logical Operators

by on
Leave a comment
As the name implies, Query pulls out specific data from table fields included in database, thus, setting specific criterion in query helps you to filter down the table field data according to your needs. Through simple logical operators in Query Criteria you can set a criteria by using simple AND/OR operators, which lets you to confine the results of a query based upon the query criteria to check which table field data is to be included. Read More

Assign Password Data Type To A Specific Field In Access 2010

by on
3
Applying different types of constraints over data fields in Access 2010 comes in handy, especially when you need to restrict database users in specified range. Applying Data types over fields plays vital role in manipulating data in a desired way, but way of assigning data type as password is bit different as you need to add input mask for it. In this post we will show how to assign password data type to a specific field. Read More

Create Calculated Fields In Access 2010

by on
5
In Access 2010, you can manipulate data fields in many ways by applying constraints, changing data types, creating relationships and so on, but creating Calculated fields would be of great use, as you can easily calculate field values based on other field’s data in real time. In this post we will guide you through the procedure of creating a Calculated field, which will take values from other fields to evaluate result. Read More

Make Database Application Form In Access 2010

by on
4
Creating a database in Access 2010 is rather easy than other RDBMS tools available out there. Apart from providing tools, features and function for creating and managing databases efficiently, it also allow users to create a database application, so you can give it to your client or any other concerned party. Adding more, you can customize the overall look of application while creating one by confining client to use only specific part of database. Read More

Access 2010: Windows Installer Package Solution Wizard

by on
13
After creating an application in Access 2010, you may need to bundle the relevant databases into a package. Access 2010 has a intrinsic feature which lets user bundle and deploy Access 2010 database applications. This feature allows you to wraps up Access application into setup package, i.e, MSI installer in which you can associate Macro or VB code with the main database file and add other information such as; registry info, bitmap files, data version, Add or Remove Programs information and EULA info. Read More

Convert Password Protected Access MDB File To CSV Format

by on
2
Export Microsoft Access MDB to CSV is a freeware app utility which allows database users to instantly convert MDB database file in CSV (Comma Separated Value) file. As database tool are not abound, using this app would be extremely useful to export database tables into CSV format which is widely used and can be viewed with a simple text editor. Apart from mere exporting MDB file, it also lets user convert 'password protected' MDB file in CSV, CSV separated with tab, and CSV text qualifier format along with revealing the password. Read More

Export/Import Ribbon & Quick Access Toolbar Settings [Office 2010]

by on
2
Microsoft Office suite apps provides an easiest way to customize Ribbon, Tabs and Quick Access toolbar but what if you need to install a fresh copy of Office or use these customizations on other system? Office 2010 allows you to export/import customizations. In this post we will walk you through the procedure of exporting/importing ribbon and Quick Access toolbar customizations. Read More

View, Insert & Modify Data Table Without Using MS Access

by on
Leave a comment
Usage of databases are extensive but for viewing, editing, and modifying databases you need to have an compatible software, Microsoft Access being the most popular. MDB Viewer Plus is a portable freeware software, which lets you to open and modify two very commonly used database formats MDB and ACCDB. Apart from mere a viewer, it enables you to insert and modify records, filter down table record, sorting table data in different orders and importantly allows you to execute SQL commands. Adding more, it also provides you with an option of exporting and importing databases, which could be very handy for viewing database stored in different files like; Excel, Word, Text, Lotus, Quattro Pro etc. Read More