Microsoft Access 2007 is a database software that lets you record information in a more understandable and transparent fashion.
Microsoft Access 2007 comes with new, improved user interface and has a low learning curve for novice database developers. No SQL knowledge is required and all operations are handled on a click-and-set basis.
With Microsoft Access 2007 you can create sophisticated structures of data, record vast amounts of information, generate reports and share that information over the Web.
The main window is structured around tabs, and all windows appear one next to another, without hiding themselves. MS Access operates almost 1,000 commands that are suggested to you while you work on any specific task. All looks lean and tidy, giving you the impression you've got the full overview of your current work.
You can collect information from e-mail forms on your website or import data from third party software directly into your Access database.
Data structure templates are included too allowing you to kick start your contact management, organize events and issues, track inventory and other tasks.
Creating custom tables is also quick and easy: you just enter data into a cell and MS Access 2007 automatically adds it into the database either by replacing an old value or adding a new row. Access will also recognize the data type automatically for you. Rich-text data type is supported allowing to change text properties to highlight important cells.
The new navigation pane gives you an overview over your databases, tables, database queries and other useful information.
MS Access 2007 contains a variety of filters allowing you to flexibly represent your data the way you want. Filter your results after creation date, date of the week, month or by data type.
Microsoft Access 2007 can create data columns where there are multiple values in a single cell. These complex data types are recognized by other Microsoft database-driven solutions including MS Share Point, and can be easily ported to them.
Just like SQL's bulb data type, Access 2007 supports adding files in a compressed for to your database. Just attach spreadsheets, photos, videos and other stuff you might have to your cells.
Browse reports and copy data for use in other software. Group data in meaningful reports and customize data representation to gain more insight. The reports you generate may be emailed or exported to HTML or InfoPath 2007 format.
When running Microsoft Access 2007 combined with the Windows SharePoint Services Web service you can add more collaboration options to your work. Share work across team members, assign them with tasks, review data entered or track revisions. Permissions to specific databases and / or tables can be granted to or revoked for specific users or groups of users. Integrating your Access database with SharePoint gives you the ability to manipulate it through a Web interface.
When not connected to the Internet, e.g. during business travel, you can work on your SharePoint-enabled Access database in an off-line mode. Data syncing is performed when you're back online.
Microsoft Access 2007 includes some security enhancements also found in other MS Office 2007 applications. For example, your database files are stored in a secure folder or turn macros off whilst loading files from unknown sources. Additionally, all changes made to your databases are logged so that you may review any changes at any time.