This series facilitates online learning, letting students develop competence and confidence in using MS Access Application. This course addresses core-level skills in Microsoft Access.

Topics Covered

1) Understanding Databases • Starting and Opening an Existing Database • Moving Around in Access • Understanding Datasheet View & Design View (2) Creating Tables • Creating a Database • Creating a Table Using the Wizard • Creating and Modifying a Table • Adding Fields to Tables • Adding and Editing Records • Printing Tables • Moving and Deleting Fields • Deleting Records (3) Working with Tables • Formatting a Table • Modifying Field Properties • Sorting Records in a Table • Finding Records in a Table • Using Filters with a Table • Establishing Relationships Between Tables • Creating Subdatasheets • Importing Records From an External Source (4) Creating and Using Queries • Creating and Running a Query • Specifying Criteria in a Query • Using Comparison Operators • Creating a Calculated Field • Creating a Multiple-Table Query • Printing a Query (5) Designing a Form • Creating a Form Using AutoForm • Creating a Form Using the Form Wizard • Adding Controls to a Form • Modifying Control Properties • Resizing and Moving Controls • Entering Records into a Form • Creating Calculated Controls (6) Designing a Report • Creating a Report Using AutoReport • Creating a Report Using Report Wizard • Adding a Control to a Report • Formatting a Report • Resizing and Moving Controls • Creating Calculated Controls • Previewing and Printing

Who should attend

This course is aimed at participants who wish to gain an industry qualification in the Access database environment.

Pre-requisites

Candidates should have an understanding of the Windows environment and be relatively comfortable Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, and Viewing System Information.

What you need to bring

N/A

Key Takeaways

After completing this course, individuals will have the expertise to work competently with Microsoft Access program. Individuals report increased competence and productivity as well as increased credibility with their employers, co-workers and clients.