Microsoft access 2000 core

Microsoft Access 2000 Core

MOUS

Version 2.0

MOUS Access 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 2 -

Important Note

Please Read Carefully

Study Tips

This product will provide you questions and answers along with detailed explanations carefully compiled and

written by our experts. Try to understand the concepts behind the questions instead of cramming the questions.

Go through the entire document at least twice so that you make sure that you are not missing anything.

Latest Version

We are constantly reviewing our products. New material is added and old material is revised. Free updates are

available for 90 days after the purchase. You should check your member zone at TestKing an update 3-4 days

before the scheduled exam date.

Here is the procedure to get the latest version:

1. Go to www.testking.com

2. Click on Member zone/Log in

3. The latest versions of all purchased products are downloadable from here. Just click the links.

For most updates, it is enough just to print the new questions at the end of the new version, not the whole

document.

Feedback

Feedback on specific questions should be send to [email protected]. You should state: Exam number and

version, question number, and login ID.

Our experts will answer your mail promptly.

Copyright

Each pdf file contains a unique serial number associated with your particular name and contact information for

security purposes. So if we find out that a particular pdf file is being distributed by you, TestKing reserves the

right to take legal action against you according to the International Copyright Laws.

MOUS Access 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 3 -

QUESTION NO: 1

Print the Customer Invoice report.

MOUS Access 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 4 -

Answer:

Step 1: Click Reports on the Object bar.

Note: We must choose the Reports object. We cannot print reports when we are working with tables.

Step 2: Right-click the Customer Invoice report.

Step 3: Select Print from the context menu.

MOUS Access 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 5 -

QUESTION NO: 2

The existing database contains no tables.

(1) Add a table named Products by importing the Products.xls Excel worksheet from the current

directory.

(2) Use all default settings, set ProdID as the primary key, and import the data to the Products table.

(3) Open the table in Datasheet View and close it.

MOUS Access 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 6 -

Answer:

Step 1: Select the File menu.

Step 2: Select the Get External Data command.

Step 3: Select the Import subcommand

Step 4: Change the file format to Microsoft Excel.

Step 5: Click the Products spreadsheet.

Step 6: Click the Import button.

MOUS Access 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 7 -

Step 7: In the Import Spreadsheet Wizard click the Next button.

Step 8: Click the Next button again (the first row contains column headings – we use the default settings).

MOUS Access 2000 Core

Leading the way in IT testing and certification tools, www.testking.com

- 8 -

Step 9: Again click the Next button (we want to create a new table).