MS+Access+basic

 //  created by: pmartin  // = Microsoft Access  =

**// To open a new document  //** 1.  click “blank database” 2.  click ok  = //  Saving  // = // A document created in Access is required to be saved before even beginning  (this is because Access saves everything as you type and you are not required to save database after each entry)  //  1. After clicking “blank database”  2. a “file new database” screen comes up   3. at this point you are required to find a location for your database to be saved 4.  Drop down “save in” window to save document in the necessary drive (C:\ or F:\ - there are many folders or subdirectories in C:\ for you to save it - The default may be best i.e. C:\my documents) 5.  Change the file name to something that will help you remember what the document is (i.e. customers) 6.  click create 7.  you are immediately brought to a database “table” window 8.  click new and begin creating your database table in design view

**// In Design View //**
1.  type in each field 2.  select data type after each field (use drop down menu to format by text, number, date, yes/no, etc.) 3.   Description is optional (the maximum number of characters for a description is 255) =// To toggle from design view to dataview  //= 1.  Select view 2.    choose Datasheet View to view data 3.  choose Design View to view design of table // you may also select option from standard toolbar  // = // To open a saved document  // = 1.  Open Access 2.  Click open an existing database 3.  Find directory where file was saved (A:\drive or C:\my documents) 4.  Find file name 5.  Double click on file name or click once and click open
 * // To sort:  //**

1. Click Record
2.  click sort 3.  click ascending (to sort from a – z or 0 - 9) // or // click descending (to sort from z – a or 9 – 0) 1.  Click Tools 2.  Click Spelling 3.  Change misspelled words by making a selection from the suggestion box and clicking change 4.  or repairing misspelled word in the first box. 5.   Also, you may click "ignore all" to a proper noun not found in the dictionary. 1.  Select text 2.  Click edit 3.  Click cut 4.  Move & click cursor to place you would like to insert contents of cell 5.  Click edit 6.  Click paste // Once comfortable with this way of doing things, you may use the toolbars at the top of document as a faster method. Also, you may use your right mouse button to perform tasks. // **// To change the font, style, size & color of text //**// (Access changes every entry uniformly, so when changes are made they are made to whole document //   1.   Click format     2.   click font     3.   select style, size, & color   **//  4.   //** click ok     1.   Click format     2.   click column     3.   click width and type in preference of width    1. Click format    2. click row    3. click height and type in height preference  = //  Saving  // =   // Again, you do not need to save your work, however, if you change column width, row height or format text, you will be asked if you would like to save. You are only saving the formatting – all text will be automatically saved. //
 * // To spell check a document  //**
 * // To cut & paste text  //**
 * // To format column width:  //**
 * // To format row height:  //**