Microsoft Access Jobs

I'm looking for someone to transform my 35 process flow procedures from Visio to Microsoft Word. The goal is not just to convert these diagrams, but to apply complex formatting including tables, graphics, and appealing textual arrangement. More specifically, - Maintain high levels of detail from the original Visio files, however, please refresh the colored flow diagrams to normal boxes coloured royal blue. - Keep as many graphical elements as possible during the Visio to Word conversion. This task necessitates a good understanding of both Visio and Word. The ideal candidate would be proficient in graphic design and document formatting, with an eye for detail and the ability to interpret and present complex information in an easy-to-understand manner. Prior experience working on s...

I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I should be able...

I require an expert in MS Access and Visual Basic programming to design a user-friendly form input interface for my project. - This interface should be intuitive and be capable of capturing and effectively managing predominantly text data. - Familiarity with database systems and strong understanding of user interface design principles will be extremely advantageous. - I'm looking for someone who can deliver quality work promptly. Demonstrative past experience in similar tasks will be highly advantageous.

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be advantageous. I value...

I'm in need of a skilled and experienced Microsoft Project specialist to create a comprehensive project plan for my upcoming project. Key Deliverables: - The primary requirement is to focus on the Requirements Gathering phase. This should be treated with utmost attention and detail. Goal of the Project Plan: - The main objective of the project plan is to outline the project's timelines. This is crucial for our team to have a clear understanding of the deadlines and the flow of the project. Desired Level of Detail: - The project timeline should be detailed and broken down by week. This will allow for a more structured and easily trackable plan. Ideal Skill Set: - An expert in MS Project tool is a must. - Strong project planning and scheduling skills. - Proven experience in cr...

I'm seeking a proficient Access Database designer to build an advanced and fully functional task management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system features. - An understa...

I have a large set of data in Excel that requires thorough cleaning and organizing. - Tasks include: - Removing duplicates - Standardizing data formats - Data validation and verification - Identifying and correcting errors - Sorting and categorizing data Ideal Skills: - Proficiency in Excel or similar data management tools - Experience with data cleaning and organization - Strong attention to detail and accuracy The volume of data is significant, so I'm looking for someone who can work efficiently without compromising the quality of the work.

I am in need of an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your assistance would be greatly appreciated.

I'm looking for a Power BI expert to create a dashboard primarily for our executive team. - The main goal of this project is to create a visually appealing and easy-to-understand dashboard. - The dashboard should be tailored to the needs of executives, providing them with the key information they require at a glance. - Database of 2,000 cases and 11,090 variables Ideal skills and experience for this job: - Proficiency in Power BI - Previous experience in creating dashboards for executives - Great data visualization skills - Ability to integrate data from databases The successful freelancer will have a good understanding of what makes a dashboard not only visually appealing but also functional for high-level decision-makers. Your experience in data integration and visualization...

I'm looking for a UI designer to develop a clean and minimalist interface for a stock taking application. This UI will be used primarily by our Warehouse staff. Key components of the project include: - UI Design: The primary focus of this project is the design of the user interface. It should be user-friendly, intuitive, and minimalist in style. - Backend Development: The system will be powered by Microsoft Access. The backend should support: - Inventory Tracking: The system should be able to record and update our inventory. - Cost Analysis: The backend should be able to calculate the cost of our stock. - Report Generation: The system should be able to generate detailed reports based on the data entered. The ideal freelancer for this project should have experience in: - UI/UX...

I'm looking for a skilled freelancer who can automate our report generation process and build Power BI models for in-depth data analysis. Key Requirements: - Automating Report Generation: Our current process is manual and time-consuming. We need to automate it to save time and ensure accuracy. - Power BI Models: You should have experience in building Power BI models, specifically for data analysis purposes. Data Sources: - Excel Spreadsheets: The Power BI models will need to connect to our Excel sheets. - Dataverse Database: We also require the establishment of a Dataverse database as part of this project. Ideal Skills and Experience: - Proficiency in Power BI. - Proven experience in automating report generation. - Strong understanding of Excel and database management. - Previous...

I'm in need of an entry-level freelancer to handle a variety of back-office tasks, including data entry and management, as well as customer service and support. Requirements: - The ideal candidate should have a basic understanding of data entry and management, as well as customer service principles. - Proficiency in using custom database software is a must. Responsibilities: - Accurate and timely data entry to maintain database integrity. - Providing necessary customer support and service responses. I'm looking for someone who is organized, detail-oriented, and can work efficiently. While experience in back-office work is preferred, I'm open to new freelancers who are eager to learn and grow in this role.

I'm in need of a reliable colleague who can assist me with data entry. The main task at hand is database creation. Key Responsibilities: - Data Entry: Your main responsibility will be to input data into a database. - Database Creation: You will be actively involved in the creation of a new database from scratch. Ideal Skills and Experience: - Proficiency in Data Entry: I need someone who is both fast and accurate in data entry. - Familiarity with Databases: Experience in creating and managing databases will be a great advantage. - Attention to Detail: The data involved in this project could potentially be complex, so attention to detail is crucial. I appreciate someone who is detail-oriented, reliable, and can work efficiently with minimal supervision. Looking forward to working ...

