Computer troubleshooting means solving the Computer problems , in a systematic manner, also known as elimination process of the problem. It is a very important process especially in the fields of system administration. Computer troubleshooting is based on the process of finding the problem in the simplest manner. The troubleshooter is responsible for using the right techniques and solving the problems.

Failures in computer functions and applications are characterized by what we can call �symptoms.� Problems can be manifested by general or in more specific symptoms and each of these symptoms can be a result of one or more problems. Once these problems are identified, a series of actions are then implemented in a series of actions.

Computer troubleshooting has many uses, the most important being making the computer system and software trouble free. Computer troubleshooting is very important from the point of view of the users as any fault in the computer programming might result incorrect programming results. The computerization of the troubleshooting procedure might also be able to make the process more user-friendly.

The most important step in Computer troubleshooting is to check the system without leaving any stone unturned. Every element of the system must be checked thoroughly in a manner, which will solve the problem as fast as possible.

Another way of Computer troubleshooting is cognitive walk through, which is an inspection method based on usability.

There is also another way of Computer troubleshooting, which is systematic checklist. This means that there is a flowchart elaborating the step by step process of the Computer troubleshooting.

To import your Data from Microsoft excel:
first ..you should have Data in Microsoft excel..if you don't have,then it's better to make..
and save it where ever you like to save..
second ..go to Microsoft access,.. create a new file,.. then click the blank database. ,..
create table in design view,..make your file,..if you finish them all .,,after creating table by using wizard,..save it,..
third ..right click the mouse,..then click import ,..you will see the another container,..and then if you can't see your file in excel,..click the arrow in files of type ,..you will find there you're file excel..then click import it will appear the another table that named sheet1.., finish,..:-p

1.How do you start MS access?
*Starting Access
1.On the PC, select Start, Programs, and Microsoft Access from the Start list.
2.Double-click on the icon of any Access database. When you double-click an Access database, Access opens with the database already loaded.

Exploring the Access Interface

Components of the Access Window
Besides the usual window components (close box, title bar, scroll bars, etc.), an Access window has several unique elements identified in the figure below.
The Database Toolbar
The Database toolbar, located beneath the menu bar, has buttons for commonly performed tasks like accessing the Relationships window, adding Objects, Exporting to Office, and other operations. Access let's you customize the toolbar or even display multiple toolbars at the same time. The Standard Access XP toolbar appears undocked in the figure below.
The Data sheet Toolbar
The Data sheet toolbar provides common tasks for editing an object in Data sheet view. The Database toolbar will automatically change into the Data sheet toolbar when this view is selected. The Data sheet tool bar exists between different objects, thus, this toolbar largely remains consistent.
The Design Toolbar
The Design toolbar provides common tasks for editing an object in Design view. The Database toolbar will automatically change into the Design toolbar when this view is selected. The Design tool bar exists between different objects, and thus, maintains much of the same functionality.
Common Database Features
Access provides a quick and convenient method of accessing the most common tasks. This includes switching between views, opening and creating new databases, and a few minor formatting issues
Creating a Database
When you start Access there are no databases open, but the Task Pane is visible and provides quick access to common options such as opening an existing database or creating a new database. To create a database, select Blank Database under the New subgroup.
Database Components
An Access database consists of seven different components. These are: tables, queries, forms, reports, pages, macros, and modules. Use the buttons in the database window shown below to create and modify these components. Each component listed is called an object.
Creating Tables
The purpose of a table is to store information. Tables are the building blocks of an access database. Access gives you multiple ways to make tables.
(Step 1) - From the object window select New.
(Step 2) - Choose Table Wizard. Choose OK.
(Step 3) - Select Employees; double click on the fields that will be in the table. If that isn't the exact name of the field then you can select the Rename Field button and retype the field name. Choose OK . Choose Next .
(Step 4) - Type in the table Name and select No, I'll set the primary key . Choose Next .
(Step 5) - From the drop down list choose the field that will be the primary key. Also, choose the correct data type. Choose Next .
(Step 6) - Choose Modify the table design. Choose Finish.
(Step 7) - Close the table by clicking the X button with a gray background.
Creating Relationships
Relating tables together allows for queries to search in multiple tables. The two most common relationships are One-To-One and One-To-Many.
(Step 1) - Select the Relationships button.
(Step 2) - Add both tblEmployees and tblProjects.
(Step 3) - Drag EmpId from tblEmployees and drop it on EmpId from tblProjects.
(Step 4) - Confirm the Relationship type then choose Create.
(Step 5) - Confirm the relationship by looking for a line connecting the tables. Close the Relationships window by clicking on the black X with the gray background.
Creating Queries
Queries allow the user to search data from a table(s) and then save that search. Criteria can be specified and saved in a query. There are several types of queries which perform several types of tasks. A select query is a standard query. To create a simple select query, use the Simple Query Wizard.
(Step 1) - Select New from the Object Window.
(Step 2) - Select Simple Query Wizard. Choose OK . (Notice some of the other types of queries available).
(Step 3) - Select the table or query you want to query from the Tables/Queries drop down list. Double click on the available fields you want to select. Choose Next .
(Step 4) - Name the query and choose Modify the query design . Choose Finish .
(Step 5) - Place criteria in the query design view. Choose the Run button to see results.
Criteria for Queries
Condition
What it Does
Example
=
Exactly matches
=100, =smith
<
Less than
<100
<=
Less than or equal to
<=100
>
Greater than
>100
>=
Greater than or equal to
>= 100
<>
Not equal to
<>100, <>Texas
Is Null
Empty field

