Topics Search

Access 2010 Getting Started in Access

Access 2010 Getting Started in Access
Views: 32
In this lesson, you will familiarize yourself with the Access environment, including the Ribbon, the Backstage view, the Navigation Pane, the Document Tabs bar, and the Record Navigation bar. You will also learn how to navigate with a navigation form, if your database includes one.
Sponsored Links:

More topics

 

Access 2010 User Groups

Preview
I have recently started to build a new database using Access 2010 and have now found that the UserGroups have been taken away, and I was wondering if there is a way to set permissions from a table to allow certain users access to certain parts of the database, mostly all form access and then run reports.

Does anyone have an ideas and possible sample they might share to get me going.
 

Access 2010 adp bugs

Preview
I had a working adp that started life in Access 2003, was successfully upgraded to Access 2007, and has now been "upgraded" to Access 2010. A number of issues have arisen, all of which seem like Access 2010 bugs to me.

The Access 2007 version and the Access 2010 version are both connecting to the same SQL Server 2008 database. The issues only exist in Access 2010.

* A form which used Me.OrderBy to sort the recordsource crashed Access 2010 after working fine in Access 2003 and 2007.
* Settings for a form's InputParameters which worked fine in Access 2003 and 2007 now crashed Access 2010.
* Access 2010 incorrectly decided that a foreign key id field in a form "cannot be updated because it is an autonumber". In this particular case, the problem does NOT occur if the record source is "Select P.* From dbo.Payment P", which is the table containing an actorID foreign key.
 

Access 2010 auto insert from field above issue

Preview
I have just upgraded to office 2010 and I have noticed that in my Access Database, that it no longer auto inserts the next value in sequence in a column of records -

I am a basic user - no programming involved.

Basically, prior to Access 2010 if I had a entered information via a query, and one of the columns was a blank field. If I started the 1st record with say 101 and then cursored down to the same field in the next record and entered 102, a further scroll down would automatically add 103 and so forth.

Access 2010 does not perform this natively - and I have been using Access since Version 1 and it is the 1st time I have come across this.

I could not locate anything in the (very limited) Access Help and I cannot explain why this has changed.
 

Object spacing tools broken in Access 2010

Preview
I have recently installed and started using access 2010. So far I like it a great deal better than 2007, however I encountered a pretty nasty problem. When designing my forms, I rely heavily on the Size/Space tools to organize and align my objects. The spacing tools however seem to be broken, particularly the Horizontal once. In access 2007, I could select a number of controls, hit Equal Horizontal, and have the horizontal distance between the objects the same. Then I would use Increase/Decrease Horizontal to further tweak it. In Access 2010, none of this seems to work. Can anybody using Access 2010 confirm that this is indeed a bug, and if so what are some potential workarounds
 

Saving Access 2010 database to Access 2007

Preview
I started database in Access 2007, then I upgrade my Office to 2010. Now my upgraded database doesn't work in Access 2007. And what is worse, there is no option in 2k10 to save "in Access 2k7 mode"
 

Access 2007 or 2010 Trial Download.

Preview
Have tried to find a 2007 or 2010 Microsoft Access download trial edition, but no luck, I have two computers, one with IE and the other has WIN 7 64 Bit. I went to Microsoft links and tried one to get Access 2007, but it sent me to a 2010 Office download link.

I just need a 2007 or 2010 edition so I can try it out and then buy it if it suits my needs. executeable file download and a microsoft product key so I can get started.
 

Access 2007 reading Access 2010 DB

Preview
I started working on a database with Access 2007. My office 2007 got corrupted and my IT department installed office 2010 on my computer. I continued to work on the database in 2010. When I went to use someone else computer whom has 2007 I a database engine error message that " a minimum required version to read the data is 14.0.0000.0000
 

Access 2010 - runtime error 3170 Could not find installable ISAM

Preview
I am running Office 2010 under Windows XP SP3 and I am getting the above error while exporting data from Access to Excel via a VBA routine. It worked fine in Access 2000 but since upgradingto Access 2010, I have started to get the erro "Could not find installable ISAM".

I am using a statement that starts DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3

If I change it to acSpreadsheetTypeExcel5 (or later) then it works fine but 3 or 4 brings up the installable ISAm error.
 

Access 2010 stability

Preview
We are trying to decide between reworking our FE/BE Access 2002/2003 database in Access 2010 or SQL backend and Access front end. My prior experiences with Access 2002 was when the database bloated to about 100mb, it started having problems corrupting records and became unstable.

I spoke with a gentleman the other day that stated Access 2010 is much more stable at larger sizes than prior versions. We are not running millions of records. Right now our database is fine but we have changed how we analyze data and some of the work previously done outside the database will now be done inside the database increasing the number of records significantly.

My concern is we put in a bundle of time now and in a year or so the database becomes unstable and we then need to migrate to SQL Server
 

How create query in SQL in Access 2010

Preview
I just started using Access 2010 and so far I hate it with a passion. Why did they have to completely change the user interface? How do I create or update a query in SQL mode. I don't see any option to do that.