Child ID Access

I have the Microsoft Access trial. I need to create a blank database in Microsoft Access for homework.

I open up Access, then I click "Blank Database." Then when I go to name it and click "Create" a window pops up and says, "The application is disabled, and databases may not be created."

Is this feature disabled in the trial? Or is there some other reason why it isn’t working for me?

You need to register the trial version. When you open it, you should get a prompt to register. Just register online and then everything will be unlocked.

For my DiDA, I created three reports on Microsoft Access (2007). The SPB says to include the three reports but not the database. How is this possible?

Do they mean for you to export the report into a pdf, html or text format? You can do this from the External Data tab, pdf format requires the installation of an add-in.

That’s the only way I can see how you could do this as the actual Access report relies on the data contained in your tables, queries, etc.

I’m a new Microsoft Access user, and my school is requiring me to build a database system in Access (with a switchboard and everything). I’ve done all of that, but the teacher wants the final project to be independent, i.e. converted/exported into an .exe file, so that it can opened without having to use Microsoft Access. Is that possible? And if so, how do I do it?

It can be done, but you’ll need to use the Microsoft Access Runtime. More info can be found here: http://office.microsoft.com/en-us/access/HA011208861033.aspx

The Data Analyst – http://www.squidoo.com/thedataanalyst

I want a business that I can store my stock records and make reports, is Microsoft Access the right one ? or I should go more complex and tell me about the capabilities of Microsoft Access for a small business.

Personally I’d use MySQL.

That being said, Access is a database + front end. It both stores data (such is the nature of a database), and also allows you to create forms and reports to edit and print the information in that database.

Access, to me, had the feel that it was rather clunky when you attempted to interact with it across a network. For example if your business has two cash registers, both might need to read/write to that same database. If memory serves, the only solution was using file sharing to share the MDB file. Whereas a "real" database allows for proper socket or TCP/IP connections.

Access’ advantage is that it dumbs down the database to make it easy to use for people who don’t know SQL (which isn’t overly difficult), and that it has a simple built-in functionality to forms and reports. The disadvantage is that it comes up short in every other respect.

The Macro Designer is a revamped editor that allows you to automate repetitive tasks; wire together forms and reports to create productive UI; and implement business logic in Access databases.

Duration : 0:3:57

(more…)

How to use Microsoft Access ( part 6 of 13 ) Sorting an Filtering Records

Duration : 0:3:34

(more…)

How to use Microsoft Access ( part 9 of 13 ) Using Data Forms

Duration : 0:3:32

(more…)

Here we create an Access label report from scratch

Duration : 0:3:46

(more…)

Learn how to put two text strings together into one query field using STRING CONCATENATION with this tutorial. Go to www.599CD.com/Access/YouTube for more free tutorials.

Duration : 0:5:0

(more…)

In this tutorial, I’ll show you how to take a table of people and relate it back upon itself. This technique is very useful for show a head-of-household and then all of the family members under him, OR even a geneaology database where you have people with mothers and fathers linked to the same types of records. This is part ONE of two.

Duration : 0:8:28

(more…)