slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Create your first Access 2013 database PowerPoint Presentation
Download Presentation
Create your first Access 2013 database

Loading in 2 Seconds...

play fullscreen
1 / 6

Create your first Access 2013 database - PowerPoint PPT Presentation


  • 214 Views
  • Uploaded on

Create your first Access 2013 database. In the message bar, click Enable Editing , . then press F5 or click Slide Show > From Beginning to start the course. . If the videos in this course don’t play, you may need to download QuickTime or just switch to PowerPoint 2013 . j.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Create your first Access 2013 database' - tarika


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Create your first Access 2013 database

In the message bar, click Enable Editing,

then press F5 or click Slide Show > From Beginning to start the course.

If the videos in this course don’t play, you may need to download QuickTime or just switch to PowerPoint 2013.

j

slide2

Create your first Access 2013 database

Closed captions

From here, you click the template that captures the kind of data you need to store.

If you're new to Access,

and you don't know how to design or build a database,

all you need to do is use a template.

Or, if you already have Access running, click File, and then New.

Give the database a name, choose a location if you want to, and click Create.

For example, if you need to manage asset data, click the Asset Tracking template.

When the template opens, click Enable Content, here.

This allows the database to run all of its features, and you only have to do this once.

Start Access, and it shows you the templates automatically.

You can watch a couple videos, or click links for more help.

From there, you just enter data, and press Tab, the arrow keys, or use your mouse to move to the next field.

Moving to another field also saves your data. You never have to save it yourself.

That's it. You don't need to know database design or change anything, but you may want to.

For example, this list probably isn't what you need. The text is pretty generic.

Some of the templates help you get started.

So to change it, click a cell. Not the header, an actual cell, then right-click and click Edit List Items.

Enter the text you want, click OK, and now your categories make sense.

This type of database is called a desktop database, and it only runs on your computer.

If you need a database that runs on the web, you create an Access App, and I'll show you how in the next video.

Press F5 to start, Esc to stop

1/2 videos

1

  • 2
  • 3

4

5

2:04

2:29

Help

Desktop

Cloud app

Feedback

Summary

slide3

Create your first Access 2013 database

Closed captions

Press Ctrl, click the labels, change their color, and align them to the right.

Click the one you want, enter a name, select a server from the list here,

When you need to let several people use a database at the same time, build an Access App.

Access Apps are web databases, they run in the cloud on most browsers,

and people can use your database, whenever they're connected to the internet or your corporate network.

The easiest way to do that is to use a template,

And you can tell it's an app template because of the globe icon.

Just remember, these need to be SharePoint 2013 servers, or you need Office 365.

or enter a server name here.

Access downloads and opens the template, and to start working, click Launch App.

That starts the database in your browser, and you can enter data.

and you can select one when you start Access, or when you click File, New.

The other thing to remember about Apps is you use them in your browser,

but you create and change them in Access.

To do that, click Customize in Access, click Open, and the file opens in Access.

You can see the ribbon is smaller than usual. It's only giving you the tools you need to work on Apps.

But remember that with an App, you have to click Save to save your data.

I'll open this form for editing—this is called Layout view—and make a quick change.

Click Save, and that publishes your changes to the server.

Now click Home, and Launch App.

There you go, two databases in minutes, and no need to change anything unless you want to.

Finally, the course summary has links to more about using and customizing templates.

Press F5 to start, Esc to stop

2/2 videos

1

  • 2
  • 3

4

5

2:04

2:29

Help

Desktop

Cloud app

Feedback

Summary

slide4

Help

Course summary—Create your first Access 2013 database

Course summary

Use a desktop template

  • Start Access and click any desktop template (they don't have the globe icon). If you have Access open, click File > New.
  • Enter a name, choose another location for the database if you want to, click Create.
  • In the yellow message bar, click Enable Content.
  • If the template has videos, watch them or close that window.
  • Enter data.
  • Press Tab or the arrows, or use your mouse to move to another field. Moving saves your data.

Change a template

To change a drop-down list, right-click a field in the list (not a header), click Edit List Items, enter your new items, click OK.

Use an Access App template

  • Start Access and click any app template (they have the globe icon). If you have Access open, click File > New.
  • Enter a name, choose a server from the list, or enter a server name, click Create.
  • Click Home > Launch App. The app opens in your browser.
  • Enter data, and click Save when done.

Change an Access App

  • In SharePoint 2013 or Office 365, click Settings > Customize in Access > Open. The database opens in Access, and the ribbon shows only the tools you need.
  • Change your database and save your changes. That publishes them to your server.
  • Click Home > Launch App to resume using your database.

See also

  • Use a template to create an Access database
  • Basic tasks for an Access 2013 desktop database
  • Create an Access App from a template
  • Basic tasks for an Access App
  • Modify an Access app
  • More training courses
  • Office Compatibility Pack

Press F5 to start, Esc to stop

1

  • 2
  • 3

4

5

2:04

2:29

Help

Desktop

Cloud app

Feedback

Summary

slide5

Help

Rating and comments

Course summary

How did we do? Please tell us what you think

Thank you for viewing this course!

Check out more courses

Press F5 to start, Esc to stop

1

  • 2
  • 3

4

5

2:04

2:29

Help

Desktop

Cloud app

Feedback

Summary

slide6

Help

Help

Course summary

Using PowerPoint’s video controls

Point at the bottom edge of any video to start, stop, pause, or rewind. You drag to rewind.

Stopping a course

If you’re viewing online, click your browser’s Back button. If you’re viewing offline, press Esc. If you’re watching a video, press Esc once to stop the video, again to stop the course.

Going places

You can go to any part of a course by clicking the thumbnails (light or shaded) below the video. You can also click the forward and back arrows, or press Page Up or Page Down.

If you download a course and the videos don’t play

Click Enable Editing if you see that button. If that doesn’t work, you may have PowerPoint 2007 or earlier. If you do, you need to get the PowerPoint Viewer. If you have PowerPoint 2010, you need the QuickTime player, or you can upgrade to PowerPoint 2013.

Press F5 to start, Esc to stop

1

  • 2
  • 3

4

5

2:04

2:29

Help

Desktop

Cloud app

Feedback

Summary