MO-500: Microsoft Access
MO-500: Microsoft Access
90 hours
275 €
E-learning
Description of the course
Are you looking for a powerful tool to efficiently manage and analyze your data? Microsoft Access is the perfect solution for you!
The Microsoft Access course teaches students how to design, create, and manage databases. Students will design tables, select appropriate data types, and create logical relationships. They will also create and manage queries, forms, and reports, and use techniques to streamline data entry, maintain data integrity, and analyze data. Its goal is to equip students with the ability to create and maintain Access Database objects, including tables, relationships, data entry forms, multi-level reports, and multi-table queries.
Profile of Access
This Microsoft Access course is aimed at students looking to enhance their database management skills. We'll guide you step-by-step through creating, managing, and analyzing your own customized information systems.
Whether you have no prior experience with databases or not, our hands-on approach will help you acquire the knowledge and skills you need to become an expert Access user.
Objectives of the Course
✓ Design and create relational databases that adapt to your specific needs.
✓ Manage data effectively using tables, forms, queries, and reports.
✓ Automate repetitive tasks with macros and VBA code.
✓ Analyze data in depth to gain valuable insights and make strategic decisions.
✓ Share your databases with other users securely and efficiently.
Contents of the Course
MODULE 1. Explore the Access environment
- Start Access and work with databases.
- Open databases.
- Use the navigation panel.
- Save and Export Options.
- Save a database as a template.
- Configure Access options.
MODULE 2. Building tables
- Define Access tables.
- Modify the fields of a table.
- Use quick start fields.
- Use Application Elements.
- Import tables from other databases.
- Append records to a table.
- Import data as a linked table.
- Working in the Datasheet View.
- Manipulate a data sheet.
- Print records from a data sheet.
- Validation rules.
- Relationships and table keys.
- Foreign keys.
- Create search fields.
- Working with related data.
MODULE 3. Recover the data you want
- Search records.
- Sort records.
- Filter by selection.
- Filter by form.
- Create a select query in Design View.
- Create a select query in the Query Wizard.
- Modify queries.
- Create multi-table queries.
- Create joins in a query.
- Add criteria to queries.
- Add calculated fields to a query.
- Using the Expression Builder.
- Group and summarize data from queries.
- Create parameter queries.
- Using conditional logic in a query.
- Create update queries.
- Create queries to create tables.
- Create queries to append.
- Create delete queries.
- Create cross-reference queries.
MODULE 4. Working with forms
- Create forms using the Automated Forms Tools.
- Using the Form Wizard.
- Create forms from scratch.
- Modify forms.
- Working with presentations.
- Working with a form in Design View.
- Position form controls.
- Create forms using App Parts.
- Delete forms.
- Align and resize controls.
- Add a subform control.
- Manually create and link a subform.
- Create user-friendly forms.
- Validate data entry in forms.
- Working with fonts, backgrounds and images.
- Format forms for printing.
- Navigation forms.
MODULE 5. Designing reports
- Use the report tool.
- Create a report using the Report Wizard.
- Create reports from scratch.
- The Record Source and Control Source properties.
- Working with reports.
- Add controls from the Ribbon.
- Add calculations to reports.
- Add grouping levels using the shortcut menu.
- Using the Grouping, Sorting, and Total panel.
- Working with paper size, orientation, and report width.
- Format reports in multiple columns.
- Report headers and footers.
- Working with colors.
- Apply a theme.
- Report output options.
MODULE 6. Database protection, maintenance and administration
- Opening modes for databases.
- Recover data from a backup.
- Compact and repair.
- Set startup options.
- Object dependencies and deleting database objects.
- Working with split databases.
CERTIFICATIONS:
MO-500: Microsoft Access Expert
