Microsoft Access 2013 : Basic Things You Need to Know

Create a Database :

1) Right after you start Microsoft Access 2013, this is how your screen will look like :

Click on the Blank desktop database.

2) Choose a name and default location. Click create.

Create a Table 

1) Select CREATE > Table from the Ribbon toolbar

2) Rename the ID field to a new name you want for your table. To do this, Right-click on the ID column and select Rename Field. Enter the new table name.

3) On the next field, click on Click to Add (unless Access has already opened the menu for you) and select Short Text:

At this point, Access will conveniently highlight/select the field name (currently Field1). Enter the new field name.

4) If you wanto to enter date or time, click on Date & Time data type and name the field. For example, let's say you name the field as DateCreated :

Switch to Design View :

1) Click on the View icon at the top left.

2)At this point, Access will ask you to name and save the table you just created. Type your table name and click OK:

3) You are now looking at your Customers table in Design view. Click on the DateCreated field, then in the bottom pane, enter =Now() in the Default Value field. Also click in the Format field and select General Date from the contextual menu:

We have just set a default value for the DateCreated field. This means that, whenever a new record is entered, this field will automatically be populated with the current date and time. We have also specified a format for all dates that are stored in this field.

4) You can easily switch back to Datasheet View by clickin on the View icon at the top left ( just like when you switch to design view). Select the Datasheet View. This is how it looks like :

Basic skills (Formatting Pages) in Microsoft Words

Hello everyone, today i would like to share some basic knowledge about Microsoft Words. Here are some topics that I will be covering ;

• Adjust page margins
• Header and footer

1) Adjust Page Margins

What is page margins?
- Margins are the space between the edge of the paper and the text. You can adjust the right, left, top, and bottom margins of your document.

Page Margins

How to Adjust Page Margins?

-Step 1 : Make sure you open the document. (If you want the margins to be applied only to a selected part of a document, select that particular part)

- Step 2 : Click the Page Layout tab, and click the Margins button in the Page Setup group. This will display a list of options to be selected but you have to click the Custom Margins option available at the bottom.

- Step 3 : You will have to display a Page Dialog Box as shown below where you can set top, left, right and bottom margins under the Margins Tab. Select the Apply to: option to apply the margin on selected text or complete document.

-Step 4 :  If you are going to bind the document and want to add an extra amount of space on one edge for the binding, enter that amount in the Gutter text box, and select the side the gutter is on with the Gutter Position drop-down list. Maku sure you sets all the desired values for all the margins, then click the OK button to apply the margins.

2) Header and Footer

What is Header and Footer?

- They are parts of a document that contain special information such as page numbers and the total number of pages, the document title, company logo, any photo, etc. The header appears at the top of every page, and the footer appears at the bottom of every page.

How to Add Header and Footer?

- Step 1 : Click the Insert tab, then click the Header button or the Footer button that which needs to be added first. For example, if you choose the header button, when you click on the Header Button, it will display a list of built-in Headers from where you can choose any of the headers by simply clicking on it.

- Step 2 : Once you chose any of the headers, it will be applied to the document in editable mode. The text in your document will appear dimmed, Header and Footer buttons appear on the Ribbon and a Close Header and Footer button will also appear at the top-right corner.

Step 3 : You can type your information whatever you want to have in your document header. Once you are done, click Close Header and Footer to come out of the header insertion mode. You will see the final result as follows.

* You can use the same steps for footers

Turn your PowerPoint slide into a video

You have two options for turning your presentation into a video that's ready to view:


1) Save/export your presentation to a video file format (.mp4 or .wmv)

• On the File menu, select Save to ensure all your recent work has been saved in PowerPoint presentation format (.pptx).

• Click File > Export > Create a Video. (Or, on the Recording tab of the ribbon, click Export to Video.)

• In the first drop-down box under the Create a Video heading, select the video quality you want, which pertains to the resolution of the finished video. The higher the video quality, the larger the file size. (You may want to test them to determine which one meets your needs.)

Option	Resolution	For displaying on
Ultra HD (4K)*	3840 x 2160, largest file size	Large monitors
Full HD (1080p)	1920 x 1080, large file size	Computer and HD screens
HD (720p)	1280 x 720, medium file size	Internet and DVD
Standard (480p)	852 x 480, smallest file size	Portable devices

* The Ultra HD (4K) option is only available if you're using Windows 10.

• The second drop-down box under the Create a Video heading tells whether your presentation includes narration and timings. (You may switch this setting if you like.)

         - If you haven't recorded timed narration, by default the value is Don't Use Recorded Timings               and Narrations.

        - The default time spent on each slide is 5 seconds. You can change that timing in the Seconds               to spend on each slide box. To the right of the box, click the up arrow to increase the duration,             or click the down arrow to decrease the duration.

        - If you have recorded a timed narration, by default the value is Use Recorded Timings and                    Narrations.

• Click Create Video.

•  In the File name box, enter a file name for the video, browse for the folder that will contain this file, and then click Save.

• In the Save as type box, choose either MPEG-4 Video or Windows Media Video.

          -You can track the progress of the video creation by looking at the status bar at the bottom of               your screen. The video creation process can take up to several hours depending on the length               of the video and the complexity of the presentation.

         -Tip: For a long video, you can set it up to be created overnight. That way, it’ll be ready for you            the following morning.

• To play your newly-created video, go to the designated folder location, and then double-click the file.

2) Save as a PowerPoint Show

• On the File menu, select Save to ensure all your recent work has been saved in PowerPoint presentation format (.pptx).

• On the File menu, select Save As.

• Choose the folder location where you want to store your PowerPoint Show file.

• In the Save as type box, choose PowerPoint Show (*.ppsx).

• Select Save.

For more understanding, you can watch this youtube tutorial :

https://www.youtube.com/watch?v=AGSk_ynrvTA