Unofficial Access Stuff

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Saturday, October 14, 2017 – Permalink –

Hardcopy Relationships

Document database

When you're documenting your database applications, you may want to include the same visual diagram of your table relationships that's available through the Relationships window.
In Access 2000 thru 2003, this is easy. Simply display the Relationships window as usual and then choose File>Print Relationships from the menu bar. Doing so displays a report preview that you can then print or save.

In 2007-13, to just print out a report, find Database tools on the Ribbon and click on Database Documenter.

Relationships are at the bottom of the All Object Types tab

See all Topics access
Labels: Customize, General, Properties, Reference, Relationships, Tips, Tutorials

<Doug Klippert@ 3:17 AM

Comments: Post a Comment

Thursday, May 04, 2017 – Permalink –

Define Relationships by Keyboard

It's not a drag

If you've played with Access, you know that you can create relationships by dragging fields from one table to another.

There is another way to do it using just the keyboard.

I don't know why you would do it this way, but let's assume you lent your mouse to your brother-in-law for the week-end. (?)

Close any open tables.

Use F11 to switch to the Database window.

Press ALT+T to select the Tools menu, and then press R to open the Relationships window.

If the Show Table dialog box does not appear, press ALT+R to select the Relationships menu, and then press T to open the Show Table dialog box.

In the Show Table dialog box, select the first table that you want to relate, and then press ENTER to add it to the Relationships window.

Repeat step 5 for any other tables you want to relate, and then press ALT+C to close the Show Table dialog box.

Press ALT+R to select the Relationships menu, and then press R to open the Edit Relationships dialog box.

Press ALT+N to open the Create New dialog box.

In the Left Table Name box, select the name of the table that contains the primary key.

In the Right Table Name box, select the name of the table that contains the foreign key.

In the Left Column Name box, select the primary key field, and in the Right Column Name box, select the foreign key field.

Press ENTER.

In the Edit Relationships dialog box, use the arrow keys to make sure that the two columns contain the field names you want.

Press ALT+C to create the relationship.

Support.Microsoft.com:
Define relationships by using the keyboard

See all Topics access
Labels: General, Properties, Relationships, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:20 AM

Comments: Post a Comment

Thursday, January 14, 2016 – Permalink –

Relationships

How it all ties together

"Find out how to reap the benefits of data normalization in Access while ensuring that your system provides users with all the information they need. Learn to relate your application's tables to each other, so that your users can view the data in the system as a single entity. After you define relationships between tables, you can build queries, forms, reports, and data access pages that combine information from multiple tables."

Relationships: Your Key to Data Integrity in Access

An article from Informit.com and Alison Balter.

Alison is the founder of InfoTechnology Partners, Inc., a computer consulting firm in California. She is a highly experienced trainer and consultant, specializing in Windows applications.

See all Topics access
Labels: General, Relationships, Tips, Tutorials

<Doug Klippert@ 3:00 AM

Comments: Post a Comment