Slide 1: MOS-AXP
Microsoft Access 2002 Exam: MOS-AXP
Demo Edition
CERT MAGIC
1 http://www.certmagic.com
Slide 2: MOS-AXP
QUESTION: 1 In Report Print Preview it is NOT possible to _____.
A. Zoom in and out B. Access Setup to change the margins, page orientation, paper size, or column options. C. Edit or enter records D. View more than one page E. Print the report
Answer: C Explanation: It is not possible to edit records or enter new records in Report Print Preview. You can, however, zoom in and out, access the Setup dialog box, view multiple pages, and print the report.
QUESTION: 2 Clicking the Print button on the Report Design toolbar will print _____.
A. Only the first record B. Only the records showing on the first page of the report C. All of the records D. Only the records you have selected.
Answer: C Explanation: Clicking the Print button on the Report Design toolbar will print all of the records. If you wish to print only certain records, set the number of copies that print, or send the print job to a different printer, select File, Print, on the Menu bar.
QUESTION: 3 To import Access objects from one database to another, _____. A. Open the database you will be importing the objects from, then click File, Get External Data, Import on the Menu bar. Choose the database you wish to import to in the Import dialog box, and then select which objects you wish to import.
2
http://www.certmagic.com
Slide 3: MOS-AXP
B. Open the database you will be importing the objects into, then click File, Get External Data, Import on the Menu bar. Choose the database you wish to import from in the Import dialog box, and then select which objects you wish to import. C. Open both the database you wish to import from and import to, select the objects you wish to import, and then click File, Import on the menu bar. D. Click File, Get External Data, Import on the Menu bar, then open both databases you wish to import to and from, and click the objects you wish to import in the Import dialog box.
Answer: B Explanation: To import Access objects from one database to another, you first open the database you are importing into, then click File, Get External Data, Import on the Menu bar. Next, choose the database you wish to import from and select the objects which you wish to import.
QUESTION: 4 To export a database object to another Access database, _____. (Choose all that apply) A. Click File, Export on the Menu bar, navigate to the database name you wish to export the object into, and click the Export button, then select the object you wish to export from the database window B. Select the object name in the database window, right-click and choose Export from the Shortcut menu, navigate to the database name you wish to export the object into, and click the Export button C. Click Tools, Export on the Menu bar, navigate to the database name you wish to export the object into, and click the Export button, then select the object you wish to export from the database window D. Select the object name in the database window, click File, Export on the Menu bar, navigate to the database name you wish to export the object into, and click the Export button
Answer: B, D Explanation: To export a database object to another Access database, you can either select Export from the Shortcut menu, or from the Menu bar
QUESTION: 5 To copy and paste records from one table into a new table, you must first _____.
3
http://www.certmagic.com
Slide 4: MOS-AXP
A. Copy and paste only the structure of the source table into a new table B. Select the records to be copied, right-click and choose copy from the Shortcut menu C. Select the destination record and click the Paste button on the toolbar D. Select the records to be copied and click the Copy button on the toolbar
Answer: A Explanation: If you are wanting to copy records into a new table, you must first copy and paste only the structure of the source table into a new table by selecting the source table, right clicking and choosing Copy from the Shortcut menu, then right-clicking in the database window and selecting Paste from the Shortcut menu.Choose Structure Only from the Paste Table As dialog box, and give the new table a unique name.
QUESTION: 6 Which of the following methods is NOT valid for creating Data Access Pages?
A. Page Wizard B. By selecting Tools, Pages, Create on the Menu bar C. AutoPage D. Design View
Answer: B Explanation: Data Access Pages may be created by using the Page Wizard, by selecting the New button on the Objects bar and choosing AutoPage, or in Page Design view. There is no Format, Pages, Create option on the Menu bar.
QUESTION: 7 ____ are groups of commands that can be executed in one operation. A. Tables B. Queries C. Forms D. Reports E. Pages
4
http://www.certmagic.com
Slide 5: MOS-AXP
F. Macros G. Modules
Answer: F Explanation: Macros are groups of commands that can be executed in one operation to simplify repetitive tasks in Microsoft Access 2002
QUESTION: 8 To produce professional-looking printouts of your data, _____ are used.
A. Tables B. Queries C. Forms D. Reports E. Pages F. Macros G. Modules
Answer: D Explanation: Reports are used to display data in a professional and easy-to-read format. Reports allow you to group and sort data, insert pictures and logos, display totals, perform calculations, etc.
QUESTION: 9 _____ are programming statements and procedures written in Visual Basic which are stored together as a group. A. Tables B. Queries C. Forms D. Reports E. Pages F. Macros G. Modules
5
http://www.certmagic.com
Slide 6: MOS-AXP
Answer: G Explanation: Modules are written in Visual Basic computer programming language and are used primarily to create custom applications within Access.
QUESTION: 10 To open a database _____. (Choose all that apply)
A. Click File, Open on the Menu bar B. Use the shortcut keys Ctrl+O C. Click the Open button on the Database toolbar D. Click the database name or choose to create a new database by clicking the option within the Task Pane E. Use the shortcut keys ALT+F4
Answer: A, B, C, D
Explanation: All of the options will open a database, except using the shortcut keys ALT+F4, which will close a database.
QUESTION: 11 To create a blank database, click the Blank Database option in the New section of the _____. A. Menu Bar B. Toolbar C. Task Pane D. Task Bar
Answer: C
Explanation: A blank database can be created from the Task Pane options.
6
http://www.certmagic.com
Slide 7: MOS-AXP
QUESTION: 12 When creating a blank database, enter a database name into the _____ field of the File New Database dialog box, and click the _____ button.
A. File name, Ok B. File name, Create C. Name of File, Create D. Name of File, Ok
Answer: B Explanation: A name must be entered into the File name field of the File New Database dialog box, and the Create button must be clicked in order to create a blank database.
QUESTION: 13 In order to create a database using the Database Wizard, _____.
A. Click General templates from the New File section of the Task Pane B. Click File, New, Database Wizard from the Menu Bar C. Click Tools, Database Wizard from the Menu Bar D. Click Choose file from the New from Existing File section of the Task Pane
Answer: A Explanation: The Database Wizard can be activated by choosing the General templates option in the New File section of the Task Pane
QUESTION: 14 When creating a database using the Database Wizard, click the ____ tab in the Templates dialog box.
A. General B. Database Wizard
7
http://www.certmagic.com
Slide 8: MOS-AXP
C. Templates D. Databases
Answer: D Explanation: In order to create a database using the Database Wizard, the Databases tab must be selected and a database template chosen in the Templates dialog box.
QUESTION: 15 The two views in a table are _____. A. Design and SQL B. Design and Page C. Design and Print Preview D. Design and Datasheet
Answer: D Explanation: Tables have two views, design view and datasheet view.
QUESTION: 16 In a table, _____ view is used to view, enter, edit and print records in a columnar format.
A. Datasheet B. Design C. SQL D. Print Preview
Answer: A Explanation: Datasheet view is used to view, enter, edit and print records in a columnar format.
QUESTION: 17
8
http://www.certmagic.com
Slide 9: MOS-AXP
The vertical window to the right of the application window that contains many common startup tasks is known as the _____. A. Menu bar B. Task Pane C. Toolbar D. Title bar
Answer: B Explanation: The Task Pane can be used to open a previously opened database, create a new database, or to use a built-in database. QUESTION: 18 To change the layout of a table, report, form, or data page, click the _____ view button on the Objects toolbar.
A. Datasheet B. SQL C. Print Preview D. Form E. Layout Preview F. Page G. Design H. None of the Above
Answer: G Explanation: The Design view allows you to make changes to the design of your table, query, report, form, or data page.
QUESTION: 19 Clicking the button with the right arrow and asterisk on the Record Navigation Buttons at the bottom of a table, form, or query will access _____.
A. The first record in a table B. The previous record in a table
9
http://www.certmagic.com
Slide 10: MOS-AXP
C. The current record in a table D. The next record in a table E. The last record in a table F. A new record in a table
Answer: F Explanation: A new record can be accessed by clicking on the New Record button which is identified by a right arrow and asterisk on the Record Navigation Buttons.
QUESTION: 20 Clicking the left arrow on the Record Navigation Buttons at the bottom of a table, form, or query will access _____.
A. The first record in a table B. The previous record in a table C. The current record in a table D. The next record in a table E. The last record in a table F. A new record in a table
Answer: B Explanation: The previous record can be accessed by clicking on the Previous Record button which is identified by a left arrow on the Record Navigation Buttons.
10
http://www.certmagic.com
