2) Click the Find command on the Home tab. Finding Information in a Table 1) Click anywhere in the column that you want to find data. 2 To remove the filter: 1) Click the drop down arrow next to the column heading that you have filtered on. 4) When finished, right click the Filter1 tab and click Close. 3) Click the Toggle Filter command on the Home tab. To carry out additional multiple column sorts: 1) Select the Filter1 tab. 6) Click the Toggle Filter command on the Home tab. 5) Select for each field the sort order in the Sort: row, ie. 4) Arrange the fields from left to right along the Field: row, in the order that you want to sort them. 3) Click the folder button and navigate to the location where you want to store the new database. Creating a New Database 1) Launch Access ) Type a file name for the new database in the File Name box at the bottom right of the opening screen. 3) Click the check box next to the item(s) that you want to filter on. Filtering a Table 1) Click the drop down arrow next to the column heading that you want to filter on. ![]() ![]() 2) Click the Advanced command in the Sort & Filter group of the Home tab. Multiple Column Sorting 1) Click anywhere on the table that you want to sort. 2) Click the Ascending or Descending command on the Home tab. Closing a Table Click the Close button in the top right corner of the table or, right click the table tab and click Close (or Close All).ΔΆ Sorting & Filtering a Table Simple Sorting 1) Click anywhere in the column that you want to sort on. 3) Select the relevant command at the right. 4) Read the warning message and respond as necessary. 2) Type the new data into the blank row (record). 1) Scroll to the bottom of the table, or click the New Record button on the Navigation Bar. Adding Data to a Table Data is always added to an Access table at the bottom. 2) Move around the table using: The Tab key (moves horizontally to the right) Shift Tab (moves horizontally to the left) The Enter key (move vertically down) The scroll bars at the left and/or bottom The arrow keys on the keyboard The PageUp and Page Down buttons on the keyboard The mouse wheel The Navigation Bar at the bottom left of the table. 1 Working with a Table Opening and Moving Around a Table 1) Double click the table you want to open in the Navigation Pane. Report data in tables or queries that has been laid out and structured for ease of printing. Forms ways of seeing data in tables or queries one record at a time, rather like index cards. Queries saved questions about data in the tables. It displays the various objects that you have in the database, eg: Tables stores for the raw data in your database. The Navigation Pane The Navigation Pane is the area to the left of the opened database. 2) Navigate to the folder that your Access database is stored in. Opening a Database 1) Click the Open command at the top left. 2) Click the Delete command on the Home tab. Deleting a Row (Record) 1) Click anywhere along the row that you want to delete. Access only has 1 undo when editing table data. Tip: If you make a mistake and want to cancel the edit, press the ESC key at the top left of the keyboard or, immediately click Undo. ![]() 3) Click or move onto another record to save the changes. Editing Data 1) Select the data you want to edit. Open existing Templates Create new Click the All Access Objects button at the top of the Navigation Pane to filter and arrange Access objects. 1 Opening Screen Access 2010 launches with a window allowing you to: create a new database from a template create a new template from scratch or open an existing database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |