《Total Training Microsoft Access 2007 基础教程》(Total Training Microsoft Access 2007 Essentials)[ISO]中文名: Total Training Microsoft Access 2007 基础教程英文名: Total Training Microsoft Access 2007 Essentials资源格式: 光盘镜像发行日期: 2007年地区: 美国对白语言: 英语简介:截图为真实视频截图.Title: Microsoft Access 2007 EssentialsCategory: Communication & Office ToolsPresenter: Jeff ConradJeff Conrad is a technology enthusiast with many years of database application development expertise. Jeff began working with Microsoft Access when he saw a need at his full time position for a database solution. He bought a book on Access and began teaching himself how to use the program to solve his business’s needs. He immediately became hooked on the power and ease of working with Access. Years later, Jeff is co-author of Microsoft Office Access 2007 Inside Out and is a contributing author of Microsoft Office 2007 Inside Out. Jeff was awarded the Most Valuable Professional award from Microsoft from 2005 to 2007 for his continual involvement with the online Access community.Platform: Windows & MAC OSFormat: OnlineLevel: Beginner to IntermediateDescription: Explore the endless capabilities of Access 2007. These lessons, hosted by Jeff Conrad begin with a solid introduction of Access and cover topics such as defining a database, knowing when to use Access, working with database objects, and converting older databases. Once you're up to speed on the intricacies of Access, Jeff walksyou through step-by-step procedures on how to construct your table structures, create and adapt meaningful data entry forms, as well as share tracked information with others through reports.unning Time: 6.6 HrsProject Files: IncludedHighlights* Learn how to build new data entry forms and reports at the click of a button with the help of new Quick Create commands in Access 2007. You can then use these forms and reports as is, or modify them to your liking.* Try out the new built-in Date Picker control which can be used for any date fields. Explore how to enter a date into a field on datasheets, forms, or reports - no coding required.* Discover how to save valuable development time with the new Layout view in Access 2007. This cool new feature allows you to design your forms and reports while viewing live data. You can quickly resize, move, and align your controls without having to constantly switch between views.* Let Jeff show you how to use the new Report view, to dynamically filter the data and drill down to print only the information you need. The traditional Print Preview view is a static snapshot of your data that you view or print.* Find out how to make your data pop on screen with a "Greenbar Effect" by using the new Alternating Background Color button. Your data has never been easier to read on screen or in printed form.Lesson 1: INTRODUCING ACCESS 2007 (17 min)1. Defning a Database2. Knowing When to Use Access™3. Working with Database Objects4. Converting Older DatabasesLesson 2: EXPLORING THE NEW USER INTERFACE (84 min)1. Exploring the Getting Started Screen2. Opening a Microsoft Template3. Using the Navigation Pane4. Using the Home Tab, Part 15. Using the Home Tab, Part 26. Using the Create Tab7. Using the External Data Tab8. Using the Database Tools Tab9. Using the Office Menu10. Explaining the Access Options11. Using the Quick Access Toolbar12. Adding Custom Commands to the Quick Access Toolbar13. Using the Help Menu14. Understanding the Message Bar15. Creating Trusted Locations16. Working in the Object WindowLesson 3: WORKING IN THE NAVIGATION PANE (45 min)1. Displaying Categories2. Showing Views3. Sorting the Objects4. Searching for Objects5. Collapsing Groups6. Creating Custom Groups7. Adding Object Shortcuts8. Hiding Custom Groups9. Changing the Interface Mode10. Final Comments & CreditsLesson 4: CREATING TABLES (67 min)1. Explaining the Datasheet Tab2. Entering Data in a New Table3. Using a Table Template4. Identifying the Entities5. Working with Design View6. Creating DataTypes7. Using Field Validation Rules8. Dening Primary Keys9. Adding Indexes10. Working with Table Relationships11. Creating Table Relationships12. Dening Multi-Value Field LookupsLesson 5: CREATING QUERIES (50 min)1. Creating a Select Query2. Using Expressions in a Query3. Sorting Data4. Searching for Data5. Selecting Data from Many Tables6. Working in Layout View7. Working in SQL View8. Creating a Crosstab Query9. Running Action Queries10. Running Update Queries11. Using the Query WizardLesson 6: CREATING FORMS (48 min)1. Using Quick Create Commands2. Exploring Form Types3. Navigating within Forms4. Using the Form Wizard5. Creating a Form from Scratch6. Working in Layout View7. Working in Design View8. Setting Form Properties9. Using Form Controls10. Using Control Layouts11. Applying AutoFormats12. Understanding SubformsLesson 7: CREATING REPORTS (57 min)1. Using the Report Command2. Running the Report Wizard3. Exploring Report Views4. Creating a Report from Scratch5. Using Conditional Formatting6. Grouping & Sorting7. Setting Report Properties8. Detailing Your Report9. Applying AutoFormats10. Adding Subreports11. Alternating Record Colors12. Filtering in Report View13. Creating LabelsLesson 8: CREATING MACROS (26 min)1. Working in Macro Design Mode2. Assigning Macro Actions3. Setting Macro Arguments4. Running an AutoExec Macro5. Creating Embedded Macros6. Final Comments & Credits共分八章MOV格式视频文件/topics/203869/。
Access 2007 入门第一次使用AccessOffice Access 2007 提供了很多的改进，这些改进使创建数据库的过程变得比过去更容易。
以前在Access 中创建过数据库的用户将会很欣喜地发现，这些新增功能和改进功能显著加快了数据库的创建过程。
启动Office Access 2007 时，出现的第一个屏幕是“开始使用Microsoft Office Access”页（除非通过双击具体的Access 数据库文件来启动Access，这种情况下将直接打开数据库）。
从“开始使用Microsoft Office Access”页开始，可以创建新的数据库、打开现有数据库或者查看来自Microsoft Office Online 的特色内容。
使用模板创建数据库从头开始创建数据库将数据从另一个源粘贴到Access 表中从其他源导入数据打开现有的Access 数据库使用模板创建数据库Access 提供了种类繁多的模板，使用它们可以加快数据库创建过程。
模板是随即可用的数据库，其中包含执行特定任务时所需的所有表、查询、窗体和报表。
例如，有的模板可以用来跟踪问题、管理联系人或记录费用；有的模板则包含一些可以帮助演示其用法的示例记录。
模板数据库可以原样使用，也可以对它们进行自定义，以便更好地满足需要。
1. 启动Access（如果未运行）。
如果已经打开数据库，请执行以下操作显示“开始使用Microsoft Office Access”页： 单击“Microsoft Office 按钮”，然后单击“关闭数据库”。
2. “开始使用Microsoft Office Access”页中的“特色联机模板”下面将显示若干模板。
如果在Access 窗口左侧的“模板类别”下单击某一类别，会出现更多的可用模板。
还可以从Microsoft Office 网站下载更多模板（有关详细信息，请参阅下一节从Microsoft Office Online 下载模板）。
Access 2007 入门第一次使用 AccessOffice Access 2007 提供了很多的改进，这些改进使创建数据库的过程变得比过去更容易。
以前在Access 中创建过数据库的用户将会很欣喜地发现，这些新增功能和改进功能显著加快了数据库的创建过程。
启动Office Access 2007 时，出现的第一个屏幕是“开始使用Microsoft Office Access”页（除非通过双击具体的Access 数据库文件来启动Access，这种情况下将直接打开数据库）。
从“开始使用Microsoft Office Access”页开始，可以创建新的数据库、打开现有数据库或者查看来自Microsoft Office Online 的特色内容。
使用模板创建数据库从头开始创建数据库将数据从另一个源粘贴到Access 表中从其他源导入数据打开现有的Access 数据库使用模板创建数据库Access 提供了种类繁多的模板，使用它们可以加快数据库创建过程。
模板是随即可用的数据库，其中包含执行特定任务时所需的所有表、查询、窗体和报表。
例如，有的模板可以用来跟踪问题、管理联系人或记录费用；有的模板则包含一些可以帮助演示其用法的示例记录。
模板数据库可以原样使用，也可以对它们进行自定义，以便更好地满足需要。
1. 启动Access（如果未运行）。
如果已经打开数据库，请执行以下操作显示“开始使用Microsoft Office Access”页：▪单击“Microsoft Office 按钮”，然后单击“关闭数据库”。
2. “开始使用Microsoft Office Access”页中的“特色联机模板”下面将显示若干模板。
如果在Access 窗口左侧的“模板类别”下单击某一类别，会出现更多的可用模板。
还可以从Microsoft Office 网站下载更多模板（有关详细信息，请参阅下一节从Microsoft Office Online 下载模板）。
关于access2007教程
你了解access内容有哪些?本文就是关于access2007教程方面的知识，希望给您提供不一样的收获。
一、Access 2007布局介绍
1
Access2007功能布局。
1为功能区，2为快速访问工具栏，3为Office按钮，4为导航窗格。
导航窗格仅显示数据库中您正在使用的内容。
表、窗体、报表和查询都在此处显示，使您在工作时更加方便。
2
功能区的设计以您的工作为核心，其中Access 各个工具和各项功能的位置一目了然，省去了在程序中四处搜寻的烦恼。
这一切将使工作更加高效。
每个功能区选项卡都按照一个常见的活动进行组织，并包含执行该活动所需的各项命令。
这些命令组成多个逻辑组。
所有命令不仅易于查找，还易于使用。
功能区是在Access 2007中工作时的命令中心。
