# Microsoft Access Level I Canonical URL: ## Overview ### Microsoft Access Training in Manhattan Learn the basics of relational database management in Microsoft Access. Do you manage massive datasets in multiple Excel workbooks? If so, you can likely benefit from using Microsoft Access. With MS Access, you can enter, organize, and create reports on massive datasets much more quickly than Excel. Designed as a relational database solution by Microsoft, you can manage personal data or use it as an enterprise solution to manage data for an entire organization. In this introductory course for Microsoft Access 2016, you will learn how to create new databases, build tables, design forms, generate reports, and much more. By the end of the course, you'll be able to join, filter, and sort data in Microsoft Access. ### Enroll in the Microsoft Access Bootcamp Enroll in the [Microsoft Access Bootcamp](/courses/microsoft-access-bootcamp), which includes this course and [Microsoft Access Level II](/courses/access-level-ii). On Day 1, you'll learn the basics of Microsoft Access, including creating tables and simple forms. On Day 2, you'll explore intermediate features such as advanced data controls and sharing data with other applications. The MS Access Bootcamp is ideal for complete beginners, self-taught users with knowledge gaps, and experienced MS Access users who need a refresher. ### Earn Microsoft Access Certification Prove your knowledge of Microsoft Access by earning a certification. Our [Access Specialist Certification Program](/courses/access-specialist-certification-bundle) will prepare you for the official MOS (Microsoft Office Specialist) Access certification exam. The certification package includes a free course retake, two hours of private tutoring with the instructor, and the certification exam fee. ### Free Retake Retake this course within 1 year of your enrollment free of charge. ## What you'll learn - Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options - Organize and manage data stored within Access tables - Use queries to join, sort, and filter data from different tables - Use forms to make it easier to view, access, and input data - Create and format custom reports ## Curriculum #### Getting Started with Access - Orientation to Microsoft Access - Create a Simple Access Database - Get Help and Configure Options in Microsoft Access #### Working with Table Data - Modify Table Data - Sort and Filter Records #### Querying a Database - Create Basic Queries - Sort and Filter Data in a Query - Perform Calculations in a Query #### Using Forms - Create Basic Access Forms - Work with Data on Access Forms #### Generating Reports - Create a Report - Add Controls to a Report - Enhance the Appearance of a Report - Prepare a Report for Print - Organize Report Information - Format Reports ## Schedule - Feb 16, 2027 10:00am–5:00pm — NYC - Jun 8, 2027 10:00am–5:00pm — NYC - Sep 28, 2027 10:00am–5:00pm — NYC ## FAQ ### Is this course open to beginners? Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required. ### Do you offer payment plans or student financing for this course? This course does not qualify for payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify. ### Can I take this course online (remote learning)? No upcoming live online dates are currently available. Please contact us about future availability. ### What happens if I need to miss a session? You have some options: You can watch a recording of the session. We will provide any course materials. Contact us to confirm whether remote attendance is available for your session. You can use your free retake to make up any missed class time. ### What’s included with my tuition? A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement Expert instructors who are industry professionals and experienced educators that are driven to help you succeed Access to Microsoft Office (1 month) during your training Top-notch curricula that have been tried and tested over many cohorts and are consistently improved for an optimal learning experience A 1-year free retake policy which allows students to retake any part of the course or program for free to refresh the materials and gain additional practice 30-day access to class recordings to review material at your own pace A certificate of completion to verify your accomplishment ### Are there any additional fees or expenses? There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us. ### Do you offer any discounts for this course? Take this course as part of a certificate program and save: Microsoft Access Bootcamp Price: $549 | Hours: 12 Hours Microsoft Master Certification Program with Access Price: $2,799 | Hours: 63 Hours Access Specialist Certification Program Price: $859 | Hours: 14 Hours ## Pricing **Tuition:** $325