Microsoft Access (Level 1)

This course will give learners an introduction to the Access , students will learn how to plan databases and create tables. Then they will learn to organize fields and records, and to work with data entry rules. They will learn how to create basic queries, and how to work with forms and reports. This course will help students prepare for the Microsoft Office Specialist exam for Access.

• Introduction to Microsoft Access; Exploring the Access Application Window; Opening and Closing a Database; Getting Help
• Examining Database Objects; Managing Data; Editing Data in Datasheet View
• Creating a Database; Creating a Table; Setting Field Properties; Modifying Tables and Fields
• Sorting and Filtering Data; Displaying and Formatting Data; Using Queries to Retrieve
• Understanding and Creating Forms; Modifying and Customizing Forms; Formatting and Modifying Form Properties
• Understanding and Creating Reports; Modifying and Customizing a Report; Formatting Reports and Modifying Report Properties; Printing a Report