Between X and Y
Between one word or number and another word or number

*
Wildcard character
Smi* finds words that begin with Smi such as Smith and Smithsonian
(Step 6) - Place criteria such as an ascending sort in the query and run the query.
.

2.What part of objects may composed an access database?
*The four key parts to an
access database
There are four crucial objects in an access database. Each object provides
a key function.
*Table
· Tables provide the structure for your information
· Tables provide a way to key in information
· Tables allow you to see multiple pieces of information at one time

*Queries
· Queries provide a way for you to ask questions of your database
For example: I want to see all the women in the sales department in
alphabetical order by surname…

*Forms
· Forms provide a way to key in information that is much more user
friendly
· Forms allow you to see just one piece of information at a time

*Reports
· Reports provide a way of producing professional looking output
3.What is the keyboard shortcut 2 exit MS access?
General shortcut keys
Global Access shortcut keys
Opening databases
To do this
Press
Open a new database
CTRL+N
Open an existing database
CTRL+O
Exit Office Access 2007Access
ALT+F4
Printing and saving
To do this
Press
Print the current or selected object
CTRL+P
Open the Print dialog box from Print Preview
P or CTRL+P
Open the Page Setup dialog box from Print Preview
S
Cancel Print Preview or Layout Preview
C or ESC
Save a database object
CTRL+S or SHIFT+F12
Open the Save As dialog box
F12
Using a combo box or list box
To do this
Press
Open a combo box
F4 or ALT+DOWN ARROW
Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box
F9
Move down one line
DOWN ARROW
Move down one page
PAGE DOWN
Move up one line
UP ARROW
Move up one page
PAGE UP
Exit the combo box or list box
TAB
Finding and replacing text or data
To do this
Press
Open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)
CTRL+F
Open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only)
CTRL+H
Find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only)
SHIFT+F4
Working in Design view
To do this
Press
Switch between Edit mode (with insertion point displayed) and Navigation mode (Navigation mode: The mode in Microsoft Access in which an entire field is selected and the insertion point is not visible. In Navigation mode, you can move between fields by using the arrow keys.) in a datasheet. When working in a form or report, press ESC to leave Navigation mode.
F2
Switch to the property sheet (Design view in forms and reports in both Access databases and Access projects)
F4
Switch to Form view from form Design view
F5
Switch between the upper and lower portions of a window (Design view of queries, and the Advanced Filter/Sort window)
F6
Cycle through the field grid, field properties, Navigation Pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables)
F6
Open the Choose Builder dialog box (Design view window of forms and reports)
F7
Open the Visual Basic Editor from a selected property in the property sheet for a form or report
F7
Switch from the Visual Basic Editor back to form or report Design view
SHIFT+F7 or ALT+F11
Editing controls in form and report Design view
To do this
Press
Copy the selected control to the Clipboard
CTRL+C
Cut the selected control and copy it to the Clipboard
CTRL+X
Paste the contents of the Clipboard in the upper-left corner of the selected section
CTRL+V
Move the selected control to the right (except controls that are part of a layout)
RIGHT ARROW or CTRL+RIGHT ARROW
Move the selected control to the left (except controls that are part of a layout)
LEFT ARROW or CTRL+LEFT ARROW
Move the selected control up
UP ARROW or CTRL+UP ARROW
Move the selected control down
DOWN ARROW or CTRL+DOWN ARROW
Increase the height of the selected control
SHIFT+DOWN ARROW
Increase the width of the selected control
Note If used with controls that are in a layout, the entire layout is resized
SHIFT+RIGHT ARROW
Reduce the height of the selected control
SHIFT+UP ARROW
Reduce the width of the selected control
Note If used with controls that are in a layout, the entire layout is resized
SHIFT+LEFT ARROW
Window operations
Note By default, Microsoft Office Access 2007 databases display as tabbed documents. To use windowed documents, click the Microsoft Office Button , and then click Access Options. In the Access Options dialog box, click Current Database and, under Document Window Options, click Overlapping Windows.
To do this
Press
Toggle the Navigation Pane
F11
Cycle between open windows
CTRL+F6
Restore the selected minimized window when all windows are minimized
ENTER
Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window
CTRL+F8
Display the Control menu
ALT+SPACEBAR
Display the shortcut menu
SHIFT+F10
Close the active window
CTRL+W or CTRL+F4
Switch between the Visual Basic Editor and the previous active window
ALT+F11
Working with Wizards
To do this
Press
Toggle the focus forward between controls in the wizard
TAB
Move to the next page of the wizard
ALT+N
Move to the previous page of the wizard
ALT+B
Complete the wizard
ALT+F
Miscellaneous
To do this
Press
Display the complete hyperlink address for a selected hyperlink
F2
Check spelling
F7
Open the Zoom box to conveniently enter expressions and other text in small input areas
SHIFT+F2
Display a property sheet in Design view
ALT+ENTER
Exit Access or close a dialog box
ALT+F4
Invoke a Builder
CTRL+F2
Toggle forward between views when in a table, query, form, report, page, PivotTable list, PivotChart report, stored procedure, or Access project (.adp) function. If there are additional views available, successive keystrokes will move to the next available view.
CTRL+RIGHT ARROW or CRTL+COMMA (,)
Toggle back between views when in a table, query, form, report, page, PivotTable list, PivotChart report, stored procedure, or .adp function. If there are additional views available, successive keystrokes will move to the previous view.
Note CTRL+PERIOD (.) does not work under all conditions with all objects.
CTRL+LEFT ARROW or CRTL+PERIOD (.)
Navigation Pane shortcut keys
Editing and navigating the Object list
To do this
Press
Rename a selected object
F2
Move down one line
DOWN ARROW
Move down one window
PAGE DOWN
Move to the last object
END
Move up one line
UP ARROW
Move up one window
PAGE UP
Move to the first object
HOME
Navigating and opening objects
To do this
Press
Open the selected table or query in Datasheet view
ENTER
Open the selected form or report
ENTER
Run the selected macro
ENTER
Open the selected table, query, form, report, data access page, macro, or module in Design view
CTRL+ENTER
Display the Immediate window in the Visual Basic Editor
CTRL+G
Work with menus
To do this
Press
Show the shortcut menu
SHIFT+F10
Show the access keys
ALT or F10
Show the program icon menu (on the program title bar)
ALT+SPACEBAR
With the menu or submenu visible, select the next or previous command
DOWN ARROW or UP ARROW
Select the menu to the left or right; or, when a submenu is visible, to switch between the main menu and the submenu
LEFT ARROW or RIGHT ARROW
Select the first or last command on the menu or submenu
HOME or END
Close the visible menu and submenu at the same time
ALT
Close the visible menu; or, with a submenu visible, to close the submenu only
ESC
Work in windows and dialog boxes
Using a program window
To do this
Press
Switch to the next program
ALT+TAB
Switch to the previous program
ALT+SHIFT+TAB
Show the Windows Start menu
CTRL+ESC
Close the active database window
CTRL+W
Switch to the next database window
CTRL+F6
Switch to the previous database window
CTRL+SHIFT+F6
Restore the selected minimized window when all windows are minimized
ENTER
Using a dialog box
To do this
Press
Switch to the next tab in a dialog box
CTRL+TAB
Switch to the previous tab in a dialog box
CTRL+SHIFT+TAB
Move to the next option or option group
TAB
Move to the previous option or option group
SHIFT+TAB
Move between options in the selected drop-down list box, or to move between some options in a group of options
Arrow keys
Perform the action assigned to the selected button; select or clear the check box
SPACEBAR
Move to the option by the first letter in the option name in a drop-down list box
Letter key for the first letter in the option name you want (when a drop-down list box is selected)
Select the option, or to select or clear the check box by the letter underlined in the option name
ALT+letter key
Open the selected drop-down list box
ALT+DOWN ARROW
Close the selected drop-down list box
ESC
Perform the action assigned to the default button in the dialog box
ENTER
Cancel the command and close the dialog box
ESC
Close a dialog box
ALT+F4
Editing in a text box
To do this
Press
Move to the beginning of the entry
HOME
Move to the end of the entry
END
Move one character to the left or right
LEFT ARROW or RIGHT ARROW
Move one word to the left or right
CTRL+LEFT ARROW or CTRL+RIGHT ARROW
Select from the insertion point to the beginning of the entry
SHIFT+HOME
Select from the insertion point to the end of the entry
SHIFT+END
Change the size of the selection by one character to the left
SHIFT+LEFT ARROW
Change the size of the selection by one character to the right
SHIFT+RIGHT ARROW
Change the size of the selection by one word to the left
CTRL+SHIFT+LEFT ARROW
Change the size of the selection by one word to the right
CTRL+SHIFT+RIGHT ARROW
Work with the Open, File New Database, and Save As dialog boxes
To do this
Press
Go to the previous folder ( )
ALT+1
Open the folder up one level from the open folder (Up One Level button )
ALT+2
Delete the selected folder or file (Delete button )
DEL
Create a new subfolder in the open folder (Create New Folder button )
ALT+4
Switch between Thumbnails, Tiles, Icons, List, Details, Properties, and Preview views
ALT+5
Show the Tools menu (Tools button)
ALT+L
Work with property sheets
Using a property sheet with a form or report
To do this
Press
Toggle the property sheet tab
F4
Move among choices in the control drop-down list one item at a time
DOWN ARROW or UP ARROW
Move among choices in the control drop-down list five items at a time
PAGE DOWN or PAGE UP
Move to the property sheet tabs from the control drop-down list
TAB
Move among the property sheet tabs with a tab selected, but no property selected
LEFT ARROW or RIGHT ARROW
With a property already selected, move down one property on a tab
TAB
With a property selected, move up one property on a tab; or if already at the top, move to the control drop-down list
SHIFT+TAB
Toggle forward between tabs when a property is selected
CTRL+TAB
Toggle backward between tabs when a property is selected
CTRL+SHIFT+TAB
Using a property sheet with a table or query
To do this
Press
Toggle the property sheet tab
F4
With a tab selected, but no property selected, move among the property sheet tabs
LEFT ARROW or RIGHT ARROW
Move to the property sheet tabs when a property is selected
CTRL+TAB
Move to the first property of a tab when no property is selected
TAB
Move down one property on a tab
TAB
Move up one property on a tab; or if already at the top, select the tab itself
SHIFT+TAB
Toggle forward between tabs when a property is selected
CTRL+TAB
Toggle backward between tabs when a property is selected
CTRL+SHIFT+TAB
Work with the Field List pane
To do this
Press
Toggle the Field List pane
ALT+F8
Add the selected field to the form or report detail section
ENTER
Move up or down the Field List pane
UP ARROW or DOWN ARROW
Move to the upper Field List pane from the lower pane
SHIFT+TAB
Move to the lower Field List pane from the upper pane
TAB
Keyboard shortcuts for using the Help window
To do this
Press
Select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic
TAB
Select the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web site article
SHIFT+TAB
Perform the action for the selected Show All, Hide All, hidden text, or hyperlink
ENTER
Move back to the previous Help topic
ALT+LEFT ARROW
Move forward to the next Help topic
ALT+RIGHT ARROW
Open the Print dialog box
CTRL+P
Scroll small amounts up and down, respectively, within the currently-displayed Help topic.
UP ARROW AND DOWN ARROW
Scroll larger amounts up and down, respectively, within the currently-displayed Help topic.
PAGE UP AND PAGE DOWN
Display a menu of commands for the Help window; requires that the Help window have active focus (click an item in the Help window).
SHIFT+F10
Send e-mail messages
To do this
Press
Send the active database object (the object selected in the Navigation Pane) as an e-mail message
ALT+F+E
Open the Address Book from within Outlook
CTRL+SHIFT+B
Check the names in the To, Cc, and Bcc boxes against the Address Book
ALT+K or CTRL+K
Select the next box in the e-mail header or the body of the message when the last box in the e-mail header is active
TAB
Select the previous field or button in the e-mail header
SHIFT+TAB

4.What are the central location of database object?
*[CONTAINER]..

5.What is the purpose of office assistant?
*The purpose of the office assistant occupation is to perform a variety of clerical & typing tasks in order to provide general
office work in support of an organizational unit.
*

maOt nga candLe !!! ...

coLOriZed teXT!!

.wew ...