Microsoft Access Jobs

I'm in need of an experienced PowerBI developer to engineer advanced reports and dashboards from data sourced from Excel spreadsheets. Key tasks will involve: - Implementing data modeling to organize and make sense of collected data - Developing detailed and advanced reports with complex calculations and measures - Building intuitive and informative dashboards The ideal candidate should have a strong skill set in PowerBI, specifically in crafting complex reports and dashboards. Experience working with Excel spreadsheets as a data source is necessary. Applicants with demonstrated ability to implement advanced-level calculations and measures are preferred.

I need help from an Excel specialist who can help me identify who has opened a shared Excel document that is located on Onedrive. I am trying to see when an employee accessed it last. - You'll need to create a solution that can track and log users who access the file. - The document is accessed by 2-5 people. - It would be beneficial if you could also provide a report or dashboard that can show this access data in a clear and concise manner. Please provide examples of similar work you've done in the past, and any relevant experience that you have.

I require an experienced professional knowledgeable in relational database design. The primary goal is to deepen my understanding and skills in E-R modeling, functional dependency theories, and database norms, particularly: * Identifying entities and relationships * Applying E-R modeling and normal forms for a well-designed relational database. The chosen candidate should be proficient in the aforementioned areas, plus have the capability to clarify how to use these skills to identify performance issues, validate data integrity, and evaluate scalability. The project scope encompasses E-R modeling, identifying entities and relationships, and applying normal forms. Ideal Skills: * Advanced knowledge in RDBMS * Proficiency in E-R modeling * Understanding of functional dependency theories ...

I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.

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.

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