Microsoft Access Jobs

I'm in need of a data entry specialist who can assist with transferring numerical data from online databases into a SQL database system. Key Responsibilities: - Accessing various online databases to source numerical data - Accurately entering this data into a SQL database Ideal Skills and Experience: - Proficiency in handling numerical data - Experience with data entry from online databases - Familiarity with SQL and database systems - Attention to detail and accuracy in data entry This is a great opportunity for someone with a keen eye for numbers and experience with SQL. I look forward to your bids!

I need an Excel sheet that encompasses tracking for staff attendance, leave, and performance. Key Requirements: - Attendance Tracker: Should facilitate daily attendance logging. - Leave Tracker: Must include leave balance tracking. - Performance Tracker: Primarily focused on monitoring task completion rates. Ideal Skills: - Proficient in Microsoft Excel. - Experience in creating tracking systems in Excel. - Understanding of HR metrics and performance tracking. The freelancer should be capable of producing a comprehensive yet easy-to-use Excel sheet tailored to these requirements.

I'm looking for a freelancer skilled in managing and updating a spreadsheet-based database. The tasks primarily involve data entry and making updates to existing data. Ideal Skills: - Proficiency in spreadsheet software (Excel, Google Sheets, etc.) - Experience in database management - Attention to detail for data entry tasks - Ability to understand and follow instructions for updates

I'm seeking an expert in MS Access to revise my current database for better functionality and to assist with web data population. This project has two key phases: 1) Revision of the existing MS Access Database - Correcting Form view fields: There are some fields in form view that are incorrect or incomplete, such as "Contact 4" information, "Ownership" and "PE Info". Some fields need to be created, some need to be aligned in better table structure. - Logical restructuring of tables: My current tables (Contacts, Capabilities, Soft Scores, etc.) were created by Access when I started the database. These tables need to be restructured to be more logical and user-friendly. - Changing fields: Some fields need to be changed to be radial or Yes/No (eg: all "...

I'm seeking a PowerApps (PA) professional to assist with migrating my MS Access and SQL tables into the DATAVERSE. The tables contain various data types, including images, and have multiple one-to-one and one-to-many relationships. Key Project Details: - Data Relationships: The tables contain one-to-one and one-to-many relationships. - Data Types: The tables include images, text, and numeric values. - Record Count: There are more than 10,000 records to be migrated. Ideal Skills: - Extensive experience with PowerApps (PA) - Proficient in managing data migrations from MS Access and SQL - Familiarity with DATAVERSE - Skilled in handling complex data relationships - Able to work with diverse data types, including images Your ability to ensure a smooth and efficient data migration, wh...

I'm in need of a data analyst who can utilize Power BI to create visual reports based on our sales data. The primary focus of these reports will be analyzing our sales growth over time. Ideal Skills: - Proficiency in Power BI - Data visualization expertise - Experience with sales data analysis

I'm seeking a Power BI expert to develop a dashboard for tracking sales performance. This dashboard will also need to monitor certain financial metrics, specifically revenue and expenses, as well as profit margins. Key Responsibilities: - Design and implement a Power BI dashboard focused on sales performance tracking - Integrate tracking for revenue, expenses, and profit margins - Connect the dashboard with Excel spreadsheets and Google Sheets Ideal Skills: - Proficient in Power BI - Experience with sales and financial dashboard development - Strong skills in connecting and integrating data from Excel and Google Sheets

Subscribers access pages on my site via the following process: 1/ They login via the script. This runs the script which enters a session cookie into the file. The session duration is set to 60 minutes. 2/ They try to access the page (for example). This has the following line - <!--#include file=""--> - in the code which checks the attached file to see if the user has a valid session and that a valid subscription type. All files cited above are available in the attachment. Here is what I am looking for: 1/ I have had this process for many years. It may be efficient or there may be better methods available. Can you update this process as appropriate? 2/ The new pages on my site are now created using php code. Can you create a method to integrate the page protection...

I'm looking for an expert to integrate our existing time tracking software, BioTime, with Oracle Fusion. The integration should cover: - Employee time tracking: Ensuring all employee hours are logged accurately and in real time. - Payroll integration: Streamlining the payroll process by automatically inputting tracked hours and related data. - Attendance management: Tracking and reporting on employee attendance seamlessly. The ideal freelancer for this project should have previous experience with Oracle Fusion, ideally with time tracking integrations, and a solid understanding of BioTime. Proficiency in payroll systems is also crucial. Please provide examples of similar projects you have completed in your proposal.

