Microsoft Software | Kerr Software

[ReviewAZON asin="B000HCVR12"]With its improved interface and interactive design capabilities that do not require extensive database knowledge, Microsoft Office Access 2007 helps you track and report information with ease. This all-in-one, out-of-the-box database solution helps workers track information quickly, create meaningful reports with ease, and share data more securely using the Web.

Office Access 2007 provides a library of prebuilt database solutions to get you started quickly. View larger.

Office Access 2007 has made it easier to filter data, bringing clarity to business questions. View larger.

Collect information from others by e-mail with InfoPath (or HTML) forms generated by Office Access 2007. View larger.

Moving your Office Access 2007 application to Windows SharePoint Services enables browser access to information. View larger.

Editing forms in interactive design mode is a true WYSIWIG experience. View larger.

Office Access 2007 provides a completely redesigned user interface and close integration with Outlook contacts. View larger.

Office Access 2007 has been updated with a fresh look so that you can easily create, modify, and work with database solutions. View larger.

Results-Oriented Interface
Access 2007 has been updated with a fresh look that makes it easier to create, modify, and work with tracking applications. The new results-oriented user interface (UI) is context-sensitive and optimized for efficiency and flexibility. The main window has a tabbed work area where all open objects reside, helping to keep the development area clean and tidy. Additionally, there are no windows hidden under other windows, so it's much easier to keep track of open documents and applications. To make things even simpler, from the nearly 1,000 available commands, the new UI displays only those relevant to the task you are performing at any given moment. And the new status bar, scroll bars, and title bar give applications built on Access 2007 a very modern look.

Pre-built Applications to Better Manage Information
Featuring pre-built applications that you can modify or adapt to suit changing business needs, Access 2007 gives you the option of collecting information through forms in e-mail or importing data from external applications. You can also create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make better sense of the data for informed decision-making.

Getting Started Screen
The new Getting Started screen includes a variety of pre-built database solutions that you can use right out of the box to track contacts, events, issues, assets, tasks, and more--or treat them like templates, and enhance and refine them to accommodate the kind of information you want to track or the way in which you want to track it. As other application templates become available from Microsoft Office Online, they will be advertised in the Getting Started screen so you'll always be up to date on new technology that can help your business run more smoothly.

Quickly Create Tables
Access 2007 features a new Navigation Pane which provides a comprehensive view of tables, forms, queries, and reports. You can even create custom groups to organize and see all the forms and reports related to a single table. In addition, Access 2007 makes it easier to work directly within a datasheet to create and customize tables. Enter information into a data cell--just as you would do in Microsoft Office Excel--and if it's a new value, Access 2007 automatically adds a new field and detects the data type (for example, date, number, or text). You can even paste Excel tables into a new datasheet, and Access 2007 will build all the fields and recognize the data types automatically. To help save you even more time, design and modify the form layout in real time on the screen, and preview your form as you build it. And for professional-looking results, Access 2007 provides rich text support for data stored in tables, so you can bold and italicize key data with ease.

Editing reports in Office Access 2007 offers easy grouping and editing with interactive design mode. View larger.

Filter and Sort Data
Access 2007 makes it easier to filter data, bringing clarity to business questions. Different filter options are available for text, numbers, and date data types. For example, new filtering options make it easy to filter a date column for all records in Today, Yesterday, Last Week, Next Month, Future, Past, and so on. For added convenience, the filtering experience is consistent between Excel 2007 and Access 2007 so that you don't need to learn a new way to find the information you need.

Work With Multi-Value Fields
Access 2007 supports complex data types, which means you can create columns that accept more than one value in a cell. For example, if you assign a task to more than one person, you can include both names in the cell. Windows SharePoint Services technology is compatible with these complex data types to help ensure data symmetry between the local and Web-based data stores.

Attach Documents and Files to Your Database
Your applications can hold information that is more interesting and helpful than ever before. You can attach multiple files--such as photos, documents, or spreadsheets--to individual records within the data store for easy reference. If the file isn't a compressed format, Access 2007 automatically compresses it for you, saving hard disk space. When it comes to consolidating information, Access 2007 lets you import contact records from Outlook 2007.

Interactive Form and Report Design
Access 2007 features an intuitive, user-friendly, what-you-see-is-what-you-get (WYSIWYG) forms design interface. This means you can design and modify the form layout in real time on the screen and preview your form as you build it. With the WYSIWYG design interface, you'll be able to build forms very quickly, spending more time doing the work and less time on design and formatting issues. You can also manipulate the report layout directly while browsing the data in the report designer, so you don't need to run the report to see how it looks on the page. This makes it easier to create great-looking reports in much less time.

