Microsoft Access 2013 Course

Click a link below to get started

Unit 1 – Build a Database / 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

 

Unit 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

 

Unit 4 - 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

 

Unit 5 - 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

 

Unit 6 - 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

 

Unit 3 - 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