TechRepublic : A ZDNet Tech Community

10000 Resources for

"Microsoft Access"

  • Subscribe to this listing via:
  • RSS
  • Email
Should you use SQL Server Express Edition or Microsoft Access for your small business applications?
This article is also available as a PDF download.When you're weighing you options in database applications,it helps to make a feature-by-feature comparison. This overview will look atthe feature sets of the Express edition of SQL Server 2005 and Microsoft Access.I did my best to avoid including too many details for...
Tags: Microsoft Access, Microsoft Corp., Microsoft SQL Server, small business, SQL Server Express, SQL Server Express Edition, Tim Chapman, tool
Technical articles 2006-12-05
Developing a simple database client solution using Microsoft Access
An organization that used multiple Excel sheets to capture the company's human resources data found a more efficient solution in Microsoft Access. Here's what one consultant built and how it saved time and work for the client.I was brought in by a client to develop a solution that would capture...
Tags: PRODUCTIVITY, Microsoft Office, Databases, Social Security, Evan Stein, spreadsheet, Microsoft Access, Microsoft Corp.
Technical articles 2002-12-23
10 tips for using wildcard characters in Microsoft Access criteria expressions
This article is also available as a PDF download.A wildcard is a special character that can represent one ormore characters in a text value. You can use wildcards to find many recordswith similar, but not exactly the same, information. You can also use them to lookfor a specific record when...
Tags: Microsoft Access, Microsoft Corp., Susan Harkins, wildcard
Technical articles 2007-01-30
Microsoft Access could be the missing piece in your database solution
Despite IT's general opposition to it, Access can be an excellent alternative to the larger database systems. Read up on some of the facts about Access, and find out why it may be the perfect choice for your database needs.By Susan Sales Harkins and Martin W. P. ReidRecently, a colleague...
Tags: Microsoft Office, Databases, Microsoft Corp., Susan Harkins, Microsoft Access, database
Technical articles 2002-12-04
TechRepublic's Quick Reference: Microsoft Access Pak helps you understand Access features
Microsoft Access is a powerful relational database management system, but with all that power comes a great deal of complexity. As a result, Access users and the IT professionals who support them need a resource that offers straightforward explanations of Access features. TechRepublic's Quick Reference: Microsoft Access Pak consists of...
Tags: Microsoft Access, Toni Bowers, Microsoft Corp., Microsoft Access Pak, Quick Reference
Technical articles 2004-04-13
How do I... Retrieve a random set of records in Microsoft Access?
We usually think of data in sets of related values, but not always. Occasionally, you may need to supply someone with a set of unrelated records, retrieved completely at random. Perhaps a manager wants to predict future growth or an auditor is looking for anomalies. Now, it would be nice...
Tags: Function, Microsoft Access, Query, Microsoft Corp., Record, Value, FieldValue, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
Blog posts 2007-10-11
Microsoft Access and VB
Hi Everyone,Does anyone know any good books I can get that are narrowly focused on using VB with MS Access 2003? I am in need of a new reference book.these show upin my books24x7 collection:Microsoft Access 2002 Visual Basic for Applications Step by Step Add to Personal Foldersby Evan...
Tags: Microsoft development tools, Microsoft Office, Programming languages, Databases, Microsoft Access, Microsoft Visual Basic, Microsoft VBA, Microsoft Corp.
Discussion threads 2008-11-10
Microsoft Access 2003 Issue (on WinXP Pro)
Client cut a table from one Access database, but then it wouldn't paste into another database, it's own database, or anywhere else. Wouldn't let him undo, either. He's tried searching for it, system recovery, data recovery, clipboard viewer, main IT dept, Microsoft site, web search, etc. (No...
Tags: Databases, Microsoft Windows XP, Microsoft Windows XP Professional, Microsoft Corp., Microsoft Access, copied information, Clipboard, database, toolbar, copied text
Discussion threads 2008-10-02
TechProGuild FastAnswer: Learning basic Microsoft Access keyboard shortcuts
Save time. TechProGuild members can download the preformatted, ready-to-print version of this FastAnswer handout. The next time the problem arises inyour organization, simply print and distribute the file directly to end usersor members of your IT staff.The problemMany tasks in Microsoft Access can be accomplished usingkeystroke combinations rather than point...
Tags: Keyboards, Microsoft Office, Databases, keyboard, Microsoft Access, Microsoft Corp.
Technical articles 2005-04-28
How do I... Publish Microsoft Access check box controls to a Word document?
This article is also available as a PDF download.Access' native controls are functional without beingoverwhelming. However, the other Office applications don't always interpretAccess controls properly. For instance, the publishing process loses check boxcontrols and their bound data when publishing an Access report to Word.Fortunately, there are a couple of easy...
Tags: Microsoft Office
Technical articles 2007-04-11
Learn the basics of Microsoft Access 2000
Microsoft Access 2000 can be a powerful tool for both you and your users. Let TechRepublic show you how easy it is to start using Access 2000 with these simple instructions and a sample database that you can download.Databases can be used to keep track of a variety of things...
Tags: Storage, Databases, Microsoft Office, Jason Smith, database, Microsoft Access 2000, Microsoft Access, Microsoft Corp.
Technical articles 2000-10-20
Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills
This sample chapter, taken from Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills, explains the basics of Microsoft Access' pivot tables and pivot charts. Pivot tables are much more powerful than crosstab queries: They add extra levels of detail for more in-depth analysis. They...
Tags: Microsoft Access, Microsoft Corp., Addison-Wesley, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
Book chapters 2006-04-28
Microsoft Access Database Front End
Hello everyone. I have an issue with a Microsoft Access Runtime Database. Presently, we have an Access database that has been split into a front end and back end (Sales.mdb and Sales_be.mdb respectively). Both of these files currently reside on a mapped drive to which 20+ users have access. The...
Tags: front end, Microsoft Access, database, back-end, TechSupportSpecialist, programming, Microsoft Corp., server, SQL, workstation
Q&A 2006-05-26
10 tips for creating efficient Microsoft Access list box controls
This article is also available as a PDF download.With today's powerful systems, performance isn't the issueit once was. But just because controls respond quickly, that's no a reason toget lazy. Efficient controls aren't necessarily the fastest controls. Rather,efficient controls are easy to use and most responsive to users' needs. Applythe...
Tags: Personal applications, Office suites
Technical articles 2007-04-18
How do I... Print a label for an individual record in Microsoft Access?
Printing labels is a common task and simple enough if you use the Microsoft Access Label wizard. You can print thousands of labels at one time. What isn't as easy is printing a label for a single record. You have to identify the record and pass it to a label...
Tags: Database, Microsoft Access, Query, Report, Microsoft Corp., Record, Form, Printing Label, CustomerID, Productivity, Document Management, Databases, Microsoft Office, Storage, Enterprise Software, Software, Finance, Managerial Accounting, Data Management, Office Suites, Hardware, Susan Harkins
Blog posts 2007-09-24
How do I... Print a single Microsoft Access record in Form View?
This article is also available as a PDF download.As a rule, you won't give users access to tables andqueries. Instead, users usually browse and interact with data via a form.Occasionally, they may want to print data in Form View, which Access supports--witha few limitations. Clicking the Print button or choosing...
Tags: EmployeeID, Me!EmployeeID End Sub, Microsoft Access, Microsoft Corp., Microsoft Office, Susan Harkins
Technical articles 2007-02-20
Create and manipulate Microsoft Access forms with VBA
This sample chapter, taken from Automating Microsoft Access with VBA, discusses how manipulate Microsoft Access forms with VBA. Learn how to use VBA to work with forms in Microsoft Access.This sample chapter, taken from Automating Microsoft Access with VBA, discusses how to use VBA with one of...
Tags: Microsoft Access, Microsoft VBA, Microsoft Corp., Que Publishing, Scripting Languages, Software/Web Development, Web Development
Book chapters 2005-11-14
UI Builder for Microsoft Access 3.5.2 (Windows)
Adding new functionality to your Access database can feel like recreating the wheel. With UI Builder, you have the essential features any Microsoft Access database needs. Save time searching for Microsoft Access tutorials and tips, reading Access books, or paying for MS Access courses. With thousands of users worldwide, UI...
Tags: Microsoft Access, Microsoft Windows, Microsoft Corp., OpenGate Software, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
Software downloads 2010-01-06
Microsoft Access Problem
This issue started happening around 2 months ago and has driven me crazy. We have numerous shared Microsoft access databases throughout our network. The individuals having the issues have the below configurations.Windows XP SP3Office 97 ProfessionalLocal Admin. RightsExample:If employee A has a database open and employee B wants to...
Tags: Storage, Databases, Microsoft Office, database, Microsoft Access, Microsoft Corp.
Discussion threads 2008-11-17
Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills
Pivot tables are much more powerful than crosstab queries: They add extra levels of detail for more in-depth analysis. They are extremely flexible, so you can Â"slice and diceÂ" your data in many ways. They also make it easy to find all kinds of totals, such as sums, counts, and...
Tags: slice, sum, Addison-Wesley, Microsoft Corp., Access Skills, Microsoft Access, Hands-On Microsoft Access, Practical Guide, analysis
Download resources 2006-04-28
  • << Previous
  • page 1 of 500
  • Next >>


Quick Reference: Linux Commands
Reduce stress and speed up resolutions with the easiest command references right at your fingertips. You'll receive a PDF file covering Linux, packed with the most common commands you'll need and use daily.
Buy Now
IT Professional's Guide to Policies and Procedures, Third Ed
Whether you're creating policies for management, training, personnel, support, privacy, Internet/e-mail usage, security, or inventory, you'll meet the needs of your entire enterprise with this one download!
Buy Now

SmartPlanet

Click Here