微软Access Jobs

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 ...

Saya mencari satu profesional yang bisa menangani dua kebutuhan sekaligus: 1. Pembuatan website • Website yang rapi, cepat di-load, dan responsif di desktop maupun mobile. • Teknologi bebas—WordPress, Laravel, React, atau stack lain—asal Anda mampu merancang tampilan modern, konfigurasi hosting/domain, dan memastikan website siap online. • SEO dasar serta panduan pemakaian singkat akan menjadi nilai tambah. 2. Bantuan tugas atau skripsi mahasiswa • Bimbingan struktur penelitian, perbaikan penulisan, hingga konsultasi metodologi dan analisis data (kuantitatif atau kualitatif). • Bila skripsi mencakup aplikasi sederhana, kode harus bersih, terdokumentasi, dan dapat dijalankan tanpa error. • Semua materi wajib orisinal...

Windows and doors sales sheet base on square meter!! Google Sheets & AppSheet Developer Needed for Quotation, Invoice & Sales Tracking System Description We are looking for an experienced Google Sheets and AppSheet developer to build a professional quotation, invoice, and sales tracking system for our company. The system will be based on Google Sheets + AppSheet and will be used daily by our sales team. The goal is to create a simple but powerful internal system that manages: Customers Quotations Invoices Receipts Sales performance tracking Main Features 1. Customer Database The system must store and organize customer information, including: Customer Name Phone Email Address Project location Notes This will allow us to maintain a complete customer list that we can access anytime....

I have a collection of digital Excel workbooks that must be imported into a live database. Each workbook contains structured records; your task is to move every field into the corresponding table and verify the integrity of the import so the data is immediately usable. The work is purely database entry—no text transcription and no spreadsheet cleanup. You will receive the Excel files exactly as they sit on my drive, and I will provide the database schema along with any lookup tables you might need. Please keep existing column names intact unless we agree on a mapping change in advance. Key deliverables • Populated database with all records from the supplied Excel files • A brief validation log noting any skipped, merged, or corrected rows • Confirmation that pr...