More Accessible Reports
The new report browse mode makes reports more accessible. By using CTRL+F, you can find records, copy the data into other applications, and get to detailed records to edit the data. With the new filtering functionality, you can get clearer information on which to base decisions. To help keep things running smoothly, the improved Grouping Pane provides a clear display of data groupings so that you can preview changes as you are applying them to reports. You can easily add totals, subtotals, counts, and other elements that help you analyze the data. To help organize data, group the information in one or more layers and add subtotals.

Collecting and Sharing Information
Access 2007 simplifies the process of collecting information from others by building the data collection form automatically in InfoPath 2007 or HTML in the body of the e-mail message. You can then send that form to recipients, using e-mail addresses from your Outlook contacts or from Access itself. Outlook 2007 processes the incoming forms and saves the data in your Access 2007 data store, effectively updating the data in your tracking application immediately, without any need for retyping.

Web Collaboration With Windows SharePoint Services
By moving your Access 2007 files to a Windows SharePoint Services Web site, you can more readily share information, audit revision history, recover deleted information, set data access permissions, and back up your information at regular intervals. For instance, Web sites based on Windows SharePoint Services provide a place where your team can communicate, share documents, and work together on a project. With Access 2007, you can publish your Access files to libraries or move the application to Windows SharePoint Services, moving the data and front-end database to the server so that your team can interact with it easily through the browser. Forms and reports can then be viewed, updated, or deleted directly on the Windows SharePoint Services site according to the established permission settings.

Work Offline
Using Access 2007, you can work with Windows SharePoint Services offline. If you're traveling, for example, you can maintain a local copy of a SharePoint list on your portable computer, where you can edit and query the list as though it were any other Access table. Moreover, forms and reports that use the SharePoint list are fully interactive--and Office Access 2007 can later synchronize the local list with the online list when you bring your portable computer back online.

Integration with Windows SharePoint Services
Access 2007 authors can use business logic created with the workflow support in Windows SharePoint Services to build collaborative workgroup applications. Use this support to automatically assign tasks to other users, report on project status, and help ensure that tasks are completed on time. For added convenience, all Windows SharePoint Services tasks can be viewed inside Office Access 2007 or Outlook 2007, depending upon your work style. Windows SharePoint Services lists can even be accessed through mobile phones, so remote users can stay current on changing business information.

Manage and Audit Sensitive Information
To make this software even safer and more consistent with other 2007 Office system programs, Access 2007 includes improved as well as new security features. Unified trust decisions are integrated with Office Trust Center, and trusted locations mean databases in security-enhanced folders. Conversely, you can load an Access application with code or macros disabled to help provide a safe experience. Or you can track records and see who created, edited, and deleted them. Whichever option you choose, you can rest assured that your data is safe.[/ReviewAZON] Read more »

[ReviewAZON asin="B000HCZ8EY"]Office OneNote 2007 is a digital notebook that provides one place to gather notes and information, powerful search capabilities to find what you're looking for quickly, and easy-to-use shared notebooks to help manage information overload and work with others more effectively. As an integrated part of the 2007 Microsoft Office system, OneNote 2007 makes it easy to gather, organize, find, and share your notes and information more efficiently and effectively. Powerful search capabilities can help you locate information from text within pictures, or from spoken words in audio and video recordings. And easy-to-use collaborative tools help teams work together with all of this information in shared notebooks, whether online or offline. Plus, the familiar look and feel of the Microsoft Office system makes it easy to start using the program right away, minimizing wasted time and training costs.

Gather all of your information in Office OneNote 2007. View larger.

Gather and Organize Everything in One Place
With so much information coming your way--and in so many different forms--you need one place to keep it all and a tool that's flexible enough to capture it. Otherwise, information that could have been used to help make better decisions or make you more efficient is lost or difficult to find. Unlike paper-based systems, word processing programs, e-mail systems, or other productivity programs, OneNote 2007 delivers the flexibility to gather and organize text, pictures, digital handwriting, audio and video recordings, and more--all in one digital notebook on your computer. This software can help you become more productive by keeping the information you need at your fingertips and reducing time spent searching for information across e-mail messages, paper notebooks, file folders, and printouts.

