Userform with buttons based on Access table

Having a problem with how to implement what I would like. To simplify, I found an example on this forum of how I would like it to work (see attachment). So, the number of buttons shown is dynamically adapted to a list.

Private Sub UserForm_Initialize()

Dim i As Long

For i = 1 To 10
If Cells(i, 1) = "" Then
    UserForm1.Controls.Item(i - 1).Visible = False
Else
    UserForm1.Controls.Item(i - 1).Visible = True
    UserForm1.Controls.Item(i - 1).Caption = Cells(i, 1).Value
End If
Next
End Sub

Could this be made to work with an Access table/column ()? And could they be sorted alphabetically ()? And could the name be stored in a variable ()? Or would that need an entirely different approach ()?