Hello, I am wondering if anyone has any experience with using Microsoft Access? I know some bare bones functionality but am trying to create an FMLA & Leave tracker / database and having a hard time finding tutorials that align with what I am looking for. Does anyone have any tips or tutorials for Access that might help me? (I tried to find an Access bowl for this question but was unsuccessful so posting here)

like
Posting as :
works at
You are currently posting as works at

Is there a specific reason why you're using Access? Couldn't you do the same with Excel using VLOOKUP and pivot tables? I'm just curious. I used to know Access, but most companies I have worked for in the last few years abandoned it a long time ago.

like

You could achieve it through Google forms and create a database in sheets, it would even have a date stamp.

like

Related Posts

I am 25 years old with roughly no savings. I am a consultant with a technical background. Are there any tips in side jobs/ways to make more money for savings?

like

Ok, my favorite singer comes THIS WEEK for an interview ❗❗❗
I'm excited about the opportunity of proving my capabilities, but I also don't want to miss the chance of getting a picture or maybe an autograph.
Is it ok if I ask for it? Or is it too invasive?

like

Anyone volunteering for the Super Bowl? I’m a greeter at the airport.

like

Thinking of moving my whole crypto portfolio into BTC. Is this dumb?

like

𝐒𝐀𝐏 𝐖𝐨𝐫𝐤 𝐙𝐨𝐧𝐞 𝐟𝐨𝐫 𝐇𝐑 𝐇𝐚𝐜𝐤𝐚𝐭𝐡𝐨𝐧!!

Prerequisites
*****************
* You need a SAP HXM and a SAP Work Zone instance. If you do not have one already, buy a PLS tenant.
* You should have BTP experience and skills in your organisation to build out the use case
* Global partners with entities in more than one region can put in multiple entries globally limited to one team per region; content must be different for each regional submission

Post Photo

Sometimes I struggle with the balance between “pushing myself out of comfort zone” and “being comfortable with who I am”. Anyone feel the same way?

like

How hard is it to unload a lease in CLT? Has anyone done it before?

like

Can some refer me in cogni...
Data Analyst.
YOE 1.5

like
like
likehelpful

I contribute 10% of my paycheck to my employee share purchase plan. Is this smart to do given the tax repercussions behind it? Is it smarter to invest less in that and more in my Roth or 401k?

like

I’m a free-lance video producer wanting to expand more into social media content creation. Any advice? Feel especially weak on understanding analytics. Course recommendations? I have strong journalism background. Write, shoot, direct and edit.

like

If one Organization HR told me we will blacklist you. So I want to know exactly they can do blacklist or just showing fear of Blacklist ?

Actually I had one offer of 13 lacs my company retained me with 14 lacs, I didn't want to Re negotiate with that Organization because of Loyalty issue with current organization. So That Company HR scold on me and told me we will blacklist you.

Please Guide, is it true, I will be blacklisted?

Organization is World largest petrochemical refinery.

like

LTI is Hiring....!!!

PAN India....!!

Need immediate joiners preferred within 30 days.....!!!!!

If anyone interested Please DM me or share resume to
gupta67222@gmail.com

Senior Specialist - Data Engineering(Nifi, Bigdata) :- 8 to 15 yrs

Sr Engineer /Specialist (Bigdata – Hadoop Admin ) :- 5 - 10 yrs

Bigdata Consultant(Pyspark /Spark-Java/Spark-Scala) :-3-16 Yrs

like

Many openings in McKinsey. DM me for referrals.

like

Tata Consultancy Legato Mainframe openings

Dear fishes, We are looking for acquaintances for filling up pending roles Legato.  

Location : Bengaluru/Hyderabad/Gurugram
Good communication skills; Ability to work 12 pm – 9 pm;  24 * 7 support/flexibility for Prod Support associates are basic expectations apart from Technical proficiency.  

Mainframe SE/SSE Roles – Prod Support & AM team
Good to have IMS DB 
Good to have Healthcare Exp

Amdocs HCL Technologies Infosys IBM DXC Technology Deloitte Tata Consul

like

Can anyone refer me for Oracle SQl Developer role ? Currently serving notice Period. Having totally 10 years of exp and relevant experiance in SQL is 3 years.

like

Is capgemini hiring for Governance, risk and compliance domain?

What is the difference in subscription to notified and subscription to approved mutual funds?

like

What would be the inhand sal. for below structure.

TIA

Post Photo
like

Additional Posts in Excel Genius

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Any book recommendations on excel modeling for real world business applications?

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Would anyone be willing to teach me vlookup?

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Anyone know what these badges are?

Post Photo
likefunny

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal