Microsoft Access Jobs

I have a compact Microsoft Access database containing fewer than ten tables that I need moved cleanly into SQL Server. Along with moving the rows themselves, I must keep every primary-key and foreign-key relationship intact so the data model behaves exactly the same once it lands in SQL Server. You are free to use SQL Server Migration Assistant, SSMS scripts, or your own ETL workflow—as long as the end result is a set of SQL Server tables whose structure and links mirror what I have in Access. Acceptance criteria • All tables (1–10 in total) exist in SQL Server with matching column names and data types suited to that platform. • Every existing PK/FK constraint in Access is recreated and validated on the SQL Server side. • Row counts between source and...

I need a tailor-made ERP environment that lets me manage entire IT projects from the first line of the Bill of Quantity through to final hand-over, all inside a single database-driven workspace. The core of the build is a dedicated Project Management module tightly coupled with an advanced BOQ module. Within Project Management, every project record must automatically expose its own Bill of Quantity so I can drill down from high-level milestones to the finest component without leaving the screen. No other scheduling frills are required at this stage—accurate, real-time BOQ visibility is the priority. The BOQ module itself must allow me to: • Enter and maintain granular material cost estimates (hardware, cabling, licenses, etc.) • Track progress against each BOQ line so...

1. Lead Management & Quote Follow-ups: We need an automated system for Lead Generation from our emails. Specifically, I need a dashboard or notification system to alert me if I have forgotten to provide a quote for an inquiry after a certain number of days. 2. Core Document Flow: Configure the full sales and purchase cycle: Inquiry → Sales Quote → Sales Order → Purchase Order → Invoice. We need these documents branded with our Company Logo and Mumbai office details. (Format will be provided) 3. Bulk Data Migration (Excel): We have a small database of spare parts. I need you to set up a Configuration Package to upload our master Excel sheet (Items, Descriptions, and Part Numbers) into the system correctly. 4. Euro to INR Landed Cost Configuration: A critical part ...

I manage several mandate properties and rely on as my central CRM. Each month I send across new projects as well as changes to existing stock; what I need is a dependable hand to keep the database spotless and up-to-date. Here is the flow I follow: I forward the raw material—photos, floor plans, amenity sheets, price revisions, availability charts—and expect every listing inside to reflect that information accurately. You will: • Add any new property that lands in my inbox, filling every field (description, high-resolution images, price slabs, current inventory, pinpoint location, amenity list). • Revisit all active listings, apply my monthly updates, and close or mark sold units when required. Acceptance criteria • All mandatory fields completed wi...

Calamba City, Laguna, Philippines 3 months BPO Experience (Non-Voice Account) - Data Technician/Indexer •Accurately and efficiently encode all data and information in the documents •Analyzing random forms from the system clearly with a given categories •Making sure all documents to be passed are properly done with quality and productivity •Even typographical errors are strictly checked •Tallying of work hours in specified period of time •Meeting quota is requirement as a daily tasks •With fast accurate typing Currently working as a sSales Administrator (1 year and counting) •Maintain all products and pricing information, update all sales networks’ files •Process all incoming inquiries and complaints received via all social media platform...