La Tabla Nutricional está compuesta de dos partes: 1) Confeccionar tabla nutricional en sí, con los valores de los diferentes nutrientes que componen los materiales o ingredientes a utilizar. 2) Confeccionar un texto que señale los diferentes Ingredientes que compone el producto final: Ejemplo: “Ingredientes: masa de cacao…” Cada receta final y por lo tanto el producto final (caja en general) para ofrecer, tiene diferentes “Materiales”, indicados de forma genérica. Lo que se debe hacer es "transformar" (por medio de una lectura de archivos de texto) esos “Materiales” a “Ingredientes” que los componen, es decir, si dice “Cobertura…” (Material) se debe buscar ese material (que tien...

I need some Excel spreadsheets and Word documents converted into editable PDFs. These PDFs are intended for client distribution and need to allow users to interact with them in specific ways. Key Requirements: - Conversion of Excel and Word files into editable PDFs - PDFs should allow users to fill out forms and edit text and data - Inclusion of specific form features such as drop-down menus, checkboxes, and fields for entering data - One form needs to have the capability to calculate totals Ideal Skills: - Proficiency in PDF creation and editing software - Experience with Excel and Word - Attention to detail to ensure all forms are accurately converted and functional - Ability to create interactive elements within PDFs

I need assistance in migrating 14 tables from an Access database to Azure SQL. The migration isn't just a direct transfer; some basic data transformation will be necessary during the process. This is a one-time migration, meaning that I do not require ongoing data syncing post-migration. I need to then have someone help me link the tables to a front-end access database. Ideal skills for this job include: - Proficiency in handling Access databases - Experience with Azure SQL - Database migration experience -Access database experience to help link the tables to my front end. Please bid if you have the required skills and experience. Thank you.

I need an MS Access database to manage and track transfers between my bank accounts. Currently, this data is being tracked in Excel, and I'm looking for a more efficient and organized way to handle this. Key Features: - The database should capture essential data fields for each transaction. These fields include: - Account number - Amount - Date - description - some sums formulas The ideal freelancer for this project should have extensive experience with MS Access, and a proven track record of creating databases for financial transactions. They should also have excellent skills in data organization and management. Importing Data: - Currently, I am entering the data from Excel into the database manually and copy paste from bank website. The freelancer should be able to prov...

I need an Excel expert to refine my database tracking patient referrals to a hospital. The database includes tracking patient specialties, procedures, price (income), and referral sources. Key Tasks Include: - Helping with Excel formulas - Organizing the data for clarity and efficiency - Linking the data appropriately The project will culminate in creating a dashboard with visual charts and graphs. The ideal freelancer should have a strong background in data analysis and visualization, and be proficient in Excel. Experience with creating dashboards in Excel is a plus.

I need assistance with my Excel Master Workbook. The project involves transferring generic data from the Master sheet into specific tables in another sheet within the same workbook. Details: - The data is dynamic and will change daily based on updates in the main sheet. - The method for matching the data to the specific tables in the other sheet varies. Ideal Skills: - Proficiency in Excel - Experience with data manipulation and transfer - Ability to work with dynamic data - Attention to detail

I'm seeking a freelancer to design an Excel reporting template to track our membership enrollments. The template will primarily handle registration data, specifically focusing on membership sign-ups. Key Features: - Automated Calculations: The template should perform relevant computations automatically. - Visual Charts and Graphs: The template must convert data into easy-to-understand visual representations. - Data Filtering and Sorting: The template needs to facilitate easy sorting and filtering of data. Ideal Skills: - Proficiency in Excel, particularly in creating complex templates. - Experience with data visualization - Strong understanding of membership enrollment processes. With this project, I hope to simplify our reporting process and enhance our data interpretation capabil...

I'm looking for an expert in Smart Sheets with experience in healthcare quality systems. The project involves building sheets, reports and dashboards that track operational metrics within a cloud-based quality management platform. Key Requirements: - Proficient in Smart Sheets - Experience with healthcare quality management systems - Ability to create comprehensive, easy-to-understand dashboards and reports - Strong understanding of operational metrics in healthcare The ideal candidate should have a keen eye for detail and a strong background in data analysis, as well as the ability to present complex data in a clear and concise manner. I am looking for someone who can deliver high-quality work on time and can communicate effectively throughout the project. We need to date a mesh ...

I need a skilled developer to create an Access form based ticket tracker. Key Requirements: - The primary purpose of this ticket tracker is to monitor customer support tickets. - The tracker should be accessible to everyone in the company, not just the support team. - While specific fields in the ticket form have not been predetermined, the developer should propose incorporating essential fields like customer information, issue description, and priority level. Ideal Skills: - Proficiency in Microsoft Access and form development. - Experience in creating ticket tracking systems. - Ability to design user-friendly interfaces for company-wide accessibility.

I'm looking for an expert who can perform a full backup of my Outlook emails to a PST file. The backup should include all email attachments without exception. Ideal skills and experience for the job: - In-depth knowledge of Microsoft Outlook - Experience with performing full email backups - Proficient in handling PST files - Capable of ensuring all attachments are included in the backup

I need a skilled programmer to help me update my MsAccess 2007 database. The project will involve making necessary changes to the following components: - Tables - Queries - Forms - Reports Ideal candidates for the job should have a strong background in programming and experience working with MsAccess 2007. They should be able to understand database structures and functionality, and make necessary updates efficiently and accurately. => => Please provide examples of your previous work with MsAccess 2007 in your bid.

I'm looking for a comprehensive database that can manage client information as well as requests for quotes and confirmed orders and/or projects. It should also be able to track project history, with an integrated time tracking application. Key Features: - Client Contact Information: The database should store all relevant client details for easy access and management. - Client Project History: It should keep a record of all past and current projects associated with each client. - Integrated Time Tracking: The time tracking app needs to be seamlessly integrated with the client management database. Quickbooks Time is a good starting point for this app. - Integrated work order form for jobsite clients to permit invoicing at a laterdate. Ideal Skills and Experience: - Database Developmen...

I am in need of a professional who can assist me in finalizing a template for a Performa Invoice for my makeup services. The invoices need to be created in a Word Document format. Ideal Skills: - Proficient in Microsoft Word - Experience with Invoice creation - Good understanding of consulting service invoicing - Strong communication skills for collaborative template finalization

I'm in need of a professional who can create a Performa Invoice for me. Requirements: - The invoice should be formatted as a Word document. - I have an example for you to follow, so you won't need to create a new template. - The invoice needs to include: - My company logo and details - Customer details - An itemized list of products/services with prices Ideal Skills: - Proficiency in Microsoft Word - Attention to detail - Previous experience in invoice creation

I'm in need of a Microsoft Access developer to create an Attendance and Salary Management System for security guards. The core functions of the system include: - Attendance tracking - Dashboard - Employees profiling - Manual Attendance - Basic Pay, Overtime Amount, Deductions - Auto employee IDs - Salary calculation - Reporting (Daily Salary Voucher, Montly Salary Report) Ideal skills and experience for the job include: - Proficiency in Microsoft Access - Experience in developing attendance and salary management systems - Good understanding of tracking and reporting systems - Ability to create user-friendly interfaces for manual data entry.

I'm looking for an expert to assist with migrating our email solution from an on-premises Exchange to Office 365. Key Requirements: - Migration of over 200 mailboxes - Transferring of contacts and calendars alongside emails - Ensuring minimal downtime during the transition Ideal Skills and Experience: - Proven experience with Office 365 migrations - Proficiency in handling large scale email migrations - Expertise in data transfer including contacts and calendars - Excellent troubleshooting skills to handle potential issues during the migration process

I need a professional to assist with entering customer data into our Microsoft Dynamics ERP system. The data is currently stored in spreadsheets and Microsoft Office. Ideal Skills: - Proficiency in Microsoft Dynamics - Strong data entry skills - Attention to detail - Familiarity with Microsoft Office and spreadsheets

I need a professional to assist with entering customer data into our Microsoft Dynamics ERP system. The data is currently stored in spreadsheets and Microsoft Office. Ideal Skills: - Proficiency in Microsoft Dynamics - Strong data entry skills - Attention to detail - Familiarity with Microsoft Office and spreadsheets

I've got a 2002 MS Access application that needs to be upgraded to the current MS Access version. The app is primarily used for data entry and management, and the upgraded version will need to support multiple users with different permissions. Key Requirements: - Upgrade from 2002 MS Access to the latest version - Retain all original functionalities without enhancements - Support for multiple users with different permissions Ideal Skills: - Extensive experience with MS Access - Strong understanding of data management applications - Ability to replicate complex permission structures in new software - Knowledge of MS Access security features for user permissions

I'm experiencing an issue with a combobox in my MS Access database. It's directly bound to TableA and supposed to select entries from Column A. When an entry is found, it should concatenate Column A and Column B and insert the result into Column C in TableB. However, my VBA code keeps throwing an 'Entry Not Found' error, even though I have confirmed all entries are in TableA and all formats are correct. Key Tasks: - Troubleshoot the combobox issue - Optimize the AfterUpdate VBA code I need a freelancer with strong skills in MS Access and VBA, who can help fix this issue and ensure the combobox can correctly select entries from TableA. Please note, I am not using any filter criteria on the combobox data.

I'm in need of a dedicated professional to assist with data entry tasks. The role primarily involves updating data in various online systems. Key Responsibilities: - Regularly updating information on e-commerce platforms. - Maintaining and updating our database systems. Ideal Skills: - Proficiency in data entry. - Familiarity with e-commerce platforms. - Experience with database systems. - Attention to detail and accuracy. This role is pivotal for maintaining the integrity of our online operations and database. If you have the requisite skills and experience, I would love to hear from you.