The 10 step Universal Troubleshooting Process:
1. Prepare
2. Make damage control plan
3. Get a complete and accurate symptom description
4. Reproduce the symptom
5. Do the appropriate corrective maintenance
6. Narrow it down to the root cause
7. Repair or replace the defective component
8. Test
9. Take pride in your solution
10. Prevent future occurrence of this problem
Troubleshooting Tips and Articles
• Logic for Troubleshooting
o Tools and Solutions
o Superstition, Positive Thinking and Luck
o The Many Faces of Troubleshooting and Problem Solving
o Litt's Process Hypothesis
o Speculation, Guesswork and Prayer
o Generic Problem Solving With the Universal Troubleshooting Process
o A great demo of Divide and Conquer
• Universal Troubleshooting Process
o Troubleshooting tips
o Common troubleshooting myths
o Gavin Gray
o Team Troubleshooting
o When the Going Gets Tough
o Natural Born Troubleshooters
o Do the Easy Ones First
o Courseware FAQ
• Industry Specific Information
o Recruiters and Consulting Firms
o Training Firms
• Handy Troubleshooting Tactics
o Corrective Maintenance
o Bottleneck Analysis
o Exploiting Perceived Similarities
o Simplify Everything
o Distinctions and Commonalities
o Damage Control
o Preventive Maintenance
o Shotgunning
• The Attitude
o The Attitude
o Take Pride
o When the Going Gets Tough
o Troubleshooting, Luck and Superstition
o Team Troubleshooting
o Natural Born Troubleshooters
o Take Pride
• Intermittents
o About intermittents
o Intermittents
o My favorite Intermittent Stories
o NASA's Intermittent
• Toolsmanship
o Toolsmanship
o Choosing the Right Tool
Here Are Some Other Troubleshooting Tips:
Quality Control
The quality of the solution depends on the quality put into the steps. Getting a complete and accurate symptom description, and reproducing the symptom, assures that you fix the symptom the customer wanted you to fix. A good damage control plan ensures that you won't make anything worse. Correct general maintenance shows the customer you care about quality, and often greatly reduces costs. A correct narrowing process will reduce costs, prevent further damage, and ensure that the root cause, rather than a peripheral symptom, is fixed. Proper repair or replacement of the defective component prevents further damage.
Testing is like inspection in the factory. The few defects that escape the quality controls of the earlier steps are caught here, by showing that the symptom description you recorded and reproduced has been eliminated, and that no further problems have been created. Taking pride is a periodic maintenance item that ensures the quality of you as a troubleshooter and a human being. Preventing further occurrence is the utmost in customer service. The quality of the solution depends on the quality of the steps.
Bottleneck analysis
Use this when the symptom can be described as "it's too (slow, fast, etc.)". Bottleneck is a special kind of Divide and Conquer (see step 6). One cool and easy bottleneck analysis test is to slow down a section of the system. If that section is the bottleneck, the system as a whole will slow down significantly. If not, it won't. The entire March 1998 Troubleshooting Professional Magazine is devoted to bottleneck analysis.
Don't skip steps
The Divide and Conquer process can be thought of as continually forcing the problem into ever smaller boxes, until it's trapped. Some of the worst troubleshooting debacles I've seen involved the problem escaping the box. In other words, the troubleshooter thought he had proved it was in one area, when it was really in another. When that happens, tests become inconclusive and the troubleshooter starts to doubt himself. Whole days can be wasted. Take every precaution to avoid this -- don't skip steps.
Wednesday, February 24, 2010
Wednesday, January 13, 2010
How To Import Data
To import data in excel to access. First you must create a data in excel then save it anywhere you want. Second you open the Microsoft Access then you create a data
and save it. Then right click and click the import word and find the data you save in excel and click. Finally your finish!!!
and save it. Then right click and click the import word and find the data you save in excel and click. Finally your finish!!!
Tuesday, December 8, 2009
microsoft access!!!
1.) How do you start microsoft 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 parts 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
3.) What is the keyboard shortcut to 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 cenral locations 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.
=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 parts 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
3.) What is the keyboard shortcut to 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 cenral locations 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.
Subscribe to:
Posts (Atom)
