Access Level 1 Home / Courses / Access Level 1 Location: PST, Application Classroom Length: 1 day Times: 9:00 AM – 4:30 PM Price: $175 View Course Outline Lesson 1: Getting Started with Access Topic A: Orientation to Microsoft Access Topic B: Create a Simple Access Database Topic C: Get Help and Configure Options in Microsoft Access Lesson 2: Working with Table Data Topic A: Modify Table Data Topic B: Sort and Filter Records Lesson 3: Querying a Database Topic A: Create Basic Queries Topic B: Sort and Filter Data in a Query Topic C: Perform Calculations in a Query Lesson 4: Using Forms Topic A: Create Basic Access Forms Topic B: Work with Data on Access Forms Lesson 5: Generating Reports Topic A: Create a Report Topic B: Add Controls to a Report Topic C: Enhance the Appearance of a Report Topic D: Prepare a Report for Print Topic E: Organize Report Information Topic F: Format Reports Appendix A: Microsoft Office Access 2016 Exam 77-730 Appendix B: Microsoft Access 2016 Common Keyboard Shortcuts COURSE DESCRIPTION: Learn to easily create your own database apps in formats that best serve your business. Access Level 1 covers the basic skills and concepts needed to use Microsoft Access productively and efficiently. Upon completion of this course, participants will have a strong working knowledge of Microsoft Access, including how to design and build an efficient relational database, organize fields and records, construct data fields and tables, run queries, design forms, and build reports. IDEAL CANDIDATES: This hands-on beginner course is appropriate for new users of Microsoft Access. The next steps are Access Level 2 and Access Level 3 which will help prepare participants for the Microsoft Office Specialist exam for Access. CERTIFICATION: In order to earn the Microsoft Office Specialist Access certification, you must pass the MOS Access examination. RELATED COURSES: Access Level 2, Access Level 3 Excel Level 1, Excel Level 2, Excel Level 3, Excel Pivot Tables, Excel Power Pivot, Excel VBA, Office 365, Outlook Level 1, Outlook Level 2, PowerPoint Level 1, PowerPoint Level 2, Project Level 1, Project Level 2, Publisher, SharePoint Site Administrator, SharePoint Site Owner, SharePoint Site User, Visio Level 1, Visio Level 2, Word Level 1, Word Level 2, Word Level 3