Microsoft Access Jobs

I'm looking for a skilled MS Access developer to create a billing and accounting database with a modern, minimalist interface. Key Requirements: - Customizable Reporting: The system should be able to generate a variety of reports on different aspects of the business, such as sales, expenses, and profit margins. These reports should be adaptable for future needs and allow for different levels of detail. - Integration with Existing Systems: The database will need to interact seamlessly with other existing systems and software used by the company, ensuring data consistency and accuracy. - User Permissions and Access Control: The system should have a robust user management system that allows for different access levels and permissions. This will ensure that sensitive financial informatio...

I need an expert in PowerBI to help us recreate some reports we had on Sage but are currently unavailable in Business Central. Key Details: - You will need to create a Sales Report, Financial Report, and Activity Report - The Sales Report should include Revenue, Quantity Sold, and Top-Selling Products - The Financial Report should be a recreation of a Profit and Loss Statement, Balance Sheet, and Cash Flow Statement from our previous data in Sage Ideal Skills and Experience: - Proficiency in PowerBI tools - Previous experience with migrating reports from Sage to Business Central would be a huge advantage - Strong analytical skills to ensure the reports are accurate and comprehensive Please note that we can provide you with the necessary data and previous reports from Sage to facilitate...

I'm running a small business that sells food products and various maintenance materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and...

I'm in need of a customized Point of Sale (POS) system that caters to the needs of my business which operates across 7 or more physical stores. The system should be developed to efficiently manage Inventory, generate Sales Reports, and facilitate a comprehensive Customer Database. Key Features Required: - **Inventory Management**: The system should track stock levels, reorder points, and provide notifications when stocks run low. It should also allow for easy categorization and organization of products. - **Sales Reporting**: I need a robust reporting functionality that can provide insights into sales trends, popular products, and overall store performance. - **Customer Database**: The system needs to be able to store customer data, such as purchase history and contact information....

Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-friendly or visually simple or ap...

I'm in need of a skilled developer to create a robust course management database for our educational institution. Key Functionalities: - Student Registration and Enrollment: The database should be able to store and manage student information. - Grades and Transcripts Management: The system should have a feature to track, store, and manage students' grades and transcripts. - Attendance Tracking: The database needs to have a reliable attendance tracking system. - Multiple Courses: The system should be designed to manage multiple courses efficiently. Expectation: - The database should be able to handle 50-100 users accessing it simultaneously. - It needs to be user-friendly, secure, and scalable for future expansion. - Preferably, a responsive design would be appreciated, but not...

I'm looking for an expert with exceptional Sequel database administration skills on a Windows environment. Your main task will be to handle executing regular exports from our Sequel Database to Excel, performing updates in Excel, and subsequently updating the Sequel Database with the altered data. Skills and Tasks; - Mastery in handling Sequel Database on Windows - Familiarity with Data Modeling and Design - Proficiency in exporting and updating database information via Excel - Being responsive and flexible as the frequency of this task may change. Initially, I will need it done daily for a week. Afterwards, it will be an as-needed basis for remote support. Experience in Performance monitoring, tuning, and database backup would be a bonus. The role demands strong organizational sk...

I require a professional with a keen understanding of both Excel and iOS Numbers to convert a single-sheet Excel spreadsheet into an iOS Numbers document. The converted document will need to retain multiple functionalities including: - Basic calculations - Data visualization - Conditional formatting No data interdependency or connectivity with other aspects is required in this case. The ideal candidate should have significant experience with data conversion between these two platforms and a solid grasp of maintaining functionalities in iOS Numbers. Familiarity with creating visually engaging spreadsheets will be highly regarded. I would like to have conversation with someone to make sure I am asking for something reasonable and to clarify exactly whats needed. TY

Urgently seeking a proficient Microsoft Excel user to help input a mix of numeric and text data into a CSV file. Your skills and experience should encompass: - Mastery of Microsoft Excel - Wide-ranging background in data input - Solid understanding of CSV files - Ability to work quickly and accurately The project is immediate and time-sensitive. Appreciate your prompt attention and swift action. Looking forward to your bids.

We are seeking a Microsoft Computer user from Malaysia to join our team. The ideal candidate will have extensive knowledge and experience in computer and be proficient in various Microsoft technologies. As a Microsoft Computer expert, you will be responsible for developing, testing. and debugging software applications, as well as providing technical support and troubleshooting assistance. The successful candidate must have strong problem-solving skills, attention to detail, and the ability to work independently or as part of a team. Skills required: - Strong proficiency in Microsoft applications - Expertise in computer programming and writing - Problem-solving skills - Attention to detail - Technical support - Troubleshooting This is a medium-sized project with an estimated duration of 1 t...

As a mid-stage software development project in MS Access, I'm in need of an experienced professional to lend their expertise. Your role will involve helping to push the project to its finalization stage. Key Responsibilities: - Understanding the existing code structure. - Assisting in the ongoing development process. - Problem-solving and debugging as necessary. Ideal Skills and Experience: - Proficient in MS Access. - Previous experience in mid or final stage software development. - Superior problem-solving abilities. - Strong communication skills. Your role will be critical in successfully bringing this project to completion.

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key to the success of this projec...

