在前端应用程序和后端表中 [英] in front end application and back end tables

问题描述

嘿，


我想构建一个拥有前端应用程序和后台表格的数据库。我是新手，我所有的知识都来自

访问傻瓜。任何人都可以告诉我哪里可以找到关于这个主题的信息吗？我应该使用宏来设置前面的应用程序，或者我可以通过GUI将其删除。我有一本大书

运行窗口95的访问权限用手，但不确定哪一章

将解决我的问题。任何评论都很好。


非常感谢！

Min

Hey,

I want to build a database which has an in front end application and
back end tables. I am new to access, and all my knowledge is from
Access for Dummies. Could any one give me a clue where to find
information regarding this topic? should I use macro to set up in front
end application or I could get it down by the GUI. I have a big book
"Running Access for Window 95" by hands, but not sure which chapter
will solve my problem. Any comments are well comes.

Thank you very much!
Min

推荐答案

这是我要做的：转到工具，数据库实用程序，数据库

Splitter并按照说明操作。希望这会有所帮助！

Here''s what I would do: Go to Tools, Database Utilities, Database
Splitter and follow the instructions. Hope this helps!

首先打开一个空白的Access文件，然后输入所有表格和所有

关系。完成后，您有后端应用程序。

保存此文件。现在打开一个新的空白Access文件，然后转到

数据库窗口中的表。点击菜单中的文件 - 获取外部数据 - 链接表

在屏幕顶部。导航到后端文件并选择它。点击

链接。单击全选。单击确定。您现在已经链接到

后端文件中的所有表。您将在表格列表中看到

左侧的箭头每个表名称表明它是一个链接表。完成后，你

有你的前端文件。您可以保存或开始创建查询

表格和报告然后保存。


-

PC数据表

您的资源以获取Access，Excel和Word应用程序的帮助
re ****** @ pcdatasheet.com
www.pcdatasheet.com


如果您无法在新闻组中获得所需的帮助，我可以帮助您支付非常合理的费用。超过1000名访问用户来找我寻求帮助。

需要一个月历或7天日历吗？需要预约安排？需要

房间预订安排？需要员工的工作安排？联系我！


" Mindy" <毫安************ @ yahoo.com>在消息中写道

news：11 ********************* @ o13g2000cwo.googlegro ups.com ...

Start by opening a blank Access file and enter all your tables and all the
relationships. When this is completed, you have your backend application.
Save this file. Now open a new blank Access file and go to Tables in the
database window. Click on File - Get External Data - Link Tables in the menu
at the top of the screen. Navigate to your backend file and select it. Click
Link. Click Select All. Click OK. You have now linked to all the tables in
the backend file. You will see in the list of tables an arrow on the left of
each table name indicating it is a linked table. When this is completed, you
have your frontend file. You can save it or start creating your queries
forms and reports and then save it.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

If you can''t get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

"Mindy" <ma************@yahoo.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

嘿，

我想建立一个有前端应用程序和后端表的数据库。我是新手，我所有的知识都来自
Access for Dummies。谁能给我一个线索，在哪里可以找到有关这个主题的信息？我应该使用宏来设置前端应用程序，还是我可以通过GUI将其删除。我有一本大书
Running Access for Window 95用手，但不确定哪一章将解决我的问题。任何评论都很好。

非常感谢！
Min

Hey,

I want to build a database which has an in front end application and
back end tables. I am new to access, and all my knowledge is from
Access for Dummies. Could any one give me a clue where to find
information regarding this topic? should I use macro to set up in front
end application or I could get it down by the GUI. I have a big book
"Running Access for Window 95" by hands, but not sure which chapter
will solve my problem. Any comments are well comes.

Thank you very much!
Min

PC数据表 <无**** @ nospam.spam>在消息中写道

新闻：Ks ***************** @ newsread2.news.atl.earthl ink.net ...

"PC Datasheet" <no****@nospam.spam> wrote in message
news:Ks*****************@newsread2.news.atl.earthl ink.net...

-
PC数据表
您的资源以获取Access，Excel和Word应用程序的帮助
re******@pcdatasheet.com
www.pcdatasheet.com

给阅读此消息主题的任何人快速记录。这个新闻组是获得Access项目帮助的优秀资源。但是，如果你觉得需要寻求专业帮助，我强烈建议你不要考虑雇用这个PC数据表字符。史蒂夫是一个聪明的孩子，但是完全不专业的是b $ b。有数百名称职的Access

顾问可供选择。许多人经常在这个新闻组中发帖，其他人可以通过谷歌搜索或访问guru.com轻松找到他们的b $ b。

A quick note to anyone reading this message thread. This newsgroup is an
excellent resource for getting help with your Access projects. If you feel
the need, however, to seek professional help, I strongly advise that you not
consider hiring this PC Datasheet character. Steve is a bright kid but is
totally unprofessional. There are literally hundreds of competent Access
consultants available. Many post regularly in this newsgroup, others can
easily be located by googling or visiting guru.com.

这篇关于在前端应用程序和后端表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！