Microsoft Access
|
48 results found, displaying items 1 - 20
|
Importing Access Reports into SQL Server Reporting Services
Learn how to convert your Access reports into SQL Server Reporting Services–supported RDL.
SQL Server Magazine
—
William Vaughn
|
[September 5, 2008]
|
 |
Data Manipulation with ADO
ActiveX Data Objects (ADO) let you access, filter, sort, and retrieve data from Microsoft SQL Server and Microsoft Access databases using VBScript and other scripting languages. Here are some of the most common uses of ADO for databases.
Windows IT Pro
—
Robert Sheldon
|
[June 6, 2008]
|
|
Accessing Database Data with ADO
Windows IT Pro
—
Robert Sheldon
Windows IT Pro Innovators Share Their Successes
This year's Windows IT Pro Innovators award winners find inventive solutions to problems ranging from automating Web-site creation to auditing access to applications to meet compliance mandates.
Windows IT Pro
—
Anne Grubb
, et al.
Script Inventories Remote Computers and Writes the Information to a Database
If you often need inventory information about the remote computers you manage, check out Computer_Inventory.vbs. With this script, all you need to do is create an input file, run the script, then query the database that the script creates.
Windows IT Pro
—
Readers
Express Essentials: Migrating to an Access Database Project
Migrating a multiuser Access database to an Access database project that uses SQL Server Express as the back end lets you handle more concurrent users and improve performance.
SQL Server Magazine
—
Michael Otey
Express Essentials: Connecting Access ADP Projects to SQL Server Express
Even better than using linked tables to connect Access to SQL Server Express is to use an Access database project, which lets you couple the easy-to-use Access form, query, and report builders to SQL Server's multiuser relational database engine.
SQL Server Magazine
—
Michael Otey
Express Essentials: Use SQL Server Express as a Back End to Access
You can use the Microsoft Access linked tables feature to create an ODBC link between Access and SQL Server Express tables. Here's how.
SQL Server Magazine
—
Michael Otey
Getting to Know Office 2007
Microsoft Office 2007 tips will help your users work with the system: using the Ribbon UI, finding macro options, converting the trial version of Office 2007 to the full release version, and more.
Windows IT Pro
—
Dan Holme
Where Do I Find It in Office 2007?
Office 2007's Ribbon UI looks cool, but does it let you easily find what you need? Here's how to find 10 commonly used features.
Windows IT Pro
—
Michael Otey
2006: A Great Year for Windows IT Innovation
This year's nine Windows IT Pro Innovators award winners reveal how they transformed familiar technologies into leading-edge solutions.
Windows IT Pro
—
Anne Grubb
Integrating SQL Server & Office 2003
All the major Microsoft Office 2003 applications include tools that let you incorporate and use data from a SQL Server database. These instructions for importing data into Word, Access, and Excel will get you started.
SQL Server Magazine
—
Michael Otey
Office 2007: First Look
Microsoft Office has had the same look and feel for at least a decade. See how Office 2007 promises--or threatens--to change how you use your favorite applications.
Windows IT Pro
—
Michael Otey
Outlook Tips & Techniques
Every month, Sue Mosher answers your questions about Outlook.
Windows IT Pro
—
Sue Mosher
Importing Contacts That Have Multiple Categories from Access
Making imported contacts appear properly under all their categories is as easy as using the correct delimiter in the database.
Windows IT Pro
—
Sue Mosher
SQL Express Update - Getting Started with SQL Server Express - January 23, 2006.
This issue, I’ll cover some of the groundwork you need to do to get started with SQL Server Express.
SQL Server Magazine
—
Michael Otey
, et al.
Tool Used with SQL Server 2005 Express
This issue, I’ll cover some of the groundwork you need to do to get started with SQL Server Express.
SQL Server Magazine
—
Michael Otey
SQL Server Express 2005 vs. JET
If you’re a Microsoft developer who’s deciding between database back ends for a small-scale Web or Windows application, chances are your decision boils down to Microsoft SQL Server 2005 Express Edition or Microsoft Office Access 2003.
SQL Server Magazine
—
Michael Otey
, et al.
Dynamic Reloading
Innovator Awards runner-up Mike Smith uses a dynamic stored procedure solution to give him the speed and flexibility to offer his end users more pre-built business intelligence results.
SQL Server Magazine
—
Mike Smith
Embedded Scripting in Stored Procedures
If you need to import data from a Microsoft Excel spreadsheet or .csv file into SQL Server, you might be frustrated because T-SQL doesn’t support the ability to access external objects--or does it? Learn how to work around this common problem.
SQL Server Magazine
—
William Barton
|
|
Register
