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

Microsoft Access 2010 Course

Click a link below to get started

(click to go back)

 

Lesson 1: Basics Start Here

 

 

  1. Create a Database
  2. Primary Key
  3. Query: create
  4. Table: change only
  5. Form: create
  6. Query: criteria
  7. Table: add field
  8. Query: create
  9. Query: more
  10. Report: create
  11. Table: delete data
  12. Table: modify data
  13. Modify query
  14. Form: change it
  15. Report: change it
  16. Table: create a new
  17. Total a column

 

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 in a table
  8. Table: average
  9. Table count
  10. Min Max in a column
  11. Spell check
  12. Row: change height
  13. Columns wider
  14. Column hide / unhide
  15. Columns: freeze unfreeze
  16. Find: search
  17. Navigate

 

Lesson 3: Find and Search For Data

 

 

  1. Find: Current Field
  2. Find: Match Case
  3. Find: whole field
  4. Find: current document
  5. Go to
  6. Record: select a
  7. Record: select all
  8. Switch windows
  9. Arrange all
  10. Row: colors
  11. Gridlines on / off
  12. Table: font color
  13. Table: font size
  14. Table: font
  15. Table: bold
  16. Table: italics
  17. Table: underline

 

Lesson 4: Query Text

 

 

  1. Equal to: text query
  2. Or: text query
  3. And: text query
  4. Sort: text query
  5. Do not show field
  6. Not equal to
  7. And: text query

 

Lesson 5: Query Numbers

 

 

  1. Equal to: numbers query
  2. Or: numbers query
  3. Greater than: numbers query
  4. Less than: numbers query
  5. Greater than / equal to: numbers query
  6. Less than / equal to: numbers query
  7. Not equal to: numbers query
  8. Between: numbers query
  9. Great than / less than: numbers query
  10. Less than / equal to: numbers query

 

 

Lesson 6: Query Dates

 

 

  1. Equal to: date query
  2. Greater than: date query
  3. Less than: date query
  4. Or: date query
  5. Greater than / equal to: date query
  6. Less than / equal to: date query
  7. Between: date query
  8. Not equal to: date query
  9. And: date query
  10. Sort: date query