Microsoft Access Jobs

I have run into the classic “The module ‘C:Program FilesCommon FilesMicrosoft SharedVBAVBA7.1’ failed to load” message in Microsoft Excel. It showed up right after I added a Microsoft-official add-in, and now every macro call throws “Sub or Function not defined.” What I need from you is a clear, reproducible fix that gets Excel opening the VBA editor again without errors and restores my existing macros. I’m open to a guided repair, a quick remote session, or a precise checklist I can follow—whichever gets the job done safely and quickly. Please be comfortable troubleshooting Office installations, repairing missing or corrupted DLL dependencies, and rolling back or re-registering add-ins. If extra tools (e.g., Process Monitor, Depe...

I built a financial database in Microsoft Access and currently keep the tables on SharePoint so I can open the file from any workstation. It works, but it’s clunky and slow, and I have finally decided to turn it into a proper cloud-based application running on Microsoft Azure. Here is what I need: • Re-create the existing data model and logic from the Access file (forms, queries, reports, VBA where applicable) as a modern web app hosted on Azure—SQL Database or other native storage that makes the most sense is fine, as long as everything ends up fully managed in the Azure stack. • Migrate the current SharePoint-hosted tables and all live data with zero loss or corruption. • Build a straightforward email-and-password authentication flow and layer user access...

Every month I run an in-person sports-card consignment where bidders often walk away with multiple lots. My Excel sheet already holds the key fields—buyer number, lot number, bid, sales tax and total—but when I run a standard mail merge the Word output splits each lot onto its own page instead of rolling all of a buyer’s purchases into a single report. I’d like you to rework the merge so each buyer receives one consolidated Word document that lists every lot they won, the tax on each bid and the final cost per lot, followed by their overall total. Native Excel and Word tools are preferred; a little VBA or a Transform/SQL step is fine if that’s what it takes, as long as I can maintain it for future sales. Deliverables: • Updated Excel file (or helper que...

سيكون عليك إدخال مجموعة من الأرقام المستخرجة من قواعد بياناتنا الداخلية في قوالب تقارير محددة. أعتمد على Excel وGoogle Sheets لمرحلة التجميع الأولي، ثم يتم ترحيل البيانات إلى ملف Word بالشكل النهائي للتقرير. الدقة في نسخ الأرقام وربطها بالعناوين الصحيحة داخل التقرير أمر أساسي، فهذه التقارير تُستخدم لاتخاذ قرارات تشغيلية مهمة. ملفات القوالب والتعليمات التفصيلية جاهزة وسأشاركها فور توقيع اتفاقية السرية. إذا كنت معتادًا على تشغيل استعلام SQL بسيط لاستخراج البيانات فسيُسهّل ذلك الجزء الأول من العمل، مع أنني سأوفر لك نص الاستعلام وكل ما يلزم. التسليم المقبول: - ملف التقرير النهائي بصيغتي ‎.xlsx‎ و‎.docx‎ متوافق تمامًا مع القالب. معايير القبول: • دقة إدخال 100٪ عند فحص عيّنة عشوائية • الالتزام بتنسيق الخلايا والعناوين كما في القالب • إرسال أول نموذج خلال 2...

I have an Excel workbook packed with financial data that I want living in a modern, cloud-based environment. My goal is to migrate everything into a SharePoint list and then surface it through a Power App so the team can perform day-to-day data entry and updates without touching the spreadsheet again. The app must keep our numbers clean: automated data validation is essential to stop bad entries at the door, and real-time data syncing between the Power App and SharePoint is non-negotiable so everyone always sees the latest figures. If you can also suggest lightweight form creation techniques for future enhancements, that would be a bonus, but the immediate focus is validation and live sync. Deliverables I will sign off on: • A SharePoint list structured to mirror the existing ...

Please Sign Up or Login to see details.

Project Description: I need a professional and visually engaging project dashboard built in Excel or Power BI to monitor project progress, KPIs, risks, and achievements .... The dashboard must be fully editable so I can manually update figures and indicators (no need to connect live databases). Deliverables: • One editable Excel or Power BI dashboard (.xlsx or .pbix) • Professionally formatted layout for both desktop and presentation use • Short guide showing how to update figures manually in future Please focus on clarity, professional presentation, and easy data entry rather than complex automation or live connections.

I have an Excel workbook packed with financial data that I want living in a modern, cloud-based environment. My goal is to migrate everything into a SharePoint list and then surface it through a Power App so the team can perform day-to-day data entry and updates without touching the spreadsheet again. The app must keep our numbers clean: automated data validation is essential to stop bad entries at the door, and real-time data syncing between the Power App and SharePoint is non-negotiable so everyone always sees the latest figures. If you can also suggest lightweight form creation techniques for future enhancements, that would be a bonus, but the immediate focus is validation and live sync. Deliverables I will sign off on: • A SharePoint list structured to mirror the existing ...

I need a comprehensive prospect database of IDEALLY UK Pilates Reformer studios, but also all Mat Based Pilates, Yoga, Barre . The database should include: - Company Name* - Contact Details: - Telephone* - Email* - Full Postal Address* - Owner's Name - Owner's Email - Studio Type - REFORMER, Pilates, Yoga, Barre* - If Reformer, the Number of Reformers if possible - Year of Incorporation* - VAT Registered Status* - Any mention of if they stock grip socks on their website (often in FAQs / shop) I'd like to be able to target approx 250 Pilates Reformer Studios with a samples mailing campaign, but also target the wider pilates, yoga, barre studio market with email campaigns. So the Reformer base is important Ideal skills and experience: - Proficiency...

I run a busy laundry service and need a single system that lets us bill customers, track garments and supplies, and keep every staff member on the same page whether they’re at the front desk or on delivery. The solution has to work on a Windows PC in the shop and on phones for both iOS and Android when we’re on the move. Core workflow • Generate professional invoices on the spot, print or share them digitally. • Maintain a live customer database with visit history, preferences, and balances. • Monitor inventory of detergents, packaging, and any other items we specify, showing alerts when stock is low. Access control We operate with four distinct roles—Owner, Manager, Counter Staff, and Driver—each seeing only the screens they need while sh...

I’m looking for a clean, presentation-ready dashboard built entirely in Excel that lets me monitor overall project progress, 1-5 core KPIs, emerging risks, and key achievements. The design needs to feel modern—think crisp colour palettes, white space, and fonts that sit comfortably on a slide for management review. Visual priority rests on two elements: progress charts that instantly show how far we are against plan, and compact KPI summary cards for quick health checks. You’re welcome to weave in subtle status indicators for risk and achievement so long as they stay unobtrusive. All figures will be entered manually, so please keep the workbook free of live database connections. A single, well-labeled data tab that feeds dynamic tables, charts, and slicers is ideal; I w...

I'm seeking an experienced professional for ZATCA e-invoicing phase 2 integration with our ERP system. Currently, we are in the planning stage. Key Requirements: - Expertise in ZATCA e-invoicing regulations and integration processes - Experience with custom ERP systems, particularly integration with ZATCA - Strong understanding of invoicing and compliance requirements Ideal Skills and Experience: - Proven track record in similar ZATCA integration projects - Proficiency in working with custom-built software and ERP systems - Strong problem-solving and project management skills - Ability to provide documentation and support during implementation Please provide relevant experience and approach to this project.

I need a database in Power BI focused on resource allocation. The primary function of this database will be to manage personnel, budget, and software costs for various projects. Key Requirements: - Track and allocate personnel across projects - Manage and monitor project budgets - Include software cost management - Generate visuals and reports for resource allocation insights Ideal Skills and Experience: - Proficiency in Power BI - Experience in project management and resource allocation - Strong database design skills - Ability to create detailed and interactive reports Please provide detailed project proposals with relevant past work and experience.

Project Description: I need a professional and visually engaging project dashboard built in Excel or Power BI to monitor project progress, KPIs, risks, and achievements .... The dashboard must be fully editable so I can manually update figures and indicators (no need to connect live databases). Deliverables: • One editable Excel or Power BI dashboard (.xlsx or .pbix) • Professionally formatted layout for both desktop and presentation use • Short guide showing how to update figures manually in future Please focus on clarity, professional presentation, and easy data entry rather than complex automation or live connections.

Daily database records have to be entered into our Microsoft Access system, while my inbox, calendar, and digital files stay perfectly organized for smooth operations. The core of the job is database entry—sales, supplier, and inventory information arrives in CSV and needs to be cleaned, validated, then posted into the appropriate Access tables. In parallel, incoming email must be triaged (reply, flag, archive), meetings scheduled or rescheduled, and weekly file folders named and stored so reports can be generated without hunting for documents. I work almost entirely in Microsoft Access for data storage, Outlook for mail and calendar, and a shared OneDrive workspace. If you prefer Excel or Google Sheets as a staging area before importing, that’s fine as long as the final dat...

I need a comprehensive HR portal focused on employee records management. The portal should include: Essential Features: - Personal details tracking - Attendance and leave management - Salary and benefits management Reporting Capabilities: - Employee performance reports - Attendance and leave reports - Salary and benefits reports Ideal Skills and Experience: - Experience in developing HR management systems - Strong database management skills - Proficiency in generating detailed reports - Knowledge of data privacy and security regulations Please provide examples of similar projects completed and estimated timelines.

I’m building a credit bureau platform for the South African market entirely from scratch. The core of the application must calculate reliable credit scores, generate detailed credit reports, and exchange data seamlessly with banks and other financial institutions through secure APIs. Three distinct user roles need to be accommodated from day one: • Admin – full system oversight and data-quality controls • Financial-institution representative – bulk data uploads, portfolio queries, and API keys • Individual user – personal credit report access and dispute management Data protection is non-negotiable. Every component has to meet international standards such as GDPR, while also aligning with local POPIA requirements. That means end-to-end enc...

I run a wholesale business that deals exclusively in silver articles and I need a Windows-compatible, command-line billing program that streamlines our day-to-day operations without the overhead of a graphical interface. The tool has to feel snappy inside the terminal yet cover every task we handle at the counter and in the back office. Core features I must see on first delivery: • Inventory management – update stock in real time as items are bought or returned, track quantity by weight or piece, and flag low-stock thresholds. • Customer database – create, edit, and search customer records quickly; basic contact info is fine, but it must also remember each client’s last purchase. • Sales reporting – daily and monthly summaries exportable to CSV...

Project Title: Development of Legal CRM, Accounting, and Case Tracking System (Desktop + Dashboard Integration) ________________________________________ Project Description I run a small but growing law firm named Just Legal, providing end-to-end legal services — from case filing to client consultation and compliance management. I’m looking to hire a developer or small team who can build a custom CRM and accounting system tailored for legal practice, combining client management, accounting, and real-time performance tracking. The solution should be a blend of: • CRM features (leads, pipeline, and client relationship tracking) • Accounting module (income, expenses, commissions, profit/loss) • Dashboard (advocate and document-team performance, revenue tracking, cas...

I need assistance with organizing and managing inventory data in Excel. Key tasks include: - Data Entry and Organization: Inputting and structuring inventory data. - Data Cleaning and Validation: Ensuring accuracy and consistency. - Importing and Exporting Data: Moving data between systems. - Creating Databases and Tables: Setting up for easy access and reporting. Ideal Skills and Experience: - Proficiency in Excel, especially with data manipulation. - Experience with inventory data. - Detail-oriented and reliable. - Familiarity with data import/export tools. Looking forward to your bids!

I need a solid Power BI build that pulls together three separate data sources—our live MySQL database, several Excel workbooks, and a handful of CSV files—into one clean, refreshable tabular model. Once the data is shaped and related properly, the goal is to surface the key metrics in interactive bar and pie charts that tell the story at a glance. You’ll connect through Power Query (ODBC for MySQL), normalise the tables, create any necessary DAX measures, and lay out the initial report pages in the company colour palette. All work must live inside a single PBIX file that refreshes without errors and matches the control totals I supply. Deliverables • PBIX file with automated connections to MySQL, Excel, and CSV data • Star-schema/tabular model with documen...

I need a quick-turnaround build of a small MS SQL database with a browser-based interface that lets my accounting team log, review, and report on the work they perform for each client. Core schema • Clients: name, address, email, phone, contact • Staff: name, employee #, location • Offices: name, address • Services: description, standard fee Web interface • Clean, responsive screens to enter and update records in each table. • Secure sign-in with two roles—Admin (full control) and User (data entry & report viewing). • Simple navigation so staff can start tracking work right away. Work-tracking workflow 1. User selects a client, chooses a service, assigns themselves (or another staff member), and enters hours spent. 2. The ...

I need a visual-driven data analyst to discover and turn raw research into two clear deliverables—a polished PowerPoint deck and a structured Excel matrix—mapping the entire addressable data-centre market in Australia over the next five years. Scope • Build a comprehensive database of every proposed and existing data-centre site nationwide. • Capture for each site: MW size, indicative Capex, current stage (feasibility, funded, design, build, operational), developer name, landowner, local council, water availability, and proximity to the electricity grid. • Lay out the annual pipeline so growth is visible year-by-year. Deliverables - Excel master sheet: clean, filterable columns, with pivot-ready data. - PowerPoint deck: 5–25 slides featuring m...

Saya ingin mengotomatisasi pembuatan laporan administrasi. Data sumber saya sudah tersimpan rapi di MySQL, sementara hasil akhirnya harus berupa dokumen Microsoft Word yang siap cetak, bersih, dan konsisten. Ruang lingkup yang saya butuhkan: • Merancang template Word (header, footer, numbering, gaya tabel) yang mematuhi format kantor saya. • Menyusun proses pengambilan data dari MySQL—boleh melalui mail-merge, add-in, VBA, atau pendekatan lain—sehingga laporan bisa diperbarui cukup dengan satu klik. • Membuat skrip, makro, atau panduan langkah demi langkah agar tim non-teknis saya dapat menjalankannya tanpa mengubah struktur database. • Memastikan setiap kolom MySQL ter-map ke bagian yang benar di Word, termasuk penanganan tanggal, angka, dan teks...

Tengo avanzada una base de datos en Microsoft Access que contiene 9 tablas; cuatro de ellas se relacionan N-N mediante tablas puente. Necesito que la completes creando todos los componentes de interfaz y consulta que faltan. Lo que requiero: • Formularios de entrada de datos bien estructurados para cada entidad, con validaciones básicas y navegación sencilla. • Formularios de búsqueda y filtrado que utilicen listas desplegables y botones de filtro para localizar registros al instante. • Formularios de informes listos para imprimir o exportar, con un diseño limpio y coherente. • Consultas enfocadas en la búsqueda de información, enlazando correctamente las tablas para mostrar resultados precisos. Entrego la base actual y...

Tengo una base de datos Access con todas las tablas y relaciones listas. Ya comencé a crear formularios que permiten seleccionar el tipo de trabajo y mostrar las órdenes de trabajo con sus detalles, pero necesito que queden depurados y plenamente funcionales. Lo que me falta afinar es: • Formulario principal: debe filtrar por estado del trabajo y por tipo de trabajo, además de las variables “unidad” y “especie”. • Subformulario vinculado: quiero que muestre los detalles asociados de la orden seleccionada y permita ingreso de datos para actualizar la base. Deberá incluir botones de navegación, búsqueda rápida y actualización automática de datos sin errores de sincronía. • Consul...

Tengo un informe en Power BI que funciona, pero quiero llevarlo al siguiente nivel. Necesito optimizar la integración de datos —actualmente llegan desde 1 a 5 hojas de cálculo de Excel— para que el modelo se refresque automáticamente cada vez que esos archivos cambien. Además, busco que el reporte luzca más profesional y resulte más intuitivo para el usuario final. En la práctica, esto implica: • Reestructurar el modelo en Power Query / DAX para que la conexión con los Excel sea limpia y escalable. • Configurar la actualización programada (o un gateway si hiciera falta) de modo que el panel se renueve sin intervención manual cuando los documentos fuente se modifiquen. • Pulir la parte visu...

Proyek ini menawarkan jasa untuk membantu orang: -Membuat atau merapikan dokumen Word, -Menyusun dan mempercantik presentasi PowerPoint, -Mengolah dan merapikan data di Excel secara cepat, rapi, dan profesional. Biasanya klien kamu adalah: -Mahasiswa (butuh laporan, makalah, atau slide presentasi tugas) -Karyawan (butuh laporan kerja, grafik, data Excel) -Pebisnis kecil (butuh template invoice, form, dsb) Microsoft Word Mengetik ulang tugas, laporan, atau proposal Merapikan format (margin, numbering, daftar isi otomatis) Menambahkan header, footer, dan nomor halaman Membuat template dokumen profesional 1. Microsoft Excel Input & olah data Membuat tabel dan rumus dasar (SUM, AVERAGE, IF, dll) Membuat grafik atau diagram otomatis Format laporan keuangan atau absen karyawan 2....