Prüfungsvorbereitung und Examen MOS Access

Microsoft Office Specialist (MOS) Access (Exam MO-500) ist die offizielle Microsoft-Zertifizierung für Access-Anwender. Hands-on-Prüfung im echten Access. Themen entsprechend MOS Skills Outline für Access Microsoft 365/2019: 1. Create and Manage Databases (15-20%) — Create Blank Databases, Create Databases from Templates, Configure Database Properties (Database Title, Author, Comments), Print Database Documentation (Database Documenter). Import Data into Tables from Excel/CSV/XML/Text Files, Export Data from Tables to Excel/CSV/XML/Text/PDF, Link to External Data Sources (Excel, SharePoint Lists, ODBC). 2. Build Tables (20-25%) — Create Tables in Design View, Set Primary Key, Set Field Sizes, Add Fields (alle Datentypen: Short Text, Long Text, Number with Long/Double/Integer/Byte, Date/Time, Currency, Yes/No, Hyperlink, Attachment, Calculated, Lookup), Set Field Properties (Required, Indexed mit Unique/Duplicates OK, Default Value, Validation Rule mit Validation Text, Input Mask, Format, Caption). Create and Modify Lookup Fields (Combo Box mit Value List oder Table/Query). Set and Manage Table Relationships (1:1, 1:n, n:m mit Junction Table; Cascade Update, Cascade Delete, Enforce Referential Integrity), Save Relationships Diagram. 3. Create Queries (25-30%) — Create Simple Select Queries in Query Design (Add Tables, Add Fields, Set Criteria with =/<>/BETWEEN/LIKE/IN/IS NULL, Sort with Ascending/Descending, Show/Hide Fields), Create Multi-Table Queries with Joins (Inner Default, Left Outer, Right Outer). Create Aggregate Queries (Totals row with Group By, Sum, Avg, Count, Min, Max, First, Last, StDev, Var). Create Action Queries (Append, Update, Delete, Make Table). Create Crosstab Queries (Row Heading, Column Heading, Value with Aggregation). Create Parameter Queries (User-Input at Runtime with [Parameter Prompt] in Criteria). 4. Create Forms (15-20%) — Create Forms (Form Wizard, Blank Form, Form Design), Set Form Controls (Text Box, Combo Box, List Box, Check Box, Option Button, Option Group, Toggle Button, Tab Control, Subform/Subreport, Image, Label, Line, Rectangle, Hyperlink, Web Browser Control). Configure Form Properties (Record Source, Filter, Order By, Allow Edits/Additions/Deletions, Data Entry Mode), Configure Control Properties (Control Source, Format, Decimal Places, Visible, Enabled, Locked, Tab Stop, Tab Order). Apply Form Themes. 5. Create Reports (15-20%) — Create Reports (Report Wizard, Blank Report, Report Design), Configure Report Properties (Record Source, Filter, Order By, Page Header/Footer, Group Header/Footer), Group and Sort Records (Group by Field, Sort by Field), Add Aggregate Functions (Sum, Count, Avg in Group Footers), Format Reports (Themes, Conditional Formatting), Configure Page Setup (Margins, Page Orientation Portrait/Landscape, Page Size). Praxis mit MOS-Sample-Papers. Examen MO-500: 25-35 Aufgaben in Project-basierter Umgebung, 50 Minuten, ~700/1000 Pass. Sie arbeiten in echtem Access — Tabellen erstellen, Abfragen schreiben, Formulare und Berichte bauen.