About Me
MOS Access Associate (Office 365 and Office 2019)
1 Introduction to Microsoft Access
1-1 Overview of Microsoft Access
1-2 Understanding the Access interface
1-3 Navigating the Ribbon and Backstage view
1-4 Customizing the Quick Access Toolbar
1-5 Using the Tell Me feature
2 Creating and Managing Databases
2-1 Creating a new database
2-2 Opening and closing databases
2-3 Saving and backing up databases
2-4 Converting databases between file formats
2-5 Managing database properties
3 Designing Tables
3-1 Understanding table structure
3-2 Creating tables using table design view
3-3 Defining field properties
3-4 Setting primary keys
3-5 Creating relationships between tables
3-6 Enforcing referential integrity
3-7 Using lookup fields
4 Entering and Managing Data
4-1 Entering data into tables
4-2 Editing and deleting records
4-3 Using data entry forms
4-4 Sorting and filtering data
4-5 Using validation rules and messages
4-6 Importing and exporting data
5 Creating and Customizing Forms
5-1 Understanding forms
5-2 Creating forms using the Form Wizard
5-3 Customizing form layout
5-4 Adding controls to forms
5-5 Setting control properties
5-6 Using form views (Form View, Layout View, Design View)
5-7 Creating subforms
6 Creating and Customizing Reports
6-1 Understanding reports
6-2 Creating reports using the Report Wizard
6-3 Customizing report layout
6-4 Adding controls to reports
6-5 Setting control properties
6-6 Using report views (Report View, Layout View, Design View)
6-7 Grouping and summarizing data in reports
6-8 Printing and exporting reports
7 Querying Data
7-1 Understanding queries
7-2 Creating queries using the Query Wizard
7-3 Using query design view
7-4 Adding fields to queries
7-5 Using criteria and operators
7-6 Sorting and grouping query results
7-7 Creating calculated fields
7-8 Using aggregate functions
7-9 Creating and using parameter queries
7-10 Creating and using crosstab queries
8 Macros and Automation
8-1 Understanding macros
8-2 Creating and editing macros
8-3 Using macro actions
8-4 Assigning macros to events
8-5 Debugging macros
8-6 Understanding VBA (Visual Basic for Applications)
8-7 Writing simple VBA procedures
9 Securing and Sharing Databases
9-1 Setting database passwords
9-2 Encrypting databases
9-3 Managing user-level security
9-4 Sharing databases with others
9-5 Using SharePoint and OneDrive for data storage
9-6 Collaborating with others in real-time
10 Maintaining and Optimizing Databases
10-1 Compact and repair databases
10-2 Analyzing and optimizing database performance
10-3 Using the Database Documenter
10-4 Managing database objects
10-5 Backing up and restoring databases
10-6 Migrating databases to newer versions of Access
Setting Control Properties in Microsoft Access

Setting Control Properties in Microsoft Access

Key Concepts

Control Properties

Control properties define the characteristics and behavior of controls within a form or report. These properties include aspects such as name, caption, data source, appearance, and behavior. Setting control properties allows you to customize the functionality and appearance of controls to meet specific needs.

Property Sheet

The Property Sheet is a tool in Access that allows you to view and modify the properties of a selected control. To access the Property Sheet, select a control and click the Property Sheet button in the Design tab. The Property Sheet is divided into categories such as Format, Data, Event, and Other, making it easier to find and modify specific properties.

Common Properties

Common properties are the most frequently used properties that define the core characteristics of controls. These include:

Customizing Properties

Customizing properties involves adjusting the settings of controls to meet specific requirements. For example, you might set the "Caption" property of a text box to provide a clear label for the data entry field. Customizing properties enhances the usability and functionality of the form or report.

Dynamic Properties

Dynamic properties are properties that can change based on user interaction or other conditions. For example, the "Enabled" property of a button might be set to change based on the value of another control. Dynamic properties allow for more interactive and responsive forms and reports.

Examples and Analogies

Imagine setting control properties as customizing a car dashboard. Just as you might adjust the brightness of the dashboard display, set the volume of the radio, and choose which gauges to show, you adjust control properties to customize the appearance and behavior of controls in Access. For example, setting the "Format" property of a date field to "Short Date" is like choosing a 12-hour clock display on a car dashboard.

Another analogy is a digital photo frame. Just as you might set the frame to display photos in a specific order, adjust the brightness, and choose transition effects, you set control properties to customize the display and behavior of controls in Access. For example, setting the "Visible" property of a control to "Yes" is like turning on the display of a digital photo frame.

© 2024 Ahmed Baheeg Khorshid. All rights reserved.