Save Time By Consolidating Information
Taking notes on paper and transcribing them later can be time-consuming and difficult, and you run the risk of losing important pages. In addition, it's difficult to share data kept in a conventional paper notebook, and they're only good for capturing one kind of information: handwritten notes. When it's time to gather information from other sources and in different ways, other difficulties can arise. For instance, because most people don't have a way of digitally capturing unstructured information, they often print out Web research, and store information in file folders or on desks, which is difficult to find later and inaccessible when you're away. And sharing information with others can be challenging--even when using e-mail, it can be hard to hard to figure out what the plan is without reading through long e-mail threads that may or may not contain the information you need. OneNote 2007, however, gives you a solution with a flexible software program that enables you to gather virtually any type of information in one place. With your information readily available, you can be more prepared and informed.

Quickly Find What You Need
With OneNote 2007, finding information is easy and fast because it eliminates the guesswork of figuring out where you stored critical information. No more clicking through file folders and sorting through pages of paper notebooks to find the information you're looking for. Powerful search features give you the ability to locate information quickly, while allowing you to search across new types of content, like text in scanned documents or images, and spoken words in audio and video recordings. With easier access to the facts, you and your teammates can make better decisions.

With Office OneNote 2007, your team can work together more effectively. View larger.

Protect Your Intellectual Property
OneNote 2007 helps you consolidate various types of information--including freeform notes, images, documents, files from other Microsoft Office system programs, and rich media--and organize it in the way that works best for you. And because it keeps everything in one place, you don't have to worry about frequently saving or creating backups of your information--OneNote 2007 does this for you.

Ideal For Businesses
If you're attending an important meeting and don't want to rely on your memory, simply take meeting notes in OneNote 2007 to create a living repository of group decisions and brainstorming sessions that adds continuity and context to subsequent meetings. You can also catch all the details of customer calls and meetings by synchronizing typed or handwritten notes with Office OneNote 2007 audio and video recordings. If you're working outside of the office, gather information on your Microsoft Windows Mobile powered devices (including notes, audio recordings, and pictures) and transfer it to OneNote 2007.

And when it's time to share data with your colleagues, take advantage of OneNote 2007's export application programming interface to easily transfer information gathered in OneNote 2007 to your company's business systems, and in so doing reduce errors and wasted time spent rekeying the same information in different systems. Need to copy, paste, or print information from and into other 2007 Microsoft Office system programs? It's no problem with OneNote; this software lets you access and exchange information in Word, Excel, Outlook, and PowerPoint. You can even use OneNote 2007's drawing tools and tables to annotate and easily organize and manage information.

Find what you're looking for quickly using Office OneNote 2007. View larger.

Search and Link Options
OneNote 2007 lets you search and find keywords quickly within text, in images, and in audio recordings made within the application. You can also view hyperlinked search results in a summary task pane; a single click takes you to relevant results. For added convenience, view all open notebooks at once, use drag-and-drop functionality to easily arrange and rearrange your notes, and add hyperlinks to other pages in your notebook to quickly find relevant content. Manage tasks easily with two-way synchronization between OneNote 2007 and the 2003 and 2007 versions of Outlook, or link notes and other information to specific Outlook 2007 or Outlook 2003 contacts to help you better prepare for meetings and recall information easily. If you want to underscore a particularly important point, date, or other piece of information, mark notes with note tags, visually rich icons that make it easier to return to reminders, to-dos, and other action items.

Work Together More Effectively
With team members working from different locations and on multiple projects, communication, coordination, and information sharing can challenge group effectiveness and productivity. Teams often rely on e-mail messages to share information, causing confusion and bloated e-mail inboxes. Tasks, action items, agendas, and issues stored within static documents or document management systems are difficult to update, track, and access, and they prevent multiple people from working with the same information at the same time. OneNote 2007 helps people work together better by eliminating roadblocks that arise when information is isolated in paper notes or file folders, or on one person's computer. Groups can share information easily, work more productively, and keep track of projects, issues, and goals more effectively. Individuals can work together from the same notebook--whether online or offline--using shared notebooks. OneNote2007 manages changes made to the same notebook, eliminating the need to track versions or upload changes.

You can also create a team knowledge base so that everyone has access to the same information, helping to get new team members up to speed quickly, and minimizing duplicate efforts. Share notes even with non-OneNote 2007 users by sending your notes as HTML so that anyone with an e-mail client or Web browser can view them, and stay in control of your information by choosing which notebooks to share with your teammates and which to keep private, and help ensure privacy with password protection. You can even use OneNote 2007 as a shared digital whiteboard, enabling virtual teams to work together in real time, viewing and editing the same set of notes.[/ReviewAZON] Read more »

Microsoft Access 2007

Microsoft OneNote 2007