Microsoft Access Bootcamp
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
Learn the fundamentals of Microsoft Access quickly in this two-day bootcamp. You'll learn everything you need to create databases, tables, queries, reports, and more. By the end of the Microsoft Access Bootcamp, you'll have the essential skills to use Access on the job.
Are you tired of spending hours organizing worksheets and workbooks in Excel? If so, this Bootcamp is for you. Microsoft designed Access to manage massive datasets, generate reports, and answer queries much more quickly than Excel. In this Access Bootcamp, you'll learn how to share data with other applications like Excel when you need to build charts or create data visualizations.
Curriculum
What you'll learn
- Navigate the Access environment
- Customize configuration
- Organize and manage data
- Use queries to join, sort, and filter
- View, access, and input data with forms
- Create custom reports
- Design a relational database
- Join tables to retrieve data
- Validate entered data
- Create advanced queries
- Improve efficiency and performance
- Maintain data integrity
- Customize reports
Course outline
-
Microsoft Access Level I 6 hours
Learn the basics of relational database management in Microsoft Access Level I. This introductory course covers creating new databases, building tables, designing forms, generating reports, and more. By the end of the course, you'll be able to join, filter, and sort data in Microsoft Access.
- 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
-
Microsoft Access Level II 6 hours
Take your Microsoft Access skills to the next level with advanced lessons on data validation, table structure improvement, and advanced reporting techniques. Learn how to create relational databases, code advanced queries, and increase your database management efficiency.
- Design a relational database.
- Join tables to retrieve data from unrelated tables.
- Validate data entered into a database.
- Use advanced queries to manipulate your data.
- Organize a database for efficiency and performance, and to maintain data integrity.
- Customize reports to organize the displayed information and produce specific print layouts.
What's included
- Microsoft Office
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
–
In-person or live online
Wed, Thu
10:00–17:00 · America/New_York (EDT)
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This program is available for 60 days. You can choose when to start your access period. Once you activate, you will have 60 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $549
- Course length
- 12 hours
- Schedule
- On your schedule
Learn the fundamentals of Microsoft Access at your own pace in this self-paced course. You’ll cover everything from creating databases and tables to building queries and reports. By the end, you’ll have the essential skills to efficiently manage and analyze large datasets using Access.
If you’re tired of spending too much time organizing Excel worksheets, this course is for you. Microsoft Access is designed to handle large datasets and generate reports much faster than Excel. You'll also learn how to share data with other applications, like Excel, for creating charts or visualizations when needed.
Self-paced curriculum
What you'll learn self-paced
- Navigate the Access environment and customize its configuration
- Organize and manage data effectively
- Use queries to join, sort, and filter data
- View, access, and input data through forms
- Create custom reports tailored to your needs
- Design and manage a relational database
- Join tables to retrieve relevant data
- Validate data entered to ensure accuracy
- Build advanced queries for complex data analysis
- Improve efficiency and performance with best practices
- Maintain data integrity throughout your database
- Customize reports to match your specific requirements
Self-paced course outline
-
Microsoft Access Level I (Self-Paced) 6 hours
Get started with relational database management in Microsoft Access Level I. This introductory course teaches you how to create databases, build tables, design forms, generate reports, and more. By the end of the course, you’ll be able to join, filter, and sort data in Microsoft Access.
- Navigate the Microsoft Access environment and create a simple database
- Organize and manage data within Access tables
- Use queries to join, sort, and filter data from multiple tables
- Use forms to simplify data entry, viewing, and access
- Create and format custom reports to meet your needs
-
Microsoft Access Level II (Self-Paced) 6 hours
Take your Microsoft Access skills to the next level with advanced lessons on data validation, table structure optimization, and complex reporting techniques. Learn to design relational databases, write advanced queries, and improve database management efficiency.
- Design a relational database and join tables to retrieve data from multiple sources
- Validate data entered into the database to ensure accuracy
- Use advanced queries to manipulate and analyze data
- Organize your database for better performance and data integrity
- Customize reports to format data and create specific print layouts