Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Access 2007 Newby Question

29 Sep 2014   #1
gplea

Win7 64Bit Enterprise
 
 
Access 2007 Newby Question

If I was to create a CRM D'base, or just a nice Contact D'base, what would happen if I tried to import data from 2 different spreadsheets that may have some dups in it? Be nice please. I've hardly EVER worked with Access, so I scant hardly know what I'm doing.

Thanks,
GPLea


My System SpecsSystem Spec
.
29 Sep 2014   #2
strollin

W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit)
 
 

You can have duplicates in a database as long as the particular field where the duplicate appears is not designated as unique. For instance, you might have a field named CustomerId which would be designated as a unique field because you want to be able to uniquely identify that customer but the CompanyName field would not be set to unique because you could have more than 1 Company named Acme.

If you were to import records from different sources, you could have duplicates so you would want to clean out the duplicates before setting any fields to unique. If there are duplicates in the field you attempt to set as unique, it won't work until you clean up all duplicates.
My System SpecsSystem Spec
29 Sep 2014   #3
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Access is a very good Database, but it does take some getting accustomed to it & the way it works.
I always think the most important thing is to get your Tables set up exactly how you want them. This often takes trial & error, so you may have to start again a few times to get it right, but don't get put off.
Don't delete your spreadsheets until you get Access set up the way you want it as you may decide to redo it & still want to have the original data available.
Are the spreadsheets you will be using Excel, or another spreadsheet. Have a look at what you have in the spreadsheets for layout & apply that order & layout for your Table in Access, if that is how you would like it.
As strollin has suggested it would be best to remove any duplicates from your spreadsheets.

You may find this MS website helpful in getting to know Access. Scroll right down & you will see a section "That's not All" that has a link for demo videos on Access.

Access 2007 training courses - Training
My System SpecsSystem Spec
.

30 Sep 2014   #4
gplea

Win7 64Bit Enterprise
 
 

Thanks Guys. I WILL visit that site. So, to specify my question a little more. I saw where it asks me what I want to do with dups. My question is if I do have dupes, what does it do with them if I say NOT to accept dupes. 2.) I know I'm going to have to do some subsequent imports for additional records, and since it's not a cloud-based app, I can't share the d'base, so how would you suggest that I proceed with that process? My initial thought is to take input the records on the spreadsheet according to alphabetical order, and only input from say A-F, then, G-L, and so forth. That way there's should be no chance of dupes, and at least we can check the spreadsheet much more easily for dupes. To that end, if I make the spreadsheets as alphabetically described, should they be complete separate files, or if they're the same file, just different sheets, will Access prompt me for the correct sheet I want to import?

Finally, here's a tougher question. So, my 1st Primary Keys are names of churches. Now, many of these churches have multiple campi (campuses) that operate under their authority. So, I don't have a CLUE as to how to set that up as a parent/child relationship for the single user that will actually be using the d'base.

Thanks,
GPLea
My System SpecsSystem Spec
30 Sep 2014   #5
strollin

W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit)
 
 

If you specify NOT to accept dups then it will skip over duplicates, leaving them in the original file.

I don't understand your thinking with importing A-F then G-L as that should have no effect on duplicates. Wouldn't a duplicate sort alphabetically so that the duplicates show as subsequent rows?

As far as churches with multiple campuses, you will need to have an additional field to name the campus so a record would include both the church name and it's campus. DB design can get quite complex, there are many ways to do it including using multiple tables. If you design queries and reports correctly, the user of the db application will not need to understand the parent/child relationship of the church to it's campuses. The user should only need to run the report or query you provide to be able to get the info needed.

You need to design a db app for the level of expertise of the user. If they are knowledgeable, then they can write their own queries, otherwise they depend on what is provided to them.
My System SpecsSystem Spec
30 Sep 2014   #6
gplea

Win7 64Bit Enterprise
 
 

Thanks again, Strollin. My objective/concern with the separate sheets is if I don't separate them alphabetically, then when I import say G-L, but I still have the A-F data in that spreadsheet then there will surely be dupes. If I separate the data into separate sheets, I'm assured that won't happen. Correct?

As for the multiple campi issue, this sounds like a silly question I guess, but how would I Google that issue, or look it up in the Help file?

Thanks Again,
GPLea
My System SpecsSystem Spec
30 Sep 2014   #7
strollin

W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit)
 
 

Maybe start here: Design tables for a new Access 2007 database - Training

(Sorry - Just noticed this link is included in the link provided by Ranger4 above)
My System SpecsSystem Spec
Reply

 Access 2007 Newby Question




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Hello there from a newby
You have probably been told of what a useful place this is. I do want to join those and sincerely say that your forum has helped me solve problems that others could not solve or maybe they went around in circles talking much and saying nothing. I am sooooooooo happy I found you. As you can tell,...
General Discussion
Any problems using Access 2007 database with Access 2010?
According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes? So why do I have the feeling that something is not going to work? Is it because I have...
Microsoft Office
Cannot access the Ribbon functions in Excel 2007 or Word 2007
I have Office 2007 on Windows 7. When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen). If, I switch to another open sheet/doc and then switch back the ribbon is accessible again! I have...
Microsoft Office
Access 2007
I've been testing Windows 7 at my work for a few weeks now and I've run across an Access 2007 issue that I can't resolve. It happens when I open an Access database and it comes back with this error, "The table is already opened exclusively by another user, or it is already open through the user...
Microsoft Office
New but not a newby; question about memory usage
I've been working with different types of computers since 1966. I've built many of my own systems and now I have a rather large system running Win7 Pro As it shows in my sig, I have a 2 x quad-core system with 16 gig registered RAM. I've noticed in Resource Monitor it seems to only use 8 gig...
Performance & Maintenance


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 15:12.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App