PL-500T00 Microsoft Power Automate RPA Developer

Getting Started with Access

• Launch Access and open a database
• Use tables to store data
• Use queries to combine, find, filter, and sort data
• Use forms to view, add, and update data
• Use reports to present data
• Get help and configure options in Microsoft Access

Creating Tables

• Plan an Access database
• Start a new Access database
• Create a new table
• Establish table relationships

Creating Queries

• Create basic queries
• Perform calculations in a query
• Sort and filter data in a query

Creating Forms

• Start a new form
• Enhance a form

Creating Reports

• Start a new report
• Enhance report layout

Promoting Quality Data Input

• Restrict data input through field validation
• Restrict data input through forms and record validation

Improving Efficiency and Data Integrity

• Data normalization
• Associate unrelated tables
• Enforce referential integrity