MS Access

MCQ Worksheets:

MS Access WS1.pdf
MS Access WS2.pdf

Practice Worksheets:

ms-access-worksheet-4.pdf
ms-access-worksheet-3.pdf

Intro to Databases

This video includes information on:

• Why you'd use a database

Getting Started

This video includes information on:

• Getting to know Access 2016

• Using the Ribbon and Tell Me features

• Using the Quick Access Toolbar

• Using Backstage view and the Navigation pan

Intro to Objects

This video includes information on:

• Forms

• Queries

• Reports

• Putting it all together

Sorting & Filtering Records

This video includes information on:

• Creating filters from a selection

• Creating filters from a search term

• Sorting and filtering records

Creating Forms

This video includes information on:

• Adding additional fields to a form

• Adding design controls

• Creating a combo box

• Using subforms

Designing a Simple Query

This video includes information on:

• How queries are used

• Creating a simple one-table query

Creating Reports

Printing Reports

Using the Report Wizard

Formatting Reports