Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

Randip has attended:
Access Introduction course

Access 2003

Can existing data be transferred from Excel files into Access format for use with Forms, Queries and Reports.

RE: Access 2003

Hello Randip

Thank you for your question and welcome to the forum.

You can import data from Excel into Access if you go to File - Import External Data - Import, then change the Files of type option at the bottom of the dialogue box to Microsoft Excel.

Amanda

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.