Introduction to Access 2007: We ALL Need it

Access 2007: Get Up to Speed

As the Office 2007 GUI is radically different from previuos versions, even advanced uswers and developer will benefit from this free intoduction.

This course includes:

• Three self-paced lessons and three practice sessions for hands-on experience. Practices require Access 2007.
• A short test at the end of each lesson; tests are not scored.
• A Quick Reference Card you can take away from the course.

After completing this on-line course you will be able to:

• Download a database from the new Getting Started page.
• Create database objects by using the new Ribbon.
• Save and share your data in appropriate formats.

Latest SQL Server Hotfixes from Microsoft

FIX: An access violation may occur in SQL Server 2000 Analysis Services when you try to use a 2007 Office system program to open an offline local cube

FIX: High CPU utilisation by SQL Server 2005 may occur when you use NUMA architecture on a computer that has an x64-based version of SQL Server 2005 installed

Restoring a SQL Server Database to a New Server

Restore a SQL Server database to a new server If you have to move databases to a new server, you have two options for carrying out this task: SQL Server Management Studio (GUI) or T-SQL (Command line). This download from TechRepublic.com shows you both methods.

Download Office 2007 Sample:
Using the Business Data Catalog and Smart Tags with the 2007 Office System

2007 Office Sample: Using the Business Data Catalog and Smart Tags with the 2007 Office System This code sample accompanies the MSDN article, Using the Business Data Catalog and Smart Tags with the 2007 Office System, available from the Related Resources section of this download page.

Goodbye to Office 2003
Microsoft has announced that after June 30, 2007, OEM Office 2003 will no longer be available from Microsoft. Some authorized OEM distributors may have some remaining inventory left for a short time after June 30th; however,Microsoft will no longer be shipping OEM Office 2003 to them. More

Ten New Office 2007 Interface Elements: All About that Button Thing...

The radical new Office 2007 interface includes a number of new elements. To make it easier to talk about all these features as you help users get up to speed Jody Golbert TechRepublic.com blogger has a look at 10 major Office 2007 interface elements and their official names.

Iterate Through Databases and Tables in SQL Server

Iterating through tables and databases in SQL Server This tip from TechRepublic.com presents two very handy stored procedures that live in the master database but are not mentioned in SQL Server Books Online.

Solution Accelerator for Office 2007 Business Desktop Deployment

Solution Accelerator for Business Desktop Deployment Download planning, building, and technical guidance, templates, and scripts to facilitate deployment of Windows Vista and Office 2007

Version: 1.1
Published by Microsoft on: June 7, 2007
Download Size: 27.7 MB - 55.4 MB

The Solution Accelerator for Business Desktop Deployment (BDD) is best-practice guidance for desktop deployment, targeted at companies that want to reduce deployment time, effort, and cost by increasing the level of automation. BDD allows administrators to deploy desktops with Zero Touch and Lite Touch interaction at the target PCs, and also helps organizations move to a managed environment with standardized desktop images.

BDD 2007 is offered in two versions to support Solution Accelerator component installation on x64 or x86 hosts. You select the version that corresponds with your host hardware type: both versions support x86 and x64 client operating systems.

Hotfix Rollup for Office 2007

Hotfix Rollup for the 2007 Microsoft Office System (KB935520) Microsoft has released an update for the spelling checker in the 2007 Microsoft Office programs. This release is an update to the English-language dictionary.

Create Custom Off-Line MSDN Content with PackageThis!

Take Parts of the MSDN Library Offline with PackageThis!

Created by the MSDN development team, PackageThis! allows you to choose documentation sets from the MSDN Library to save as HXS or CHM format files. You simply select nodes in the MSDN Library tree view to package as your own local mini-library, or to build into your own library. Multiple languages are supported. Cool!

Latest SQL Server Fixes

FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005.

FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000.

Get the Latest SQL Server 2005 Documentation

SQL Server 2005 Books Online (May 2007) Download an updated version of the documentation and tutorials for Microsoft SQL Server 2005.

Product Focus: SmartForm ADP

When you work with Access Data Projects (ADPs), the native Access form wizard - even in Access 2007 - is very basic:

With my SmartFormADP Form Wizard, you can easily build a smart elegant auto-filter form based on any SQL Server table or view in a matter of seconds using only mouse-clicks:

SmarfFormADP for ADPs/ACCDPs comes bundled with SmartForm+ for MDBs/ACCDBs and is available for immediate download for only US$29.95.

New Office 2007 Downloads

2007 Office System: Microsoft SDK for Open XML Formats Technology Preview This download provides strongly typed part classes for use with Open XML documents.

Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists This add-in works with Excel 2007 to allow you to synchronize data in a table with a list on a SharePoint site.

VBScript Quick Reference

Download a quick reference guide to commonly-used VBScript commands.

Using Advanced Table Hints in SQL Server

This article from TechRepublic.com explores the benefits and side effects of using three types of table hints when running queries in SQL Server: READCOMMITTED, REPEATABLEREAD, and SERIALIZABLE. The previous article in this series covered NOLOCK and READPAST.

Other SQL Server articles from Tech Republic:

• Experiencing the power of SQL templates
• Building a data values dictionary with SQL
• Using recursion in stored procedures
• Develop more quickly by re-using databases
• Recovering from hardware upgrade problems with SQL
• Create a histograph in SQL Server

Focus on Access 2007 for Access Junkies

Access Junkie, Jeff Conrad, Access MVP Alumni and a Microsoft Software Engineer on the Excel - Access Services Team, has established a very useful site devoted to Access 2007 and its new features and technologies. There is a broad range of resources and links available. The best Access 2007 site I have visited.

Jeff has also co-authored Microsoft Office Access 2007 Inside Out (MS Press)

Microsoft Office Access 2007 Developer Reference Portal

The Microsoft Office Access 2007 Developer Reference Portal provides conceptual overviews, programming tasks, samples, and references to guide you in developing Access solutions.

The reference has the following sections:

• What's New New members by object and in alphabetical order.
• How Do I... in Access 2007 A map of how-to topics of custom Access solutions.
• Concepts Important concepts for developing custom Access solutions.
• Access Object Model Reference
  
• Access Macro Actions Documentation for all of theAccess macro actions .
• Microsoft Data Access Objects (DAO) Reference
  
• Microsoft ActiveX Data Objects (ADO)
  
• Microsoft Jet Replication Objects (JRO)
  
• Microsoft Access SQL Reference
  
• Microsoft Access Database Engine Error Reference
  
  

How To Use VBA Variables

Download a free sample chapter from VBA for the 2007 Microsoft Office System (Que) exploring variables and how to use them in your VBA procedures.

Chapter topics include:

• Declaring variables
• Avoiding variable errors
• Understanding variable data types
• Using array variables
• Working with constants
• Storing user input in a variable

Courtesy of TechRepublic.com.

Latest SQL Server Updates

How to run a SQL Server 2005 Integration Services package as a SQL Server Agent Job

FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005

FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053