课程: Access 2016 Essential Training
今天就学习课程吧!
今天就开通帐号,24,700 门业界名师课程任您挑!
Creating macros
- Macro objects allow you to create a series of actions that you would like to automate. When the macro is triggered, Access runs through the steps and performs the tasks for you. There's lots of uses for macros in your access database, and to get started, we're going to set one up that opens several objects for us without having to go to the navigation pane. This is going to be my I just got to work macro, and it allows us to quickly pull up the reports and forms that we need to start the day. In order to create a new macro, we'll come up here to the create tab, and then over on the far right hand side in the macros and code group, you'll find a button called macro. When you click on it, it opens up a new macro and the design editor for it. Here in the middle portion of the screen, you have a drop down list, and when we open that up, you'll see all the different steps that we can include in our macro. This macro is going to open up a couple of items, so I'm going to scroll through…
随堂练习,边学边练
下载课程离线学习
内容
-
-
Key database concepts4 分钟 14 秒
-
(已锁定)
Launching Access and the backstage screen54 秒
-
(已锁定)
Creating the database file4 分钟 6 秒
-
(已锁定)
Understanding the Trust Center3 分钟 28 秒
-
(已锁定)
Digging into Ribbon tabs5 分钟
-
(已锁定)
Using the Navigation pane4 分钟 47 秒
-
(已锁定)
Using the Tell Me feature1 分钟 47 秒
-
(已锁定)
Using the Quick Access Toolbar3 分钟 3 秒
-
(已锁定)
Signing in to a Microsoft account1 分钟 33 秒
-
(已锁定)
Making backups2 分钟 14 秒
-
(已锁定)
Accessing Access help2 分钟 15 秒
-
-
-
Establishing relationships and maintaining referential integrity6 分钟 15 秒
-
(已锁定)
Editing table structure in Design view4 分钟 52 秒
-
(已锁定)
Controlling input with masks6 分钟 9 秒
-
(已锁定)
Setting the default value2 分钟 35 秒
-
(已锁定)
Establishing validation rules4 分钟 6 秒
-
(已锁定)
Creating lookup fields3 分钟 51 秒
-
(已锁定)
Setting additional field properties5 分钟 12 秒
-
(已锁定)
Challenge: Creating tables44 秒
-
(已锁定)
Solution: Creating tables5 分钟 50 秒
-
-
-
(已锁定)
Understanding queries3 分钟 10 秒
-
Creating queries with the Simple Query Wizard3 分钟 58 秒
-
(已锁定)
Building queries in Design view9 分钟 23 秒
-
(已锁定)
Establishing constraints with criteria5 分钟 28 秒
-
(已锁定)
Specifying criteria with wildcards4 分钟 16 秒
-
(已锁定)
Leveraging multiple criteria with AND and OR statements6 分钟 7 秒
-
(已锁定)
Filtering with mathematical comparisons3 分钟 41 秒
-
(已锁定)
Creating flexible queries with parameter requests5 分钟 7 秒
-
Building expressions7 分钟 26 秒
-
(已锁定)
Obtaining summary statistics7 分钟 3 秒
-
(已锁定)
Challenge: Creating queries42 秒
-
(已锁定)
Solution: Creating queries4 分钟 38 秒
-
(已锁定)
-
-
(已锁定)
Using update queries6 分钟 44 秒
-
(已锁定)
Using make table queries3 分钟 33 秒
-
(已锁定)
Finding unmatched records4 分钟 3 秒
-
(已锁定)
Using delete queries4 分钟 13 秒
-
(已锁定)
Using append queries3 分钟 50 秒
-
(已锁定)
Creating a union query in SQL view5 分钟 27 秒
-
(已锁定)
Getting a different look with crosstab queries3 分钟 19 秒
-
(已锁定)
-
-
(已锁定)
Creating forms in Design view4 分钟 29 秒
-
(已锁定)
Exploring the form property sheet4 分钟 55 秒
-
(已锁定)
Setting data sources6 分钟 8 秒
-
(已锁定)
Adding components with form controls11 分钟 28 秒
-
(已锁定)
Understanding input boxes5 分钟 24 秒
-
(已锁定)
Record navigation4 分钟 2 秒
-
(已锁定)
Adding buttons4 分钟 21 秒
-
(已锁定)
Assigning a tab order4 分钟 36 秒
-
(已锁定)
Checking out the More Forms options5 分钟 57 秒
-
(已锁定)
Creating a navigation form4 分钟 25 秒
-
(已锁定)
Challenge: Creating forms46 秒
-
(已锁定)
Solution: Creating forms4 分钟 29 秒
-
(已锁定)
-
-
(已锁定)
Introducing reports4 分钟 19 秒
-
(已锁定)
Using the Report Wizard4 分钟 53 秒
-
(已锁定)
Creating a report in Design view4 分钟 38 秒
-
(已锁定)
Editing a report in Layout view7 分钟 51 秒
-
(已锁定)
Grouping and sorting records7 分钟 7 秒
-
(已锁定)
Creating calculated totals3 分钟 52 秒
-
(已锁定)
Applying conditional formatting rules7 分钟 36 秒
-
(已锁定)
Creating labels5 分钟 21 秒
-
(已锁定)
Adjusting print settings4 分钟 6 秒
-
(已锁定)
Challenge: Creating reports33 秒
-
(已锁定)
Solution: Creating reports5 分钟 29 秒
-
(已锁定)
-
-
(已锁定)
Organizing the Navigation pane with custom groups3 分钟 33 秒
-
(已锁定)
Compacting and repairing the database1 分钟 19 秒
-
(已锁定)
Examining database object dependencies2 分钟 58 秒
-
(已锁定)
Documenting your work4 分钟 11 秒
-
(已锁定)
Printing the blueprint of your database with the Database Documenter2 分钟 33 秒
-
(已锁定)
Splitting a database into front and back ends4 分钟 4 秒
-
(已锁定)
Protecting the database with a password3 分钟 9 秒
-
(已锁定)
Creating custom Ribbon tabs2 分钟 57 秒
-
(已锁定)
Setting startup options and custom icons4 分钟 5 秒
-
(已锁定)