I need a proficient developer to design a control panel that will be used for monitoring, reporting and controlling a variety of devices. Key Features: - User management: The panel should be capable of handling multiple users with differing levels of access. - Data visualization: The user interface design should prioritize clarity and accessibility, allowing users to easily interpret and interact with device data. - Control device settings: The panel should provide control over the settings of various devices. Specific Device: - The control panel will specifically be used to control and oversee settings for a ride. Ideal Skills: - Proficiency in creating interactive interfaces. - Experience in developing user management systems. - Prior experience working with control panels and device...

Looking for someone to engineer a shared to-do spreadsheet in Microsoft Excel that supports real-time collaborative editing for our team. The successful candidate should have: * Advanced Excel skills; * Experience creating custom spreadsheets for project management; * Understanding of user permissions in Excel with the aim to allow full control access to every team member; With your help, we'll revolutionize how we tackle tasks as a team. The ideal freelancer for this project should be prepared to propose and implement a solution promptly. Familiarity with Microsoft Teams is a plus.

I'm looking for a skilled freelancer to help me in creating a database of entry-level IT working professionals. The database is intended for recruitment purposes and should focus on professionals within our country. Key responsibilities will include: - Identifying and collecting database of entry-level IT professionals. - Categorizing the database based on different IT fields like software development, cyber security, network engineering, etc. Ideal candidates for this project should have experience in: - Database creation and management - IT recruitment - Strong knowledge of the local IT job market Your work will be critical to our hiring processes and future IT recruitment strategies.

My bakery is now in it's fourth generation of ownership. My Dad started using a database program called Formula Coster on his Apple IIc to figure out how to correctly price our baked goods based on ingredient costs, labor costs, overhead, etc. The program also allows us to store the formulas and makeup instructions for all our products based on the dough batch and individual pieces from the dough. It's a simple program that we still use today, but are afraid it may not continue to work very long. Other programs exist, but are all cloud based and require subscriptions with features we do not need. I am seeking an adept database developer to either continue work on an in-progress database or commence anew based on existing requirements. This database is intended for exclusive us...

As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also desirable. Knowledge in ...

As part of my business operations, I need a robust and all-inclusive Excel-based Point of Sale (POS) and Inventory system. KEY FEATURES: - **Sales Tracking**: The system should track all sales, revealing important stats that can aid decision-making. - **Inventory Management**: Stock should sync automatically with sales from POS, maintaining an accurate record of available goods. - **Customer Database**: Important fields such as Contact Information and Purchase History should be part of this system. Important tax-related fields like the tax fee and tax ID number should also be included. IDEAL SKILLS: Freelancers with a strong background in Excel and inventory management systems are preferred. Experience in integrating POS systems and data entry automation is also desirable. Knowledge in ...

I am seeking an Executive Secretary in our company located in Chicago, Us. The Candidate should have 10 years of Experience who can work 30 hours a week and handle a variety of administrative duties. The primary responsibilities of this role will be managing my schedule, scheduling appointments, handling correspondence, and providing excellent customer service to clients. Ideal candidates should be proficient in Microsoft Office (Word, Excel, PowerPoint), Email Management (Outlook, Gmail), and Calendar Management (Google Calendar, Microsoft Outlook). The candidate must be fluent in English (Speaking & Writing) Your ability to multitask and maintain a high level of organization is crucial. A background in customer service would be an advantage. This is a remote position, and you ...

I require a proficient data entry specialist to efficiently input data into my SQLite database from a set of online forms. TASKS TO BE ACCOMPLISHED: - Accurate data entry from 11-20 online forms - Seamless SQLite database integration and management NECESSARY SKILLS: - Extensive experience with SQLite - Excellent data entry skills - Prior experience with online forms - Detail-oriented and precision in data handling. Your ability to complete this task accurately and timely will be crucial to the successful execution of this project.

I'm looking to develop a Microsoft Access database to manage and print cage cards for laboratory mice from an existing Excel file. The Excel includes columns like Cage ID, Strain, Sex, Age, Mouse ID, and Notes, among others. Each card should group mice by their Cage ID and include relevant details such as Strain, Mouse ID, Sex, and Requirements:Database Development: Create a database from the Excel Card Design: Design printable cards with the listed Functionality: Enable direct printing from Interface: Simple UI for selecting and printing cage provide a quote and timeline for this project, along with any similar work you've done.

As a developer, I need someone to assist me in uploading my custom-made Excel Add-in to the Microsoft App Store. This involves making the Add-in available in Microsoft Office Excel's Add-ins. Key responsibilities include: - Uploading the Add-in to the Microsoft App Store: The candidate is expected to have experience with the Microsoft App Store's guidelines and processes. This includes preparing the necessary documentation, setting up the listing, and ensuring compliance with the platform's rules. - Making the Add-in available in Microsoft Office Excel: The candidate should be familiar with the process of making Add-ins available and accessible within Excel. This involves configuring the Add-in to be easily discoverable by users and ensuring a seamless integration into the ...

I'm looking to move my MS-Access database to Azure Cloud. It's currently less than 1GB in size. The process will involve a few key aspects: - **Database Migration**: The primary task is to lift-and-shift the existing database to the Azure platform without any data loss or corruption. - **Data Backup and Recovery**: One of the main security requirements is to ensure that data is backed up regularly and that a robust recovery plan is in place. It's worth noting that there aren't any specific Azure services that need to be integrated, nor any special security measures beyond the data backup and recovery. The ideal candidate for this job should have experience in Azure cloud services and database migration. They should also have a good understanding of data security and...