Purchase Solution

Query in Access 2000

Not what you're looking for?

Ask Custom Question

You can use the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached to Lecture 1 if you want to play around with this query before answering:

OK, I'm writing a query in Access 2000:

SELECT author_name
FROM authors
WHERE author_name like "%Twain, Mark%";

... but it wont give me results. Why?

Attachments
Purchase this Solution
Solution Summary

The expert examines query in access 2000.

Purchase this Solution
Free BrainMass Quizzes
Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic Networking Questions

This quiz consists of some basic networking questions.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

C# variables and classes

This quiz contains questions about C# classes and variables.

View More Free Quizzes
Related BrainMass Solutions

  • ACCESS 2000

    132828 ACCESS 2000 (Note: cut and paste the SQL answers for questions 1 and 2 into a word document. 1.

  • Please answer and elaborate on the following

    By default, SQL Server uses named pipe \\,\pipe\sql\query for client connections and \\machinename\pipe\sql\query for network connections. The TCP/IP Sockets library is probably the most widely used Net-Library.

  • Monitoring the Performance of SQL Server

    What the Index Wizard does is to take a sample of the queries it finds in the workload, and analyzes them using SQL Server 2000's Query Optimizer.

  • Data Manipulation and Monitoring

    What the Index Wizard does is to take a sample of the queries it finds in the workload, and analyzes them using SQL Server 2000's Query Optimizer.

  • Monitoring the performance of SQL Server

    What the Index Wizard does is to take a sample of the queries it finds in the workload, and analyzes them using SQL Server 2000's Query Optimizer.

  • Designing a database

    What the Index Wizard does is to take a sample of the queries it finds in the workload, and analyzes them using SQL Server 2000's Query Optimizer.

  • Using a semicolon (;) in MS Access

    132585 Queries in Access I notice when writing queries that Access will add in a semicolon at the end of my query. Its just one of those Access things right? We don't have to remember to write the semicolon, as Access adds it in for us correct.

  • SQL pattern matching with MS Access

    The simple answer to your question, then, is that the first query doesn't return any results because it's an exact match query. This solution shows how to do pattern matching in a MS Access SQL query.

  • Access

    35750 Access Start Access, and then open the FirmPays database. Open the query named " June 2". View the query in SQL and answer the following questions. Explain your answers. Which tables are used in the query?

View More Related Solutions