Lesson SummaryStarting Access and Opening a DatabaseTo Start Microsoft Access: Click the WindowsStart button and select All Programs To Open a Database: Click the Open button on the toolbar, or select File Ctrl + O. Understanding the Access ScreenBe able to identify the main components of the Access program screen. Using Menus and ToolbarsMenus: Either click the menu name with the mouse pointer or press the Alt key and the letter that is underlined in the menu name. Toolbars: Simply click the toolbar button you want to use. To Display a Toolbar Button's Description: Position the pointer over the toolbar button and wait a second. A ScreenTip will appear above the button. Filling Out Dialog BoxesBe able to identify and use text boxes, list boxes, combo boxes, check boxes, and sheet tabs. Keystroke and Right Mouse Button ShortcutsKeystroke Shortcuts: Press Ctrl and the letter that corresponds to the shortcut command at the same time. Right Mouse Button Shortcut Menus: Whenever you're unsure or curious about what you can do with an object, click it with the right mouse button to display a list of commands related to the object. Opening and Modifying Database ObjectsTo View Different Types of Database Objects: From the Database window, click the appropriate icon in the Objects bar. To Open a Database Object: Double-click the object or click the database object and click the Open button on the Database window. To Open a Database Object in Design View: Click the database object and click the Design button on the Database window or open the object and click the View button on the toolbar. To Change How Database Objects are Displayed: Click the appropriate View button on the Database window or select View on the menu bar and select the desired view. Working with Multiple WindowsTo Switch between Multiple Windows: Click the corresponding icon on the Windows taskbar or select Window and select the name of the window you want to view. To View Multiple Windows at the Same Time: Select Window from the menu bar and select Tile Horizontally, Tile Vertically, or Cascade from the menu. To Maximize a Window: Click the window's Maximize button. To Restore a Window: Click the Window's Restore button. To Manually Resize a Window: Position the mouse pointer over the edge of the window, hold down the mouse button, and drag the mouse to resize the window, then release the mouse button. To Move a Window: Drag the window's title bar to the location where you want to position the window. Tour of a TableTo Move to the Next Record: Click the Next Record navigation button, or press the key, or click the record you want to select. To Move to the Previous Record: Click the Previous Record navigation button, or press the key, or click the record you want to select. To Move to the Last Record in a Table: Click the Last Record navigation button or press Ctrl + End (when not editing record). To Move to the First Record in a Table: Click the First Record navigation button or press Ctrl + Home (when not editing record). Adding, Editing, and Deleting RecordsTo Add a New Record: Do any of the following:
To Edit a Record: Click the field you want to edit and make the changes. To Delete a Record: Place the insertion point anywhere in the record and click the Delete Record button on the toolbar. Tour of a FormTo Move between Records: Use the record navigation buttons near the bottom of the screen. To Add a New Record: Do any of the following:
To Delete a Record: Place the insertion point anywhere in the record and click the Delete Record button on the toolbar. Tour of a QueryTo Display a Query in Design View: Open the query and click the View button on the toolbar. You can also select the query and click Design. Tour of a ReportTo Zoom in Print Preview: Click the area you want to zoom (either in or out) with the pointer. To Print a Report: Click the Print button on the toolbar, or select File Ctrl + P. Previewing and Printing a Database ObjectTo Preview: Click the Print Preview button on the toolbar or select File To Print: Do any of the following:
For Advanced Printing Options: Select File Selecting Data To Select Text: Move the insertion point to the beginning or end of the text you want to select, click and hold the left mouse button and drag the insertion point across the text, then release the mouse button once the text is selected. To Replace Text: Replace text by first selecting it and then typing the new text you want. To Select a Word: Double-click anywhere in the word. To Select a Cell: Position the mouse over the left edge of the cell you want to select and click to select the cell. To Select a Record or Row: Position the mouse over the record selector and click to select the record. To Select a Field or Column: Position the mouse over the name of the field you want to select and click to select the field. To Select the Entire Table: Click the empty box to the left of the field names. To Cut: Cut text or objects by selecting the text or object and using one of four methods to cut: Click the Cut button on the toolbar. Select Edit Press Ctrl + X. Right-click and select Cut from the shortcut menu. To Copy: Copy text or objects by selecting the text or object and using one of four methods to copy:
To Paste: Paste text or objects by selecting the text or object and using one of four methods to paste the data:
Using UndoTo Undo Your Last Action: Click the Undo button on the toolbar, or select Edit Ctrl + Z. Checking Your SpellingTo Check Your Spelling: Click the Spelling button on the toolbar, or select Tools F7. Getting Help from the Office AssistantYou can ask the Office Assistant (the cute animated character) your Help questions in conversational English. This is the easiest and most common method of getting help. Press F1 to open the Office Assistant, type your question in normal English, and click Search. Changing the Office Assistant and Using the Help buttonTo Change Office Assistants: If necessary, select Help Choose Assistant from the menu, click the Next or Back buttons until you find an Office Assistant you like, then click OK. To Hide the Office Assistant: Right-click the Office Assistant and select Hide from the shortcut menu. To See What a Control in a Dialog Box Does: Click the dialog box's Help button (located right next to the Close button) and click the control you want more information on with the pointer. Using the Zoom BoxTo Zoom into a Cell: Select the cell you want to zoom and press Shift + F2. Closing a Database and Exiting AccessTo Close a Database: Click the Database window Close button or select File To Exit Microsoft Access: Click the Access program Close button or select File Quiz What are the columns in a Microsoft Access table called? Rows. Records. Fields. Cells. Right-clicking something in Access:
Which of the following is NOT a type of Microsoft Access database object?
Which of the following database objects asks a question of information in a database and then displays the results?
Which of the following database objects makes it easy to view, edit, and enter database information?
Design View lets you view and modify the structure of any database object. (True or False?) You can display a database object in Design View by: (Select all that apply.)
|