Microsoft Access

Microsoft Access is a database management system that provides a variety of options and features for designing, creating, and managing databases.

Content:

• File Tab (Backstage View):
• New, Open, Save, Save As, Print, Share, Export, Close
• Account, Options, and Exit
• Home Tab:
• Views: Datasheet View, Design View, Layout View
• Clipboard: Cut, Copy, Paste
• Records: New, Delete, Save, Undo, Redo
• Sort & Filter: Sort, Filter, Advanced Filter/Sort
• External Data Tab:
• Import, Export, Collect Data, SharePoint Lists
• Database Tools Tab:
• Table Analyzer, Analyze Performance, Database Documenter, Access Database, Macro, Security
• Create Tab:
• Tables, Queries, Forms, Reports, Macros, Module
• Design View for Tables, Queries, Forms, and Reports:
• Design and customize the structure and layout of various database objects.
• Datasheet View:
• Allows you to view and edit data in tables and queries.
• Query Design:
• Build queries using a visual interface to retrieve, filter, and manipulate data.
• Form Design:
• Customize the layout and appearance of data input forms.
• Report Design:
• Design and format reports for printing or viewing.
• Navigation Pane:
• Organize and access database objects such as tables, queries, forms, and reports.
• Relationships:
• Manage relationships between tables to enforce data integrity.
• Macro Builder:
• Create macros to automate tasks and actions in the database.
• Expression Builder:
• Build complex expressions for calculations and conditions.
• SQL View:
• View or edit the SQL code associated with queries.
• Data Macro:
• Create data macros for data validation, automation, and business rules.
• Compact & Repair Database:
• Optimize and repair the database file.
• Database Properties:
• Set properties for the overall database.
• Options:
• Customize various settings and preferences.
• Ribbon Display Options:
• Allows you to customize the appearance of the ribbon.