While genome-wide association studies (GWAS) have successfully linked variants to traits in complex human diseases, functional dissection of the discovered loci has lagged behind. We address this gap in the context of Alzheimer’s disease (AD) by performing variant-to-gene (V2G) mapping to implicate causal variants and effector genes from the latest AD GWAS meta-analyses that report 101 loci. Our V2G mapping was performed using three major approaches. First, we performed physical fine-mapping of GWAS variants by leveraging our genomics datasets comprising ATAC-seq, RNA-seq, and high-resolution promoter-focused Capture C from brain-relevant cell models. We identified 89 candidate causal SNPs and 69 effector genes. Second, we designed a single-cell CRISPRi screen to perturb 74 candidate regulatory regions and assessed their transcriptional response in the human microglial cell line, HMC3. We collected 96,639 single cells and identified 19 regulatory regions with 19 corresponding effector genes. Lastly, we functionally dissected our top hit, a locus linked to TSPAN14, and showed that an intronic region containing the AD-associated SNPs rs7080009, rs1870138, and rs1870137 is a microglia-specific enhancer, where the AD risk haplotype showed increased enhancer activity. Excising this region using CRISPR-Cas9 demonstrated decreased TSPAN14 expression, downregulated pathways related to cell adhesion, and decreased levels of secreted pro-inflammatory cytokines IL-6 and IL-8 — known biomarkers of AD and aging. This work provides a systematic framework to map GWAS signals to their effector genes for AD and other brain-related disorders and results in robust leads for follow-up with in-depth functional investigations.