Access Inquires

%3CLINGO-SUB%20id%3D%22lingo-sub-1628756%22%20slang%3D%22en-US%22%3EAccess%20Inquires%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1628756%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20a%20couple%20of%20issues%20with%20Access.%26nbsp%3B%20When%20I%20import%20an%20excel%20file%20all%20the%20data%20does%20not%20transfer%20into%20Access.%26nbsp%3B%20In%20addition%2C%20how%20do%20I%20add%20formulas%20to%20calculate%20percentages%2Ftotals%20in%20columns.%26nbsp%3B%20Lastly%2C%20are%20there%20any%20add-ons%20to%20Access%20or%20links%20that%20are%20recommended%20for%20Access.%26nbsp%3B%20Thank%20you%20in%20advance%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1628756%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1632601%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Inquires%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1632601%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F779941%22%20target%3D%22_blank%22%3E%40acarey5%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20regard%20to%20your%20first%20problem.%20Remember%2C%20we%20do%20not%20have%20visibility%20to%20your%20computer%2C%20so%20we%20can't%20guess%20what%20might%20be%20happening%20(or%20not%20happening).%20It's%20up%20to%20you%20to%20provide%20adequate%20details%20to%20make%20the%20problem%20clear.%3C%2FP%3E%3CP%3ESecond%2C%20Access%20is%20a%20tool%20for%20creating%20relational%20database%20applications.%20You%20can't%20treat%20it%20the%20same%20way%20you%20do%20an%20Excel%20spreadsheet.%20We%20discourage%20calculated%20columns%20in%20fields%20in%20tables%20in%20Access.%3CBR%20%2F%3EIf%20you%20need%20or%20want%20to%20display%20calculations%20using%20formulas%2C%20you%20can%20do%20that%20in%20queries.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThird%2C%20I%20am%20aware%20of%20a%20few%20add-ins%20for%20specific%20purposes%2C%20but%20there%20are%20none%20that%20are%20%22recommended%22%20for%20everyone%20or%20for%20all%20purposes.%20What%20do%20you%20have%20in%20mind%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am having a couple of issues with Access.  When I import an excel file all the data does not transfer into Access.  In addition, how do I add formulas to calculate percentages/totals in columns.  Lastly, are there any add-ons to Access or links that are recommended for Access.  Thank you in advance :)

1 Reply
Highlighted

@acarey5 

 

With regard to your first problem. Remember, we do not have visibility to your computer, so we can't guess what might be happening (or not happening). It's up to you to provide adequate details to make the problem clear.

Second, Access is a tool for creating relational database applications. You can't treat it the same way you do an Excel spreadsheet. We discourage calculated columns in fields in tables in Access.
If you need or want to display calculations using formulas, you can do that in queries.

 

Third, I am aware of a few add-ins for specific purposes, but there are none that are "recommended" for everyone or for all purposes. What do you have in mind?