Create a quick-invoicing program. for an environmental testing lab; for quick-receipt of payment from walk-in clients. - MS Excel or MS Access. local network or single device storage. - 1 screen "menu" that pulls up existing walk-in customers, or can add new ones. - has a new invoice each time the sheet is opened (preferably sequential, starting with last 2 digits of the year; ie: 2026 = 260001 - 'list' price is added. 'discount' can be added at our company's discretion as an item. - pre-populates an invoice with common services, with customer-specific prices - the services have different priorities (Normal, rush, emergency); think of a restaurant menu of adding 'extra' items to a routine menu item - compile items into an invoice, preferabl...

Require online class Key Areas to Focus On: 1. Understanding Database & Data Management (for PMS & Maintenance Transfers) Since you’re working with data migration from NSE to Mary Apps, you need a basic understanding of: SQL (Structured Query Language) – Helps in understanding how data is stored, retrieved, and transferred between systems. Course: “SQL for Beginners” (on Udemy, Coursera, or W3Schools) Data Cleaning & Structuring – Since you deal with PDFs and manual data entry, knowing how to extract, structure, and validate data will be useful. Tool: Power Query in Excel (already in Excel 365, can automate data cleaning). 2. Excel 365 & Microsoft Teams (For Efficient Meetings & Data Handling) Learn Teams for Business – How to sha...

Create a quick-invoicing program. for an environmental testing lab; for quick-receipt of payment from walk-in clients. - MS Excel or MS Access. local network or single device storage. - 1 screen "menu" that pulls up existing walk-in customers, or can add new ones. - has a new invoice each time the sheet is opened (preferably sequential, starting with last 2 digits of the year; ie: 2026 = 260001 - 'list' price is added. 'discount' can be added at our company's discretion as an item. - pre-populates an invoice with common services, with customer-specific prices - the services have different priorities (Normal, rush, emergency); think of a restaurant menu of adding 'extra' items to a routine menu item - compile items into an invoice, preferabl...

I’m looking to lock in a reliable baseline schedule for an upcoming project so I can measure progress against a fixed set of dates right from day one. The focus is a project-level timeline presented as a Gantt chart, detailed enough to highlight every key milestone without drilling all the way down into individual task subtasks. Here’s what I need: • A complete Gantt chart that maps the full project duration, major phases, and clearly defined milestones (with start, finish, and baseline dates). • Logical sequencing with dependencies called out so the critical path is obvious at a glance. • A baseline saved alongside the live schedule so variance tracking is effortless later on. • Editable source file—MS Project, Excel, or another mainstream too...

I need an organised virtual assistant to take over the day-to-day administration for a small team of allied health professionals. The single biggest pain point is processing incoming referrals; right now everything is logged using electonic forms, then manually entering and assigning clients into our team calendar. Beyond referrals, you will also handle front-line customer queries (mostly email and phone messages), keep several clinicians’ calendars up to date, manage digital filing of reports and treatment notes, data entry and place occasional equipment orders with our suppliers. We are still using a document based workflow for referrals, so familiarity with PDF editing and cloud storage tools will help you streamline things while we move toward a more digital system. I’ll...

I have four Excel workbooks that I now need housed in an existing MS Access database. None of the sheets are relational at the moment, so the job is a straight import and structure clean-up rather than designing complex links. Here’s what I need from you: • Import 4 existing Excel Files into 4 tables in an existing MS Access DB (.ACCB) • Add a few basic queries so I can filter, sort and export the data quickly. • Delete bad data and duplicates The project is to be done in .net with WPF user interface. Once complete, send me the .accdb file and the brief how-to notes—that’s it. If something in the data suggests a better structure, feel free to flag it before you proceed; otherwise, a clean one-to-one migration is all I’m after.

I have several years’ worth of appraisal data currently scattered across multiple CSV and TXT files. The goal of this project is to collect that raw information, move it into a clean Microsoft Access back-end, and then give me simple, point-and-click ways to work with it every day. Core objectives • Build the Access tables from my existing CSV/TXT files • Design friendly forms so I can review, edit, and manage the records without touching the tables directly • Enable one-click exports that feed the data into Excel, produce mail-merge ready form letters, or create custom on-screen/printable reports Technical notes • Source files are standard comma-delimited and tab-delimited text or other • Front-end can be Access or an Excel interface, as long as it...

I need a reliable freelancer to pull a blend of text and numerical information from several specified online sources and enter it directly into our live database. You will receive secure database access, complete field guidelines, and a short orientation video so you understand the required structure before you begin. Accuracy is critical; each record must match the formatting rules I provide and all values need to be double-checked for consistency. You should already be comfortable working inside a web-based database interface or with SQL tools, and able to keep a clear audit trail of changes. When the assignment is complete I’m expecting the database to be fully populated, error-free, and ready for immediate reporting use.

Each week I’ll send you a fresh export of our inventory data straight from the ERP. Your job is to turn that raw sheet into an easy-to-digest story in both Excel and Power BI. Here is what I’m after: • In Excel: a cleaned, well-structured workbook with dynamic tables, formulas or Power Query steps that let me drop in the new file and refresh. Pivot tables and slicers should make it effortless for me to drill down by SKU, warehouse and ageing bucket. • In Power BI: an interactive dashboard that mirrors the Excel logic but adds richer visuals—bar charts, pie charts, line graphs and any other view you feel best highlights stock movement, excess, and potential shortages. The report needs to refresh from the same data source I provide and should be easy for me t...

I run a two-person business and we’ve just moved to Monday.com. I need an expert who can quickly turn the platform into our all-in-one workspace. Scope • Build the core CRM: lead capture, deal stages, contact records and simple dashboards. • Create project-management boards for both client work and our own internal initiatives. • Design smart automations that replace the repetitive clicks we do today—status hand-offs, task reminders, and notifications. • Import our existing data from Asana so nothing is lost in the transition. • Configure views for client management, sales tracking and day-to-day task flow. • Walk me through the setup afterward so I can maintain it without outside help. I’m looking for a clean, well-documented w...

I need an Azure infrastructure setup specifically for data storage and management. This setup will be used to support our web applications. Key requirements: - Design and implement Azure architecture tailored for data storage and management. - Ensure robust and secure data storage solutions. - Optimize infrastructure for hosting web applications. - Provide documentation for management and future updates. Ideal Skills & Experience: - Proven experience with Azure setup and management. - Strong background in data storage solutions on Azure. - Expertise in hosting and managing web applications on Azure. - Familiarity with infrastructure documentation and best practices.

I need an Azure infrastructure setup specifically for data storage and management. This setup will be used to support our web applications. Key requirements: - Design and implement Azure architecture tailored for data storage and management. - Ensure robust and secure data storage solutions. - Optimize infrastructure for hosting web applications. - Provide documentation for management and future updates. Ideal Skills & Experience: - Proven experience with Azure setup and management. - Strong background in data storage solutions on Azure. - Expertise in hosting and managing web applications on Azure. - Familiarity with infrastructure documentation and best practices.

I need help with a PowerPoint file that is corrupt and cannot be opened. The corruption occurred for an unknown reason. Ideal skills and experience: - Expertise in handling corrupt PowerPoint files - Proficiency in data recovery tools - Experience with file repair software - Attention to detail and reliability Please provide a solution to recover the file.

The objective of this project is to analyze UPI transaction data to understand transaction trends, user behavior, payment methods, and failure rates. The dashboard helps identify patterns in digital payments and supports better financial decision-making. Tools & Technologies Used Power BI – Data visualization and dashboard creation Microsoft Excel / CSV – Data storage and preprocessing Data Cleaning & Transformation – Handling missing values and formatting data The dataset contains information about UPI transactions, including: Transaction Time Transaction Amount Payment Method (UPI ID, QR Code, Phone Number) Device Type (Mobile, Laptop, Tablet) Transaction Status (Successful / Failed) Transaction Purpose (Bill Payment, Food, Others) Age Group Gender

I need a reliable data-entry specialist to help me input and maintain customer information in our existing database. The job is straightforward but accuracy and consistency are critical: every record must be double-checked for spelling, formatting, and completeness before it is saved. Scope of work • Transfer new customer details from spreadsheets and web forms into the database. • Update existing records when clients change addresses, phone numbers, or other profile data. • Flag incomplete or questionable entries so I can verify them quickly. Tools & workflow Our system is cloud-based (similar to Excel or Airtable); if you are comfortable with standard spreadsheet functions—sorting, filtering, basic formulas—you will feel at home. I will provide ...