I need help to sanitize my online database to eliminate duplicate entries. My primary data source is an online database which has become cluttered with repetitive information. This hampers the overall efficiency and creates error in my outputs. I urgently require a skilled data entry expert with a strong competency in data cleaning, in particular, the elimination of duplicate entries. Your role will involve systematically reviewing the database, identifying duplicates and then removing or merging this data. Familiarity with online databases and previous experience in data cleaning is a necessity for this task.

Urgently seeking a proficient Microsoft Excel user to help input a mix of numeric and text data into a CSV file. Your skills and experience should encompass: - Mastery of Microsoft Excel - Wide-ranging background in data input - Solid understanding of CSV files - Ability to work quickly and accurately The project is immediate and time-sensitive. Appreciate your prompt attention and swift action. Looking forward to your bids.

A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple dat...

I have a set of handwritten notes with relevant numeric data that I need entering into an online database. The task involves transcribing the numerical information with a high degree of accuracy. Key Requirements: - Enter numeric data from handwritten notes into an online database - Ensure high accuracy in data entry - Abide by project deadlines - Maintain confidentiality of data Skills Required: - Proficiency in data entry - Attention to detail - Experience with online databases - Fast and efficient work ethic - Ability to maintain data confidentiality

I'm looking for an experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...

I'm seeking a professional who can help me craft a comprehensive 2000 word report on Database Management Systems (DBMS). The report needs to cover the key concepts of DBMS, including E-R Diagrams, Normalization (3NF), and crucial SQL queries. The report should be well-researched, well-structured, and free of any plagiarism. I also need a PowerPoint presentation to be created, consisting of 15 slides based on the content of the report.

I'm in need of a highly skilled data entry operator to assist with my Tally entries and MS Excel billing work. The ideal candidate should be well-versed in both Tally and MS Excel, as well as have a strong attention to detail and a high level of accuracy. Key responsibilities include: - Data entry: You will be responsible for entering a wide variety of data into Tally, including processing of invoices, bank statements, and other financial records. - Account reconciliation: Regular reconciliation of Tally entries against bank statements and other financial records is crucial to ensure accuracy in our financial data. - Inventory management: Tracking and updating inventory records in Tally is another essential task that needs to be performed regularly. For the MS Excel billing work:...

I'm looking for someone to set up an FTP server for us. This server will act as a central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP servers and famil...

Database Tool Development I. Introduction 1. Purpose: The DRP Talent Solutions team currently manages an internal workforce partner database developed in-house and updated internally. This resource, currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags for easier navigation and filtering of info...

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.

I am in search of a proficient data entry specialist to integrate data into my online Microsoft Access database. Key Responsibilities: - Entry of a large volume of data accurately and efficiently - Verify the integrity of data before entry into the database Ideal Skills and Experience: - Proficiency with Microsoft Access - High attention to detail, precision and excellent organizational abilities - Prior experience with large database data entry is a plus Please note, the spreadsheet format requirement was skipped and so any standard format is acceptable. Only apply if you are proficient, accurate, diligent, and can meet deadlines.

I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.

I'm looking for a professional who can efficiently clean my PDF files to make them suitable for BI dashboard building in Power BI. Key Tasks: - Extracting Data: The PDFs contain crucial text and tabular information that needs to be accurately extracted. - Removing Duplicate Entries: Ensuring that the data is clean and free from any redundancies. - Standardizing Formatting: The formatting of the extracted data should be consistent and ready for visualization. The ideal freelancer for this job should have: - Proficient experience and skills in cleaning and extracting data from PDFs. - Previous experience in working with BI dashboard platforms, preferably Power BI. - Good communication skills to understand and follow requirements accurately.

I'm seeking a skilled developer to help build a dynamic and secure social registry database. The primary purpose of this database will be to store specific categories of user information, making it a critical data backbone for our social business operations. Key features will include: - Storage of Personal Identities: User's demographic and identity-related data. - Interaction Histories: Tracking user interaction data for better service delivery. - Location Data: Storing user location data to improve geographically targeted offerings. Moreover, I envision a flexible data entry process encompassing: - Manual Data Entry by administrators: Option for admins to input data manually, ensuring the correct configuration and verification of user information. - Automated Data Import: Int...

I need an adept Teams Administrator to set up and manage Powerbi report access and Share OneDrive accounts for the upper echelons of my company. The desired individual should ideally have experience handling Teams Administration for medium-sized groups (10-50). Details: • Allocate Powerbi report access: The task involves granting read-only access to Powerbi Reports for the Executive and Management teams in my organization. • Share OneDrive accounts: You will also need to set up Share OneDrive accounts specifically for these segments. Ideal Candidate: • The ideal candidate will have proven experience in Teams Administration. • Proficiency in managing and configuring Powerbi and OneDrive • Experience working with medium-sized teams of 10-50 peop...

I'm seeking a proficient Excel expert to create a master file for our NDT inspection reports. This master file will centralize all our reports and serve as a robust tool for analysis and reporting. Key Task Requirements: - Integrate worksheets from a master worksheet using advanced Excel formulas and functions, ensuring seamless data pulling. - Design needed features including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in designing visualization charts and...