Quick Reference clips for Word, Excel, Outlook and PowerPoint.
Welcome Guest (.|.)

Microsoft Access 2013 Course

Click a link below to get started

(click to go back)

 

 

Lesson 1: Start Here

 

 

  1. Open Access from Windows 7
  2. Database - create one
  3. Create fields
  4. Table - enter data
  5. Primary Key
  6. Query - create
  7. Table - changes only
  8. Form - create
  9. Form - change
  10. Table - add fields
  11. Query - criteria
  12. Report - create
  13. Report - change it
  14. Table - delete data
  15. Table - change data
  16. Changes affect all
  17. Export data to Word
  18. Export to Excel
  19. Calculate total

 

 

Lesson 2: Database Administration

 

 

  1. View all objects
  2. Design vs. Datasheet View
  3. Record: create new
  4. Column: delete
  5. Record: delete
  6. Save changes
  7. Total a column
  8. Average a column
  9. Count a column
  10. Min Max a column
  11. Spell check
  12. Row: height
  13. Columns wider
  14. Columns: all wider
  15. Columns hide unhide
  16. Columns: freeze unfreeze
  17. Find data search
  18. Navigate

 

Lesson 3: Find Data

 

 

  1. Find: Current Field
  2. Find: Match Case
  3. Find: whole field
  4. Find: start of field
  5. Find: current document
  6. Find and replace
  7. Navigate
  8. Record: select a
  9. Records: select all
  10. Switch windows
  11. Arrange views
  12. Row: colors
  13. Grid lines: on / off
  14. Font color: table
  15. Font size: table
  16. Font: table
  17. Font: bold
  18. Font: italicized
  19. Font: underline

 

Lesson 4: Query with Text

 

 

  1. Text: equal to query
  2. Text: 'or' query
  3. Text: 'and' query
  4. Sort your query
  5. Query: field no show
  6. Text: 'not equal to' query

 

 

Lesson 5: Query with Numbers / Currency

 

 

  1. Numbers: equal to query
  2. Numeric: 'or' query
  3. Numeric: 'greater than' query
  4. 'Less than' query
  5. Greater than / equal to
  6. Numeric: 'not equal to' query
  7. Numeric: 'between' query
  8. Greater than / less than
  9. Less than equal to
  10. Numeric: 'and' query

 

 

Lesson 6: Query with Dates

 

 

  1. Date: 'equal to' query
  2. Date: 'great than' query
  3. Date: 'less than' query
  4. Date: 'or' query
  5. Greater than / equal to
  6. Less than / equal to
  7. Date: 'between' query
  8. Date: 'not equal to' query
  9. Date: 'and' query
  10. Sort