Microsoft Access Basic training 2 days Level 1

Microsoft Access Basic Training Course Description

During Microsoft Access Basic Training 2 days Level 1 you will go through the following topics.

Learning objectives and topics Microsoft Access Basic Training

Basics of Microsoft Access

• Viewing and Printing Objects in Microsoft Access
• Using the new Microsoft Office Access templates
• Create a database
• Using the what do you want to do function and help
• Navigating the Microsoft Access screen

Starting queries in Microsoft Office Access

• Using a query for a calculation with Microsoft Office Access
• Using the Microsoft Office Access Query Wizard
• Using Criteria
• Using selection criteria in Microsoft Office Access
• Sorting data in Microsoft Office Access
• Use "and" / "or" for multiple criteria

Create reports in Microsoft Office Access

• Group and sort
• Creating Calculated Fields in Microsoft Office Access
• Printing a report
• Using Report Wizard in Microsoft Office Access
• Create layout for a report
• Adjust display properties

export & import with Microsoft Office Access

• Importing a Microsoft Office Excel file
• Working with text files
• Using HTML
• Import database
• Importing a Microsoft Office Access object
• Export from Microsoft Office Access to Microsoft Excel

Field Properties in Microsoft Office Access

• Using input masks with Microsoft Office Access
• Changing field properties
• Default values ​​and required fields
• Limiting Values ​​in Microsoft Office Access
• Changing the Formatting Properties

Link with Microsoft Office SharePoint

• Collaborate with Access Web app

Table design in Microsoft Office Access

• Design a table in Microsoft Office Access
• Filtering & Sorting Tables in Microsoft Office Access
• Compose hyperlinks
• Deleting and entering data in Microsoft Office Access
• Using the Table Wizard
• Formatting a datasheet

Form design in Microsoft Office Access

• Manually designing a form
• Changing the tab order
• Compiling calculated fields
• Using the form wizard
• Adjust the display settings
• Changing the controls

Relationships between data in Microsoft Office Access

• Using the relations window
• Preserving Referential Integrity in Database Models
• Working with subdata files in Microsoft Office Access
• Normalizing in Microsoft Office Access
• Applying table relationships in Microsoft Office Access

If you already master the basic knowledge, it is better to Microsoft Access advanced training 2 days Level 2 Follow.

For more related training, please visit the Microsoft look at overview page, examples are the Microsoft Excel Basic training (1 day), Microsoft Office Powerpoint Basic training 1 day Level 1, Microsoft Word Basic training 1 day level 1, Microsoft Excel Power Pivot Basic training (1 day) Level 1, Basic VBA Excel training (2 days) & Microsoft Excel Power Pivot Basic training (1 day) Level 1.